How to call Web ADI from Oracle Responsibility

Create "Form Function"

Navigation: Application Developer --> Application --> Function

 

Function Name: XXINTF_VOLUMES_ACCRUALS_FN

User Function Name:  XXINTF Volume Accruals WebADI download

Description: XXINTF Volume Accruals WebADI download

Type: SSWA servlet function

Maintenance Mode Support: None

Context Dependence: Responsibility 

HTML Call: BneApplicationService

Form: Null

Parameters: bne:page=BneCreateDoc&bne:viewer=BNE:EXCEL2003&bne:reporting=Y&bne:integrator=XXOXYINTF:CRC_DOWNLOAD_VOLUMES_XINTG&bne:layout=XXOXYINTF:CRC_DOWNLOAD_ACCRUAL_VOLUMES_L&bne:content=XXOXYINTF:CRC_DOWNLOAD_VOLUMES_CNT2&bne:noreview=N

Host Name: http://oneoxyp.oxy.com:8010

 

 

Queries to find the values for bne:Integrator, bne:Content, bne:Layout

 

Query to find the BNE Integrator

 

SELECT * FROM BNE_INTEGRATORS_TL
 WHERE INTEGRATOR_CODE = 'CRC_DOWNLOAD_VOLUMES_XINTG'
 ORDER BY LAST_UPDATE_DATE DESC;

select appropriate value from the list (if more than 1 available). The integrator used in the example provided is "CRC_DOWNLOAD_VOLUMES_XINTG"

Query to find the BNE Application

SELECT application_short_name
  FROM fnd_application
 WHERE application_id = 20011;


Query to find the BNE Layout

SELECT *
  FROM BNE_LAYOUTS_TL
 WHERE layout_code = 'CRC_DOWNLOAD_ACCRUAL_VOLUMES_L'
 ORDER BY LAST_UPDATE_DATE DESC;

select appropriate value from the list (if more than 1 available). The integrator used in the example provided is "CRC_DOWNLOAD_ACCRUAL_VOLUMES_L"

Query to find the BNE Content

SELECT *
  FROM BNE_CONTENTS_TL
 WHERE CONTENT_CODE = 'CRC_DOWNLOAD_VOLUMES_CNT2'
 ORDER BY LAST_UPDATE_DATE DESC;

select appropriate value from the list (if more than 1 available). The integrator used in the example provided is 'CRC_DOWNLOAD_VOLUMES_CNT2'