Year End Pre Process (YEPP) User_entity_id DBI failure was rpt on table pay_archive.arch_initialise at location 1101 w/ error text ORA-20001: eoy_archinit at 36 - -20001-ORA-20001: DBI : A_PAY_US_ASG_PR_W4_DETAILS_ASG_PAYMENT_AGRICULTURAL_LABOR (Doc ID 2746242.1)

Last updated on DECEMBER 19, 2022

Applies to:

Symptoms

On : 12.1.3 version, US Payroll Year End

When attempting to submit the Year End Pre Process (YEPP) for any Government Reporting Entity (GRE) the following error occurs.

ERROR
-----------------------
HR_6881_HRPROC_ORA_ERR
SQLERRMC ORA-20001: eoy_archinit at 36 - -20001-ORA-20001: Error getting user_en
tity_id for DBI : A_PAY_US_ASG_PR_W4_DETAILS_ASG_PAYMENT_AGRICULTURAL_LABOR - 10
0-ORA-01403: no data found
ORA-06512: at "APPS.PAY_ARCHIVE", line 556
ORA-06512: at line 3

SQL_NO 1101
TABLE_NAME pay_archive.arch_initialise
APP-PAY-06881: Error ORA-20001: eoy_archinit at 36 - -20001-ORA-20001: Error getting user_entity_id for DBI : A_PAY_US_ASG_PR_W4_DETAILS_ASG_PAYMENT_AGRICULTURAL_LABOR - 100-ORA-01403: no data found
ORA-06512: at "APPS.PAY_ARCHIVE", line 556
ORA-06512: at line 3
has occurred in table pay_archive.arch_initialise at location 1101

Cause: an oracle error has occurred. The failure was reported on table pay_archive.arch_initialise at location 1101 with the error text ORA-20001: eoy_archinit at 36 - -20001-ORA-20001: Error getting user_entity_id for DBI : A_PAY_US_ASG_PR_W4_DETAILS_ASG_PAYMENT_AGRICULTURAL_LABOR - 100-ORA-01403: no data found
ORA-06512: at "APPS.PAY_ARCHIVE", line 556
ORA-06512: at line 3
.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. All legislative patches, RUP, Quarter end, Year End Phase 2 were applied.
2. Submit the Year End Pre Process (YEPP) for the Government Reporting Entity (GRE)
3. Observe the error

Changes

 All legislative patches were applied on one day in January and at one time without submitting the hrglobal, data installer after each major patch

Cause

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