US Year End Pre processor fails for all GRE's with error APP-PAY-06881: Error ORA-20001: eoy_archinit at 12 ORA-20001 (Doc ID 397462.1)

Last updated on DECEMBER 20, 2016

Applies to:

Oracle HRMS (US) - Version 11.5 to 12.1.1 [Release 11.5 to 12.1]
Oracle HRMS (US) - Version 11.5.10.2 and later
Information in this document applies to any platform.
Concurrent Program: W2EOY - Year End Pre-Process


Reviewed for relevance on 03-SEP-2014


Symptoms

Submit process and reports > single request > Year End Pre Processor fails with error

HR_6881_HRPROC_ORA_ERR
SQLERRMC ORA-20001: eoy_archinit at 12 - -20001-ORA-20001:
ORA-06512: at "APPS.PAY_ARCHIVE", line 550
ORA-06512: at line 3

SQL_NO 1101
TABLE_NAME pay_archive.arch_initialise
APP-PAY-06881: Error ORA-20001: eoy_archinit at 12 - -20001-ORA-20001:
ORA-06512: at "APPS.PAY_ARCHIVE", line 550
ORA-06512: at line 3
has occurred in table pay_archive.arch_initialise at location 1101

 

Changes

Year End Phase 1 patch

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