My Oracle Support Banner

Retropay (Enhanced) Error: ORA-20001: Deduction Processing Must be Entered (Doc ID 390329.1)

Last updated on NOVEMBER 14, 2018

Applies to:

Oracle Payroll - Version 11.5.10.2 and later
Information in this document applies to any platform.
ConcurrentProgram:RETROENH - Retropay (Enhanced)



Symptoms



RetroPay (Enhanced) process errors for one or more employees.

ERROR
==========
Oracle error occurred
Table=insert_retro_entry
sqlno=4517
ORA-20001: Deduction Processing must be entered
ORA-06512: at "APPS.HR_UTILITY", line 946
ORA-06512: at "APPS.HR_ENTRY", line 2769
ORA-06512: at "APPS.HR_ENTRY", line 2823
ORA-06512: at "APPS.HR_ENTRY", line 3848
ORA-06512: at "APPS.HR_ENTRY", line 4170
ORA-06512: at "APPS.HR_ENTRY_API", line 4097
ORA-06512: at "APPS.HR_ENTRY_API", line 5121
ORA-06512: at line 8

SQL_NO 4517
TABLE_NAME insert_retro_entry
APP-PAY-06881: Error ORA-20001: Deduction Processing must be entered
ORA-06512: at "APPS.HR_UTILITY", line 946
ORA-06512: at "APPS.HR_ENTRY", line 2769
ORA-06512: at "APPS.HR_ENTRY", line 2823
ORA-06512: at "APPS.HR_ENTRY", line 3848
ORA-06512: at "APPS.HR_ENTRY", line 4170
ORA-06512: at "APPS.HR_ENTRY_API", line 4097
ORA-06512: at "APPS.HR_ENTRY_API", line 5121
ORA-06512: at line 8
has occurred in table insert_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: Deduction Processing must be entered

 

Steps to Reproduce:

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

  1. Run Retro-notifications Report (Enhanced)
  2. Run RetroPay (Enhanced)





Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution

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