My Oracle Support Banner

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.


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

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

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


To view full details, 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 a vibrant support community of peers and Oracle experts.