GPHKG: Performance Issue on GPHK IR56B XML Generation Process (Doc ID 1999422.1)

Last updated on MAY 02, 2017

Applies to:

PeopleSoft Enterprise HCM Global Payroll Hong Kong - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

There is a performance issue on the GPHK_I56_XML generation AE (Global Payroll & Abs Mgmt > Year-End Process > Create IR56B XML File HKG).
 
There are 2 AE in the process, i.e. GPHK_I56_XML and XMLGF_PRNT. When around 6000 employees are processed, it took around 1.5 hours. The first AE GPHK_I56_XML took 3 minutes but the second AE XMLGF_PRNT took 90 minutes to finish. It was because the function LoadIterativeNode in the Application Package XMLGF was slow. This issue was encountered in all environments.
 
Performance tuning is required.


STEPS
----------
1. Run Create IR56B XML File HKG (Global Payroll & Abs Mgmt > Year-End Process > Create IR56B XML File HKG) for 6000 employees.


Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms