Oracle Fusion HCM Extracts : Chapter 7: Bursting and Scheduling Extracts

 

Chapter 7: Bursting and Scheduling Extracts

🔷 Objective

Learn how to automate HCM Extract delivery using Bursting logic and Scheduling features to ensure timely reporting to users or external systems.

🔷 What is Bursting?

Bursting allows you to split extract output based on specific criteria (e.g., by department, location) and deliver it to different recipients (e.g., managers, regional HRs).

🔷 Use Cases

• Send department-wise employee reports to managers

• Distribute payroll summaries per business unit

• Email location-based rosters to HR admins

🔷 Steps to Configure Bursting

Step 1: Design the Bursting Control File

• XML file containing delivery criteria, output format, and destination

• Format example:

<Bursting>
  <Delivery>
    <OutputFormat>pdf</OutputFormat>
    <Destination>Email</Destination>
    <EmailToColumn>EMAIL_ADDRESS</EmailToColumn>
  </Delivery>
</Bursting>

Step 2: Generate XML from Extract

• Submit extract

• Download sample output XML

• Use for testing BI Publisher template

Step 3: Configure Bursting in BI Publisher

• Go to: Tools → Reports and Analytics → BI Publisher

• Upload bursting file under Report Properties → Bursting

Step 4: Add Bursting Option in Extract

• In Delivery Options, choose “BI Publisher”

• Assign Report, Layout, and Bursting File

🔷 Scheduling HCM Extracts

How to Schedule:

1. Navigator → Tools → Scheduled Processes

2. Submit Process: 'Submit Extract'

3. Parameters: Provide Extract Name, Effective Date

4. Use 'Advanced' to set frequency: Daily, Weekly, etc.

Use Case Example

Monthly Department Report:

• Extract generates employee list

• BI Publisher formats output to PDF

• Bursting file sends PDFs to department heads

• Schedule to run every 1st of the month

💡 Tips:

• Test bursting logic on small data

• Validate email addresses and format

• Use Preview option before final runs

🏁 Conclusion

Bursting and Scheduling transforms manual extract processes into efficient, automated reporting systems that ensure timely, targeted data delivery. Next, we’ll cover troubleshooting and debugging tips.

🔹 Next Steps

Previous Chapter:  Chapter 6: Output File Formatting and BI Publisher Integration

Next Chapter:  Chapter 8: Troubleshooting and Debugging Extracts