EPYAUPYT_XML: Payroll Tax Report By Legal Employer (Australia) (XML) Takes Very Long To Complete

(Doc ID 2006602.1)

Last updated on JULY 14, 2016

Applies to:

Oracle HRMS (Australia) - Version 12.2.3 and later
Information in this document applies to any platform.

Symptoms

Spawn "Payroll Worker Process" from Australian (AU) Legislation Concurrent Request: EPYAUPYT_XML
Payroll Tax Report by Legal Employer (Australia) (XML)
are taking a large amount of time to complete.


MOST EXPENSIVE SQL

call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 73 4.33 4.32 0 0 0 0
Fetch 73 5872.31 5878.89 28 2524913 0 2589
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 147 5876.64 5883.22 28 2524913 0 2589


STEPS TO REPRODUCE
Submit the concurrent request
    Payroll Tax Report by Legal Employer (Australia) (XML)
with parameters:
    > Date = 31-DEC-2014
    > Legal Employer = <your legal employer>
    > Report Type = S

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