Retropay Error: ORA-20001: You Cannot Create an Entry Past the Termination Rule Date (Doc ID 780258.1)

Last updated on JANUARY 12, 2017

Applies to:

Oracle Payroll - Version 11.5.10.2 and later
Information in this document applies to any platform.

Symptoms


When a Terminated Employee is processed under Enhanced RetroPay, if the Reprocess Date is set to time frame prior to the element being modified to use a POST_TERM_RULE of Actual Termination the following error is seen :

"ORA-20001: You cannot create an entry past the termination rule date.
ORA-06512: at "APPS.HR_UTILITY", line 934
ORA-06512: at "APPS.HR_ENTRY", line 1603
ORA-06512: at "APPS.HR_ENTRY", line 1986
ORA-06512: at "APPS.HR_ENTRY", line 3107
ORA-06512: at "APPS.HR_ENTRY_API", line 3742
ORA-06512: at "APPS.HR_ENTRY_API", line
SQLERRMC ORA-20001: You cannot create an entry past the termination rule
date.
ORA-06512: at "APPS.HR_UTILITY", line 934
ORA-06512: at "APPS.HR_ENTRY", line 1603
ORA-06512: at "APPS.HR_ENTRY", line 1986
ORA-06512: at "APPS.HR_ENTRY", line 3107
ORA-06512: at "APPS.HR_ENTRY_API", line 3742
ORA-06512: at "APPS.HR_ENTRY_API", line
APP-PAY-06881: Error ORA-20001: You cannot create an entry past the
termination rule date.
ORA-06512: at "APPS.HR_UTILITY", line 934
ORA-06512: at "APPS.HR_ENTRY", line 1603
ORA-06512: at "APPS.HR_ENTRY", line 1986
ORA-06512: at "APPS.HR_ENTRY", line 3107
ORA-06512: at "APPS.HR_ENTRY_API", line 3742
ORA-06512: at "APPS.HR_ENTRY_API", line has occurred in table
nsert_retro_entry at location 4517
Cause: an oracle error has occurred. The failure was reported on
table insert_retro_entry at location 4517 with the error text
ORA-20001: You cannot create an entry past the termination rule date.
ORA-06512: at "APPS.HR_UTILITY", line 934
ORA-06512: at "APPS.HR_ENTRY", line 1603
ORA-06512: at "APPS.HR_ENTRY", line 1986
ORA-06512: at "APPS.HR_ENTRY", line 3107
ORA-06512: at "APPS.HR_ENTRY_API", line 3742
ORA-06512: at "APPS.HR_ENTRY_API", line .
message text = Error ORA-20001: You cannot create an entry past the
termination
line_text = 75, Error ORA-20001: You cannot create an entry past the
termination"





Steps To Reproduce:

  1. Apply HR_PF.K.Rup3.
  2. Run Enhanced RetroPay




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