Generic Upgrade Mechanism Concurrent Program US: Migrate Ethnic Origin Data Errored Out (Doc ID 1350111.1)

Last updated on AUGUST 10, 2017

Applies to:

Oracle HRMS (US) - Version 11.5.10.2 to 12.1.3 [Release 11.5 to 12.1]
Oracle HRMS (US) - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

When attempting to run the process - Generic Upgrade Mechanism with parameter US: Migrate Ethnic Origin Data from person to EIT, as a post install step after applying the US HR 2011 Annual Statutory Patch for Release for 11i, 12.0.X,or 12.1.X - the following error can occur.

HR_6859_HRPROC_OTHER_PROC_ERR APP-PAY-06859: An error has been detected by another process.

Cause: During processing, the master or another slave process has detected an error, communicated by setting the Payroll status to Error.

Action:Examine the error log file and payroll messages to investigate the cause of the error.

And Following Error in the log file:

HR_6881_HRPROC_ORA_ERR
SQLERRMC ORA-20001:
ORA-06512: at "APPS.PAY_ARCHIVE", line 1207
ORA-06512: at line 3

 

Steps to Reproduce:
The issue can be reproduced with the following steps:

1. Submit concurrent request Generic Upgrade Mechanism with following parameters:

US: Migrate Ethnic Origin Data from person to EIT

2. Fails with Error.

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