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