Making a DFF Segment Read Only

Many times We are faced with a requirement of making one or more segments of a DFF as Read Only.


This can be achieved by configuring a special value set which when attached to a segment of the value set renders it Read Only




Create a Value set as below :










Attached the Value Set to the DFF Segment


Check the DFF in Front End

Add LOV to Custom Web ADI

When creating a custom Web ADI there might be a requirement to Add an LOV to one or more fields rather than making them Free Text , Oracle provides this option and it can be achieved by changing the Integrator


Query the integrator





add a value to the default type


click on Update





LOV type is selected as standard so that value is fetched dynamically. If needed where clause conditions can be added too





You can add the Hint text so that end user is aware of an LOV availability


Save the changes. Once you open the ADI Upload sheet LOV appears as below



Click to see the LOV

Create Custom Web ADI In Oracle

Create Custom Web ADI In Oracle


1. Create a Table : We need to create a table to store the information which will be Uploaded in Oracle E.g. : Item cost , Material transaction details.
2. Create a Package/Procedure : Once the ADI Upload is done we might want to process the uploaded data via a concurrent program , Thus code needs to be developed for this purpose . Create a package a procedure which will process the uploaded data . Test the code to ensure business functionality for data processing works as expected
3. Register concurrent Program : Register the code created in Step2 as a concurrent program to be called when doing ADI Upload
4. Register the table in Oracle : To be able to upload data in table via web ADI we need to register the table and related columns in Oracle. Perform this operation by using the API
: AD_DD.REGISTER_TABLE
  AD_DDD.REGISTER_COLUMN
5. Create a Custom Integrator
Log On to Desktop Integration Manager Responsibility and click on Create Integrator


1. Key in the Integrator Name and application in which you wish to register the integrator





Click on Next and Register the table by entering the table details which was registered in Step 4





As we wont do any Reporting we can skip this step and click on Next







For defining the Uploader functions chose the From Template Option. this will specify the different options oracle will show when we do the web ADI Upload



Specify the details of the concurrent program which should be launched when doing the ADI Upload , this has to be the program we registered in step3



Select Type as  : Asynchronous Request







Save the Changes


6. Create a Layout







Select the columns to display in ADI and proceed










As the changes are done , Now test the ADI by creating and uploading a document


Once succesfull we can migrate the concurrent program and ADI via LDT Files.