Payroll Archive Errors for Some Employees: ORA-20001: Error In Pay_us_action_arch.process_actions
(Doc ID 2807250.1)
Last updated on SEPTEMBER 23, 2021
Applies to:
Oracle HRMS (US) - Version 12.1.3 and laterInformation in this document applies to any platform.
Symptoms
Payroll Archive concurrent process completes in error for some employees. The errors are found in the log file,
ERROR
-----------------------
HR_6881_HRPROC_ORA_ERR
SQLERRMC ORA-20001: Error in pay_us_action_arch.process_actions
ORA-06512: at "APPS.PAY_ARCHIVE", line 1234
ORA-06512: at line 3
SQL_NO 1108
TABLE_NAME pay_archive.process_employee
APP-PAY-06881: Error ORA-20001: Error in pay_us_action_arch.process_actions
ORA-06512: at "APPS.PAY_ARCHIVE", line 1234
ORA-06512: at line 3
has occurred in table pay_archive.process_employee at location 1108
Cause: an oracle error has occurred. The failure was reported on table pay_archive.process_employee at location 1108 with the error text ORA-20001: Error in pay_us_action_arch.process_actions
ORA-06512: at "APPS.PAY_ARCHIVE", line 1234
ORA-06512: at line 3
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
From US HRMS Manager or equivalent: Navigate: Processes and Reports > Submit Processes and Reports > Single Request
1. Run Payroll Process concurrent process
2. Run Prepayments concurrent process
3. Run Payroll Archive concurrent process
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |