Payroll Reconciliation Summary (New Zealand) (XML) Does Not Complete (Doc ID 2275233.1)

Last updated on JUNE 13, 2017

Applies to:

Oracle HRMS (New Zealand) - Version 12.2.5 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.5 R12.HR_PF.C.Delta.8 version, New Zealand Payroll

ACTUAL BEHAVIOR
---------------
The Payroll Reconciliation Summary (New Zealand) (XML) does not complete. It continues to run after 12 hours.

This problem is not in relation to the performance of the report generation - modifying the threads parameter or gathering statistics did not make any difference to this issue.

When this report runs there is an XML file generated in the /tmp directory. This file gets written out until it is 32k in size and then the process stops. The database session is still active however it is waiting on file IO events. Reviewing previous issues it appears there was a change made in previous versions of Oracle database that removed the limits of using the PLSQL XML API's along with UTL_FILE API's.
It appears that there is a code issue with the current implementation of this report that is limiting how bit the report temporary output can be.

EXPECTED BEHAVIOR
-----------------------
Expect the process to complete in reasonable time.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Submit Payroll Reconciliation Summary (New Zealand) (XML)

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, difficult for users to reconcile pay without it..

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