Enhance Performance of Global Payroll Deduction Report and Costing Results Report

The Global Payroll Deduction Report and Costing Results Report are enhanced to support large employee populations by enabling XML data split and parallel processing before BI Publisher execution.

This enhancement allows reports to successfully run even when the generated XML data size exceeds the BI Publisher memory guard limit (currently approximately 10 GB), improving scalability and performance, as given here.

  • Splits large report data into multiple XML outputs before BI processing
  • Executes each split as a separate BI Publisher job
  • Enables parallel processing of large datasets
  • Prevents BI job failures caused by excessive XML size

The following action parameters have been added to enhance performance.

ORA_MULTITHREADED_XML

  • Description - Enables multi-threaded XML generation
  • Value - Required Prerequisite
  • Default Value - Y

ORA_PAY_XML_SPLIT_CNT

  • Description - Specifies the maximum number of payroll relationship actions per XML file.
  • Value - Setting any numeric value to enables XML Split
  • Default Value - No Limit, it's disabled.

Note: You must explicitly configure the required action parameters. The XML Split function is enabled only if you enable the multi-thread XML generation action parameter.

It's important to note the following.

  • XML Split is independent of BI Publisher XML Chunking
  • XML Split and BI XML Chunking can be enabled together
  • Output files generated by XML Split are not merged
  • Consolidated output files are not available for these reports when XML Split is used

Use these features for reports involving large employee population or large XML output sizes. It's not recommended for small populations where split overhead may exceed performance benefits

Use the new XML Split and Processing action parameter to enhance report performance. The action parameter splits reports having large output data into smaller XML files while processing, thus reducing the processing time and enhancing the performance of the report.

Steps to enable and configure

You don't need to do anything to enable this feature.

Key resources

For more information see How can I enable data chunking for high-volume extracts?