How to Verify WEBADI Setup and How to Modify the existing WEBADI setup

                                

     Navigation and Path to verify the custom/core WEBADI setup.

                 1. Navigate to responsibility "Desktop Integration Manager" ->Manage Integrators

                   2. When you click on Manage Integrators and search window open up, Provide  the Integrator name and click on Search in the Integrator Name field

                 3. Click on the pencil Update button for the integrator you wish to see or modify the setup, click on Next button until you see the Interface Attributes for the integrator you selected.

               4. For each field or attribute that you see there are "Default Type" and Default Value".

              5. If you want to make changes to the attribute click on pencil update icon and you will see Interface Attribute Definition page which shows more fields that you an update according to your requirement.

              6.You can attach new LOV, change prompt name, validation type and other fields.

             7.After making the changes click on save button and this saves the Integrator definition and its attribute definitions.

Query to select the Integrator related packages.

SELECT BIT.USER_NAME WEB_ADI, BA.ATTRIBUTE2 "PACKAGE", BCT.USER_NAME "VIEW"
  FROM BNE_INTEGRATORS_TL BIT,
       BNE_ATTRIBUTES BA,
       BNE_CONTENTS_TL BCT
 WHERE --substr(BIT.INTEGRATOR_CODE,1,length(BIT.INTEGRATOR_CODE)-5)||'_P0_ATT' = BA.ATTRIBUTE_CODE
    BIT.APPLICATION_ID = BCT.APPLICATION_ID
   AND BIT.LANGUAGE = 'US'
   AND BCT.LANGUAGE = 'US'
   AND BA.ATTRIBUTE1 = 'PROCEDURE'
   AND BIT.APPLICATION_ID = BA.APPLICATION_ID
  -- AND BCT.CONTENT_CODE = substr(BIT.INTEGRATOR_CODE,1,length(BIT.INTEGRATOR_CODE)-5)||'_CNT'
  -- AND BIT.USER_NAME LIKE 'XX Test Create'
  and bit.integrator_code='XX Integrator'
   order by BIT.USER_NAME;

Related Tables:

BNE_INTEGRATORS_B

BNE_INTEGRATORS_TL

BNE_ATTRIBUTES

BNE_CONTENTS_TL

BNE_LAYOUTS_B