Bursting Query in Oracle Fusion HCM

In BI Publisher, you can implement bursting to deliver personalized reports to multiple recipients based on specific criteria. To achieve this functionality, you would need to use BI Publisher in conjunction with data from Oracle Fusion HCM.

Here’s an outline of the steps to perform bursting in Oracle BI Publisher with data from Oracle Fusion HCM:

1. Create a Data Model: Define a data model in BI Publisher that connects to the Oracle Fusion HCM database or any relevant data source containing the required report data.
2. Design the Report Template: Design your report layout using the BI Publisher template editor, incorporating data fields from the data model.
3. Set Up Bursting: In BI Publisher, you can create bursting definitions using the data elements in the data model as bursting keys. These keys determine how the report output will be split and delivered to individual recipients based on specific attributes (e.g., department, location).
4. Define Delivery Options: Specify the delivery method for each burst output, such as email, file storage, or printer. You can also customize the report output format (e.g., PDF, Excel) for each recipient.
5. Schedule the Report: Set up a report job to run the bursting process and schedule the report to be generated and delivered to the recipients at a specified time.