Bursting is a feature in Oracle Fusion ERP that allows users to automatically distribute reports and documents to multiple recipients based on predefined criteria. We use Bursting for distributing invoices, statements, and other business documents to customers, vendors, or internal stakeholders. In this guide, we’ll explore how bursting works in Oracle Fusion ERP and how to implement it effectively
Understanding Bursting
Bursting involves the automatic generation and distribution of multiple output documents from a single report or data set. It allows users to define bursting criteria, such as customer accounts, regions, or departments, and automatically create and deliver personalized reports to each recipient based on these criteria.
Implementing Bursting in Oracle Fusion ERP
1. Define Bursting Criteria:
Determine the criteria for bursting, such as customer accounts, sales regions, or product categories and define rules for document format and delivery.
- We use Split By element to determine how the data is split.
- We need to specify Deliver By element to tell how formatting and delivery options are applied.
- The Delivery Query is a SQL query that you define for BI Publisher to construct the delivery XML data file. The query must return the formatting/delivery details.
2. Configure Data Model:
Customize the data model to include the necessary data fields for personalizing the output documents. Ensure that the data model aligns with the bursting criteria defined earlier.
3. Design Template Layout:
Design report templates or document layouts that will serve as the basis for the burst output. Enable bursting option in your template layout and choose bursting definition as shown below.
4. Configure Bursting Definition:
Define bursting definitions in Oracle Fusion ERP, specifying the bursting criteria, data model, template layout, and delivery options. Test the bursting definition to ensure it functions as expected.
5. Run Bursting Process:
Run the bursting process in Oracle Fusion ERP to generate and distribute the output documents to the specified recipients.
Set up a schedule for the bursting process to run automatically at specific intervals or based on certain events. The reports will be generated and distributed on a regular basis without manual intervention. To send the report output via email, we need to schedule the report and set the output to bursting definition to determine the destination. Please choose enable bursting to determine output and destination as shown below.
6. Monitoring Bursting Results
We need to verify and ensure that reports are delivered to the right recipient according to defined criteria and format. For bursting to sFTP, you may need to monitor target ftp folder for arrival of new files after schedule run.
Note: For information on bursting, please refer to https://docs.oracle.com/cd/E21764_01/bi.1111/e18862/T527073T555155.htm
Conclusion
Bursting in Oracle Fusion ERP streamlines the process of generating and distributing personalized reports and documents to multiple recipients. By defining bursting criteria, configuring data models and templates, and automating the bursting process, organizations can improve efficiency, accuracy, and scalability in their document delivery workflows.