Enhanced Retropay Errors: ORA-06512 Error In Table Pay_retro_pkg.overlap_adjustments

(Doc ID 2374285.1)

Last updated on MARCH 15, 2018

Applies to:

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

Symptoms

Retropay (Enhanced) completes with error for one or more assignments.


ERROR
-----------------------
SQL_NO 3055
TABLE_NAME pay_retro_pkg.overlap_adjustments
APP-PAY-06881: Error ORA-20001:
ORA-06512: at "APPS.HR_UTILITY", line 939
ORA-06512: at "APPS.HRASSACT", line 8166
ORA-06512: at "APPS.HRASSACT", line 8255
ORA-06512: at "APPS.HRASSACT", line 8634
ORA-06512: at "APPS.PAY_BALANCE_PKG", line 11906
ORA-06512: at "APPS.PAY_RETRO_PKG", line 1916
ORA-06512: at line 1
has occurred in table pay_retro_pkg.overlap_adjustments at location 3055

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Run Retropay (Enhanced)


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