US: Year End Pre Process (YEPP) Generates Error In FF_arc_shd.Chk_value Step 20 (Doc ID 756498.1)

Last updated on DECEMBER 20, 2016

Applies to:

Oracle HRMS (US) - Version 11.5.10.2 and later
Information in this document applies to any platform.
ConcurrentProgram:W2EOY - Year End Pre-Process



Symptoms


When attempting to run Year End Pre-Processor (YEPP)  the following error occurs:

ERROR
HR_6881_HRPROC_ORA_ERR
SQLERRMC ORA-20001: Error in eoy_archive_data at step : 54 - -20001-ORA-20001: System Error:
Procedure ff_arc_shd.chk_value at Step 20

Cause: The procedure ff_arc_shd.chk_value has created an error at Step 20.

Action: Contact your system administrator quoting the procedure ff_arc_shd.chk_value and Step 20.
ORA-06512: at "APPS.PAY_ARCHIVE", line 1207
ORA-06512: at line 3

SQL_NO 1108
TABLE_NAME pay_archive.process_employee
APP-PAY-06881: Error ORA-20001: Error in eoy_archive_data at step : 54 - -20001-ORA-20001: System
Error: Procedure ff_arc_shd.chk_value at Step 20

Cause: The procedure ff_arc_shd.chk_value has created an error at Step 20.

Action: Contact your system administrator quoting the procedure ff_arc_shd.chk_value and Step 20.
ORA-06512: at "APPS.PAY_ARCHIVE", line 1207
ORA-06512: at line 3 has occurred in table pay_archive.process_employee at location 1108

 

Steps To Reproduce:
The issue can be reproduced at will with the following steps:

  1.  In US HRMS Manager Responsibility navigate Processes and Reports - Submit Processes and Reports - Single Request
  2. Submit the Year End Pre-Processor for the Year and parameter for the Government Reporting Entity (GRE)




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