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.

Custom Web ADI in Oracle

Depending on business needs there are instances when data from outside needs to be imported into the system , When we have 2 IT systems working then we can make us of standard inbound interface methods to perform data import into Oracle.
However there can be instances where end user want to load bulk data into oracle for Example business might want to create Journals for Misc Expenses  for this we have inbuilt upload functionality in form of Web ADI.
However this is not available for all the functionalities , Eg : If business wants to update cost of Items , Upload data to perform misc transactions for some purposes etc. In order to facilitate these functions we can create custom Web ADI which can be used by business .


Below steps can be followed to create a custom Web ADI , we are taking an example of ADI  for Uploading item Cost

Step	Action to Perform
1	Create a custom Table to load cost
2	Create a Custom Package to process the loaded item cost
3	Register the Table in Oracle
4	Register Concurrent program for Package in Step2
5	Create a Custom Integrator
6	Create a Layout for the Integrator
7	Perform ADI Test
8	Component Migration via LDT

We will cover the details in the upcoming post

Delete Item Cost

Item cost can be Deleted using 2 options

• Item cost Screen --> the user needs to query the item cost from the item master screen and delete the cost details (cost elements) or complete item cost
• Perform clean up from item cost tables --> In this scenario when we have to perform bulk data cleanup we can create script to do bulk updates. Data a given item , warehouse and cost type needs to be deleted from the table: CST_ITEM_COSTS and CST_ITEM_COST_DETAILS , The data need to be deleted if complete cost need to be deleted. If we need to do bulk updates or delete for some cost element then we need to delete data from CST_ITEM_COST_DETAILS table and perform updates in the columns of table CST_ITEM_COSTS to ensure the item cost is consistent , as if a sub element cost is updated then the total cost should reflect the change