ERP BI - How to call OIC rest integrations from BI report

Usecase: Here, we will show how to invoke OIC rest integrations using BIP Report.

Note: This approach only supports XML response.

Here, we will use Get verb and feed a emp id as input  from BI reprot and get xml response status.

Implementation steps:

1. Create a rest connection and create a application integration where configure the rest trigger as below
1. Verb: get
2. EmpId as Query parameter
3. Upload XSD for response
2. Go to ERP Administration >> create a http connection data source and provide details as below
1. Data source name
2. Service protocol: https
3. Server : oic instance or host name
4. Port: 443
5. Session timeout: 500
6. Username and password
7. Add below roles under security
1. BI Administrator Role
2. BI Author Role
3. BI consumer Role
4. BI system role
8. Create data model
9. Create a parameter as P_empId
10. Create data set as  HTTP xml feed and provide details as below
1. Name
2. Select data source
3. Provide URL suffix
4. Method: Get
5. Add parameter
11. Go to data tab and view to test and save data as sample
12. Create report and test

Detailed screenshots:

Reference for more details:

https://docs.oracle.com/middleware/12212/bip/BIPDM/GUID-593CA9CB-B822-47C1-BDF0-962F4A5EBAA1.htm#BIPDM498