Usecase: Here, we will see how to burst a BIP report using Email Delivery channel.
- Create a BIP data model and email busting query.
- Create a BIP report based on step1 data model.
- Create an ESS job to call the BIP report anx add properties
- Run the ESS job from Scheduled processes section
- OIC - Create an Oracle ERP Cloud connection
- OIC - Create an integration and call the erp adpater and ErpIntegrationService and run the ESS job
- ERP Email delivery channel configuration
Save the report under Custom folders
Then edit the report >> view a list >> change the output formats and default format as required >> save
Open the report and test.