Create a custom WEBADI (Item Master) to upload data from excel into Oracle server in Oracle APPS r12

Purpose: In this post we will see how to create a custom WebADI to upload data into oracle from excel. WebADI is tool to upload data in Oracle database directly using excel. Here we will see how to create WebADI for Item Master.

Steps:

·         First add two responsibilities to the user:

o   Desktop Integration Manager

o   Desktop Integrator

·         Navigate to responsibility Desktop Integration Manager.

·         Click on Create Integrator.

·         Enter the Integrator details as mentioned in the below image. Keep the “Display in Create   Document Page” checkbox tick. Click on “Next” button.

·         Enter the Interface details as:

o   Interface Name: XX_ITEM_MASTER_IN

o   Interface Type  : API – Procedure

o   Package Name : XX_INV_ITEM_IMPORT_PKG

o   Procedure Name : insert_interface

o   API Returns      : FND Message Code

·         Click on “Next” button.

·         Click on “Select” radio button to see the interface attributes.

·         All the parameters of the procedure will automatically appear as attributes. 
·         Here we can define default values, LOVs, Enabled, Displayed properties for the attributes.

·         To define the LOVs for the attributes click on “Update” icon. Enter the values as mentioned below:

o   Validation Type    : Table

o   Id Column               : ORGANIZATION_NAME

o   Meaning Column : ORGANIZATION_NAME

o   Desc Column         : ORGANIZATION_NAME

o   Validation Entity  : ORG_ORGANIZATION_DEFINITIONS

o   LOV Type                 : Pop List

·         Click on “Apply” button.

·         In case pre filled data is required then Content is created. Here we don’t need pre filled data so click on “next” button.

·         Here we will define Uploader. Select “From Template” and click on “Create” button.

·         Here we can select the display, enable, required properties of the Uploader parameters.

·         Click on “Update” icon to update values of the parameters.

·         Define Parameter Name, Display Name, Data Type, Default value, Enable, Required properties and click on the “Apply” button.

·         Click on “next” button.

·         Here we will define the Importer.

·         There are 3 type of Importer:

o   Synchronous – (The process or block will be blocked until the program completes)

o   Asynchronous – (The process will resume after initiating the program)

o   PL/SQL API – (Call the PL/SQL Program unit)

·         Here we will use PL/SQL API. Enter the “Importer Name”.

·         Click on update icon (PL/SQL API call) to specify the PL/SQL Program unit.

·         Enter the Package Name, Procedure Name in the window and click on “Apply” button.

·         Click on the “Submit” button.

·         Now we will create the Layout. Navigate to the “Desktop Integrator” responsibility and click on “Define Layout”.

·         Select the Integrator and click on “Go” button.

·         Click on “Create” button. 
·        Enter the “Layout Name” and select “Number of headers” and then click on “Next” button.

·         Select the Placement (attribute will be displayed at Header or Line), default values of the attributes. Click on “Next” button.

·         Here we will specify the sequence, data entry rows, read only, width of the attributes (fields).

·         Click on “Apply” button.  


·         Now we will create the document. Navigate to “Desktop Integrator” and click on “Create Document”. 
·         Change the Internet explorer and excel settings (Change the settings? Click here) before downloading the document. 
·         Select the Integrator and click on “Next” button. 
·         Select the excel version and click on “Next” button. 
·         Click on “Create Document” button. 
·         Now the excel file will be downloaded. Open the downloaded file, you will see the Oracle menu item (in some excel version it is visible in Add - Ins) Insert the data into excel sheet and click on Oracle -> Upload.