Payrun Not Processing For One Employee (Doc ID 1528481.1)

Last updated on JANUARY 12, 2017

Applies to:

Oracle Payroll - Version 12.1.3 and later
Information in this document applies to any platform.
***Checked for relevance on 30-JUL-2014***

Symptoms

On : 12.1.3 version, Core Payroll - General

ACTUAL BEHAVIOR
---------------
When running payroll run or quickpay, the process takes a very long time to complete.
The most expensive SQL is:
SELECT PROCESS.RESULT_VALUE DIRNUM
FROM
PAY_ASSIGNMENT_ACTIONS PAA , PAY_PAYROLL_ACTIONS PPA , PER_TIME_PERIODS PTP ,
  PER_TIME_PERIODS PTP_ALL , PAY_ASSIGNMENT_ACTIONS PAA_ALL ,
 PAY_PAYROLL_ACTIONS PPA_ALL , PAY_RUN_RESULTS PRR_LS ,
 PAY_RUN_RESULT_VALUES TARGET , PAY_BALANCE_FEEDS_F FEED ,
 PAY_RUN_RESULT_VALUES PROCESS , PAY_INPUT_VALUES_F PROCESS_IV ,
 PAY_BALANCE_TYPES PBT , PAY_ELEMENT_TYPES_F PET , PAY_INPUT_VALUES_F PIV
 WHERE PAA.ASSIGNMENT_ACTION_ID = :B1 AND PPA.PAYROLL_ACTION_ID =
 PAA.PAYROLL_ACTION_ID AND PTP.TIME_PERIOD_ID = PPA.TIME_PERIOD_ID AND
 PTP_ALL.PRD_INFORMATION1 = PTP.PRD_INFORMATION1 AND PPA_ALL.TIME_PERIOD_ID =
  PTP_ALL.TIME_PERIOD_ID AND PAA_ALL.PAYROLL_ACTION_ID =
 PPA_ALL.PAYROLL_ACTION_ID AND PAA_ALL.ASSIGNMENT_ID = PAA.ASSIGNMENT_ID AND
 PAA_ALL.ACTION_SEQUENCE  PRR_LS.ASSIGNMENT_ACTION_ID = PAA_ALL.ASSIGNMENT_ACTION_ID AND
 PRR_LS.STATUS IN ('P', 'PA') AND TARGET.RUN_RESULT_ID =
 PRR_LS.RUN_RESULT_ID AND FEED.INPUT_VALUE_ID = TARGET.INPUT_VALUE_ID AND
 PPA_ALL.EFFECTIVE_DATE BETWEEN FEED.EFFECTIVE_START_DATE AND
 FEED.EFFECTIVE_END_DATE AND PROCESS.RUN_RESULT_ID = PRR_LS.RUN_RESULT_ID
 AND PROCESS.INPUT_VALUE_ID = PROCESS_IV.INPUT_VALUE_ID AND PROCESS_IV.NAME =
  'Tax Directive Number' AND PPA_ALL.EFFECTIVE_DATE BETWEEN
 PROCESS_IV.EFFECTIVE_START_DATE AND PROCESS_IV.EFFECTIVE_END_DATE AND
 FEED.BALANCE_TYPE_ID = PBT.BALANCE_TYPE_ID AND PBT.BALANCE_NAME = 'Tax on
 Lump Sums' AND PET.ELEMENT_NAME NOT LIKE 'Medical Tax Credit Used on
 LMPSM%' AND PET.ELEMENT_TYPE_ID = PIV.ELEMENT_TYPE_ID AND
 PPA_ALL.EFFECTIVE_DATE BETWEEN PET.EFFECTIVE_START_DATE AND
 PET.EFFECTIVE_END_DATE AND PIV.INPUT_VALUE_ID = TARGET.INPUT_VALUE_ID ORDER
 BY PAA_ALL.ACTION_SEQUENCE , PROCESS.RESULT_VALUE


call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.06 0.06 0 0 0 0
Fetch 2 10010.32 9825.63 4986 3260874812 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 4 10010.38 9825.69 4986 3260874812 0 1


EXPECTED BEHAVIOR
-----------------------
To finish in a few seconds/minutes

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run payroll/ quickpay

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

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