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.
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.
No comments:
Post a Comment