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.