Fusion Global HR: List of BI and Payroll Parameters that Can Help with HCM Extract Performance and How to Use the Output of the Design and Run Time HCM Extract Diagnostics to Prevent and Improve Slow Performance of HCM Extracts (Doc ID 2036889.1)

Last updated on APRIL 17, 2023

Applies to:

Oracle Fusion Global Human Resources - Version 11.12.1.0.0 and later
Oracle Fusion Global Human Resources Cloud Service - Version 11.13.22.10.0 and later
Information in this document applies to any platform.
This note was created for Release 11.1.9.2.0. The note has been reviewed and is current for release 11.13.21.01.0.

Goal

This Note lists the extract BI and Payroll parameters that help with the performance of HCM Extract.

The goal is to map these parameter settings to the HCM runtime diagnostic so that when a user has issues with extract performance, you can easily identify which parameters are set by looking at the output of the runtime diagnostic.

The Runtime diagnostics show you the values of the parameters you have set, and the Design Diagnostics let you look at the ones you have set and determine if there are others you can set to optimize performance.

Example: If you have this parameter set "Split and Process large XML output Process configuration to enable BIP to split large XML output from Extracts unto multiple chunks to allow for parallel processing and large after processing", do you have to also set the Threads and Chunk Size parameters in the Manage Payroll Process Configuration user interface (UI).