My Oracle Support Banner

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 later
Information 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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.