OIC - Schedule BI Publisher Report through OIC | Oracle Integration Cloud | Schdule report Service

Usecase:

Here, we will see how to call a schedule BI publisher report service( with BI bursring to FTP).

When to use Run Report operation:

• In Laymen term, use Run report operation if report output size is less than 10MB. 
• Run report operation will provide the report output in the webservice response.

When to use Schedule Report operation:

• Use "Schedule Report" operation when report output is > 10MB. 
• Schedule report will generate the report output in FTP, UCM, Email etc. Which is known as BI report bursting.

High level steps:

1. Create a Schedule service Soap connection
2. Take a Schedule orchestration integration and call Schedulw service operation and map all the required patameters 
3. Take a while loop and call getScheduledReportStatus operation to get the BI run status
4. You should have a BI report with Bursting data model option, here we are bursting the report to FTP delivery.

Implementation steps:

Create Schedule service SOAP connection

https://soalicious.blogspot.com/2022/05/oic-create-schedule-service-soap.html 

Integration flow:

Create a Scheduled Orchestration Integration

Provide a name and package

Select the created Soap connection for schedule report service.

Configure the Schedule service operation.

Now open the mapper and the map the required parameters name and its values.

Below Columns mappings are required to invoke Schedule BI report operation.

I have provided the following details:

attributeTemplate : "pdf"

parameterNameValues

name: "p_destination"

Values item: " FTP full path"

reportAbsolutePath: "/Custom/Integrations/Poc/XXSupplierREP1.xdo"

sizeOfDataChunkDownload: "-1"

scheduleBurstingOption: "true"

userJobDesc: instancd id

userJobName: instance id

userId: ERP Service account user

password: ERP Service account pwd

Note: we cant use getFlowId() instead, use  metadata >> runtime >> instanceid. If we use getFlowId, the integration will run continuously and fail. May be it does not support anymore

Mappings:

Next, we will assign counter and loop till we get the GetScheduledReportstatus and then update the counter.

Add tracking

Activate

Test and see the outcome.

File generated in the ftp directory

From Monitoring:

To create a BI Bursting report and data model, follow my blog:

https://soalicious.blogspot.com/2022/03/oic-erp-bi-bursting-steps.html

Note:

You can also use below ScheduleReport service but you can only call the schedule service, there is not "getScheduledReportStatus" operation available.

https://<ERP domain name>/xmlpserver/services/ScheduleReportWSSService?WSDL