Tuesday, October 27, 2015

Oracle Web ADI Scripts

-- The main tables in ADI are as follows:
BNE_CONTENTS_TL
BNE_INTEGRATORS_TL
BNE_INTERFACES_TL
BNE_INTERFACE_COLS_TL
BNE_LAYOUTS_TL
BNE_LAYOUT_COLS
BNE_MAPPINGS_TL



-- Sample script to print out integrator details. Note only update integrators have apis. Reporting_Flag='N' Otherwise they are associated with the _INTFC entity
SELECT DISTINCT
  substrb(bit.application_id,1,12) APP_ID,
  substrb(bit.user_name,1,35) INTEGRATOR_NAME,
  bl.reporting_flag,
  substrb(blcv.layout_code,1,35) INTEGRATOR_LAYOUT,
  substrb(biv.user_name,1,30) ASSOC_VIEW,
  substrb(biv.interface_name,1,20) API,
  substrb(biv.upload_type,1,3) TYPE
FROM
  bne_integrators_tl bit,
  bne_layout_cols_v blcv,
  bne_layouts_b bl,
  bne_interfaces_vl biv
WHERE
  bit.INTEGRATOR_CODE  = biv.INTEGRATOR_CODE
AND biv.interface_code = blcv.INTERFACE_CODE
AND bit.integrator_code=bl.integrator_code
AND upper(bit.user_name) LIKE upper('%&&Integrator_name%')
ORDER BY
  bl.reporting_flag


 
-- Sample script to print out all GENERAL integrators for different applications
SELECT
  application_id,
  language,
  source_lang,
  INTEGRATOR_CODE,
  SUBSTR(USER_NAME,1,30)
FROM
  BNE_INTEGRATORS_TL
WHERE
  APPLICATION_ID IN (800,nnn,etc)
AND INTEGRATOR_CODE LIKE 'GENERAL%'
ORDER BY
  application_id


 
-- Sample script to find integrators associated with a form function
SELECT
  security_code Integrator,
  security_type Type,
  security_value FUNCTION
FROM
  bne_security_rules
WHERE
  application_id   =800

AND security_value = '&function_name'

No comments:

Post a Comment

Best Blogger TipsGet Flower Effect