Web ADI With Very Simple Example

Document on Oracle WebADI

(Application Desktop Integrator)

Advantage of WebADI

• Load data into database tables

• Familiar medium (Excel) 

• User Friendly 

• FTP tool is not required 

• No need to provide access of server to end user

Step 1

 Step 2

    Set the profile as per below screen shot

    BNE Allow No Security Rule - Yes 

     

 Step 3

Step 4 

Create Following database objects

CREATE TABLE XXDEPT

(

   DEPTNO   NUMBER,

   DNAME    VARCHAR2 (20)

);

CREATE TABLE XXEMP

(

   EMPNO   NUMBER,

   ENMAE   VARCHAR2 (20)

);

CREATE OR REPLACE PACKAGE XX_DEPT_EMP_PACK

IS

   PROCEDURE XX_DEPT_EMP (P_DEPT_NO      NUMBER,

                          P_DEPT_NAME    VARCHAR2,

                          P_EMPNO        NUMBER,

                          P_ENAME        VARCHAR2);

END XX_DEPT_EMP_PACK;

CREATE OR REPLACE PACKAGE BODY XX_DEPT_EMP_PACK

IS

   PROCEDURE XX_DEPT_EMP (P_DEPT_NO      NUMBER,

                          P_DEPT_NAME    VARCHAR2,

                          P_EMPNO        NUMBER,

                          P_ENAME        VARCHAR2)

   IS

   BEGIN

      INSERT INTO XXDEPT

           VALUES (P_DEPT_NO, P_DEPT_NAME);

      INSERT INTO XXEMP

           VALUES (P_EMPNO, P_ENAME);

      COMMIT;

   END;

END;

Step 5

Create customer integrator 

1. Add Desktop Integrator Responsibility

Navigate to  as per below screen shot 

  Select Respective version of MS Office and Click Next

Select content as None

Click Next and Create Document

Now the system will prompt you to open the Excel

Click on Open and wait until the Template Loads

Enter the Data following Respectively to Create the Document

Metadata Type                 => CREATE 

Application Short Name  => XXNMPT 

Integrator User Name      => User Defined Name (Template Name) 

API Procedure Name       => XXMP_DEPT_EMP 

API Package                     => XXMP_DEPT_EMP_PACK 

Interface Parameter          => Any Name 

API Type                          => Procedure

Step 6 

Define Layout

Navigate Desktop Integrator à Define Layout

Define the Layout Name “User Defined Name” and Click on Next

Select the Headers and Lines for the columns in which you want to Design the Template

Click on Next and Apply

Close the Application

Again Click on Create Document and select the Integrator which you Created

Select the MS Office Verison

Select the Content as None

Click on Create Document

Open the Excel and Enter the Data

Enter the Data and upload

Check whether the Data has been Uploaded or Not

SELECT * FROM XXDEPT

SELECT * FROM XXEMP

Happy Learning  :)               

        By                          

ERP Cirlces Team