Payroll Archive Error for Terminated employees - Error ORA-20001: Error In Pay_us_action_arch.process_actions (Doc ID 1612833.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

On : 12.1.3 version, US Payroll - General

When attempting to run payroll archive for employees have terminated assignments
the following error occurs.

ERROR
-----------------------
Error ORA-20001: Error in pay_us_action_arch.process_actions ORA-06512: at "APPS.PAY_ARCHIVE", line 1207 ORA-06512: at line 3 has occurred in table pay_archive.process_employee


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. terminate employee on 28-sep-2013
2. re-hire with new assignment number on 5-oct-2013
3. terminate the new assignment on 12-oct-2013


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot complete payroll archive to pay the terminated employees

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