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
Bursting query used:
'00121' as "KEY",
'CONTROL_REPORT' || to_char(SYSDATE, 'yyyymmdd') OUTPUT_NAME,
'Import Invoice Control Report for Source : '|| :p_source || to_char(SYSDATE,'yyyymmdd') PARAMETER4,
'Please find attached Control Report' PARAMETER5,
Detailed steps with Screenshots:
Step1: Create Data model and bursting query.
Navigation >> Tools >> Reports & Analytics >> Browse Catalog >> Create >> Data Model >> SQL Query >> provide a name, data source as Application_FSCM and put the SQL query >> ok >> add the Parameter required >> under bursting -- add the split by and delivery by and SQL Query for bursting.
Step2: Create the BIP report
From that created data model >> create report
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.
Step3: Create an ESS job and properties
Navigation >> Tools >> My Enterprise >> Setup and Maintenance >> search tasks with Manage Enterprise Scheduler Job Definitions and Job sets for Financial, SCM and..>> click on (+) button to create new ESS job
Step4 : Run ESS job from scheduled processes
Navigation >> Tools >> Scheduled Processes >> Schedule New Process >> search the ESS job >> provide the parameter values >> submit the job >>once succeeded, we will receive an email containing the BIP report.
Step 5 & 6: Call the created ess job from OIC. Follow my below blog for the steps.
Step 7: Emily delivery channel config.
Post a Comment