Oracle WEBADI : Registration Web-adi Table

   Create table script 

     CREATE TABLE BNE.XXST_GOLD_IMPORT_INT_BNE_T

(

  OPERATING_UNIT        VARCHAR2(100),

  SOURCE                VARCHAR2(100),

  INVOICE_NUM           VARCHAR2(200),

  INVOICE_LINE_NUM      VARCHAR2(10),

  CURRENCY              VARCHAR2(20),

BILL_TO_CUSTOMER_NAME VARCHAR2(1000),

  VAT_CODE              VARCHAR2(100),

  VAT_NUMBER            VARCHAR2(100),

  VAT_DATE              DATE,

  CREATION_DATE DATE,

  USER_NAME VARCHAR2(100),

  RESPO_NAME VARCHAR2(100),

  STATUS VARCHAR2(5)

)

   ---Check Table name in Fnd_Tables 

          select * from fnd_tables where table_name='XXST_GOLD_IMPORT_INT_BNE_T';

   ---- Delete table from fnd_tables

       EXEC AD_DD.delete_table('BNE','XXST_GOLD_IMPORT_INT_BNE_T')

   ---Register Table name 

   EXEC AD_DD.REGISTER_TABLE ('BNE','XXST_GOLD_IMPORT_INT_BNE_T','T');

   --- Register Column names in Table

EXEC AD_DD.REGISTER_COLUMN ('BNE','XXST_GOLD_IMPORT_INT_BNE_T','OPERATING_UNIT',1,'VARCHAR2',100,'Y','N');

EXEC AD_DD.REGISTER_COLUMN ('BNE','XXST_GOLD_IMPORT_INT_BNE_T','SOURCE',2,'VARCHAR2',100,'Y','N');

EXEC AD_DD.REGISTER_COLUMN ('BNE','XXST_GOLD_IMPORT_INT_BNE_T','INVOICE_NUM',3,'VARCHAR2',200,'Y','N');

EXEC AD_DD.REGISTER_COLUMN ('BNE','XXST_GOLD_IMPORT_INT_BNE_T','INVOICE_LINE_NUM',4,'VARCHAR2',10,'Y','N');

EXEC AD_DD.REGISTER_COLUMN ('BNE','XXST_GOLD_IMPORT_INT_BNE_T','CURRENCY',5,'VARCHAR2',20,'Y','N');

EXEC AD_DD.REGISTER_COLUMN ('BNE','XXST_GOLD_IMPORT_INT_BNE_T','BILL_TO_CUSTOMER_NAME',6,'VARCHAR2',1000,'Y','N');

EXEC AD_DD.REGISTER_COLUMN ('BNE','XXST_GOLD_IMPORT_INT_BNE_T','VAT_CODE',7,'VARCHAR2',100,'Y','N');

EXEC AD_DD.REGISTER_COLUMN ('BNE','XXST_GOLD_IMPORT_INT_BNE_T','VAT_NUMBER',8,'VARCHAR2',100,'Y','N');

EXEC AD_DD.REGISTER_COLUMN ('BNE','XXST_GOLD_IMPORT_INT_BNE_T','VAT_DATE',9,'DATE',9,'Y','N');

EXEC AD_DD.REGISTER_COLUMN ('BNE','XXST_GOLD_IMPORT_INT_BNE_T','CREATION_DATE',10,'DATE',9,'Y','N');

EXEC AD_DD.REGISTER_COLUMN ('BNE','XXST_GOLD_IMPORT_INT_BNE_T','USER_NAME',11,'VARCHAR2',100,'Y','N');

EXEC AD_DD.REGISTER_COLUMN ('BNE','XXST_GOLD_IMPORT_INT_BNE_T','RESPO_NAME',12,'VARCHAR2',100 ,'Y','N');

EXEC AD_DD.REGISTER_COLUMN ('BNE','XXST_GOLD_IMPORT_INT_BNE_T','STATUS',13,'VARCHAR2',5 ,'Y','N');

            

Oracle Web-adi Registration

      Oracle Web-adi has used to import data from 

    Step 1-- Please assign two responsibilities 

                              1. Desktop Integration Manager

    Step 2 --- Click on Integrator 

                  click on Display on document page -- you can able to see this in document 

          XXST_GOLD_IMPORT -- custom oracle function which has used to link the web-adi to responsibility

             

Step 2

         Step 3 ---  PLSQL based interface so enter plsql procedure name 

      ---SELECT RESPONSIBILITY_NAME  FROM FND_RESPONSIBILITY_TL WHERE RESPONSIBILITY_ID = $ENV$.RESPID

      --select user_name from fnd_user where user_id=$env$.userid

   ---CUSTOM GOLDEN TAX  WEB ADI

           you can define multiple types of interface variables

  

            1-Environment Variable   --- ex sysdate

            2. SQL Query -- example --select user_name from fnd_user where user_id=$env$.userid

            3. Constant --- Example "Custom"

            4. Profile option

            5. lookup

            6.. Null --- default type as parameters of procedure.