Payroll SLA: Create Accounting Takes a Long Time To Complete

(Doc ID 1446915.1)

Last updated on SEPTEMBER 13, 2017

Applies to:

Oracle Payroll - Version 12.1.3 and later
Information in this document applies to any platform.
*** Checked for currency on 4-NOV-2014 ***

Symptoms

The Create Accounting process (XLAACCPB module: Create Accounting) takes a long time to complete. This process is the only one affected by this performance degradation.
The process worked before without any issue. It's the first time this issue has happened and no recent changes have been performed.
 A warning message was received, but accounting was created successfully

OVERALL TIME AND TOTALS (NON-RECURSIVE AND RECURSIVE)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Total Response Response Time Elapsed Non-Idle Elapsed Time Idle Response Time
Call Time(3) Accounted-for(2) Time(1) CPU Time Wait Time Unaccounted-for Wait Time Unaccounted-for
-------- --------------- ----------------- --------- --------- ---------- ---------------- ---------- ----------------
Parse: 4.929 0.115 0.115 0.002 -0.002 4.814
Execute: 13225.721 6554.857 0.503 0.363 6553.992 6670.864
Fetch: 8.356 8.275 0.266 7.868 0.141 0.081
-------- --------------- ----------------- --------- --------- ---------- ---------------- ---------- ----------------
Total: 6718.474 13239.006 6563.247 0.884 8.233 6554.130 6675.759 -6520.532

------------------------------- --------- ---------- --------- ---------- ------- ---------- ------------ ------- --------
Total: 8.233 1172 6675.759 545
NON-RECURSIVE TIME AND TOTALS (DEPTH = 0)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Response Time Elapsed Non-Idle Elapsed Time Idle
Call Accounted-for Time CPU Time Wait Time Unaccounted-for Wait Time
-------- -------------- --------- --------- ---------- ---------------- ----------
Parse: 0.106 0.023 0.031 0.000 -0.008 0.084
Execute: 13225.303 6554.495 0.243 0.298 6553.954 6670.808
Fetch: 0.397 0.316 0.129 0.117 0.070 0.081
-------- -------------- --------- --------- ---------- ---------------- ----------
Total: 13225.806 6554.834 0.403 0.416 6554.015 6670.972


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Global SLA/Payroll Manager > Run Create Accounting


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, unable to run the process.

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