'Retro-Notifications Report (Enhanced) - PDF' and Payroll Run Error: APP-PAY-06881: Error ORA-00001: unique constraint (Doc ID 1920795.1)

Last updated on JULY 11, 2016

Applies to:

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

Symptoms

When attempting to run payroll and 'Retro-Notifications Report (Enhanced) - PDF' for the first time, the following error occurs:

 

-- Error
***** Inside runProgram *****
Old encoding=UTF-8
New encoding=UTF-8
Param Test Debug value
Inside submitSubRequest2477576
Child process terminated abnormally.
Exception
Exception inside runProgramjava.lang.Exception: Child program ERROR
java.lang.Exception: Child program ERROR
at oracle.apps.pay.pdfgen.server.PayArchivePDF.submitSubReq(PayArchivePDF.java:474)
at oracle.apps.pay.pdfgen.server.PayArchivePDF.runProgram(PayArchivePDF.java:618)
at oracle.apps.fnd.cp.request.Run.main(Run.java:157)

Oracle Human Resources Generic Process
Started at : 15-JUL-2014 11:29:26
Chunk Size : 20
Threads : 1
Logging Category :
User Messaging : N
Interlock : N
Trace : N
RR Buffer Size : 500
RRV Buffer Size : 500
Bal Buffer Size : 500
EE Buffer Size : 500
Logging Area :
Assignment ID for Start:
Assignment ID for End o:

-------------------------------------------------------------------------
PL/SQL Output
-------------------------------------------------------------------------
-------------------------------------------------------------------------
HR_6881_HRPROC_ORA_ERR
SQLERRMC ORA-00001: unique constraint (HR.PAY_POPULATION_RANGES_PK) violated
ORA-06512: at "APPS.PAY_POPULATION_RANGES_PKG", line 499
ORA-06512: at "APPS.PAY_POPULATION_RANGES_PKG", line 599
ORA-06512: at line 1

SQL_NO 1642
TABLE_NAME pay_population_ranges_pkg.perform_range_creation
APP-PAY-06881: Error ORA-00001: unique constraint (HR.PAY_POPULATION_RANGES_PK) violated
ORA-06512: at "APPS.PAY_POPULATION_RANGES_PKG", line 499
ORA-06512: at "APPS.PAY_POPULATION_RANGES_PKG", line 599
ORA-06512: at line 1
 has occurred in table pay_population_ranges_pkg.perform_range_creation at location 1642

Cause: an oracle error has occurred. The failure was reported on table pay_population_ranges_pkg.perform_range_creation at location 1642 with the error text ORA-00001: unique constraint (HR.PAY_POPULATION_RANGES_PK) violated
ORA-06512: at "APPS.PAY_POPULATION_RANGES_PKG", line 499
ORA-06512: at "APPS.PAY_POPULATION_RANGES_PKG", line 599
ORA-06512: at line 1
.

Action: Please contact your support representative.

In { pyxipmt
message text = Error ORA-00001: unique constraint (HR.PAY_POPULATION_RANGES_PK)
violated
ORA-06512: at "APPS.PAY_POPULATION_RANGES_PKG", line 499
ORA-06512: at "APPS.PAY_POPULATION_RANGES_PKG", line 599
ORA-06512: at line 1
 has occurred in table pay_pop
message level = F,F
payroll_id text = 0
source_id text = 4,1035
line_text = 73, Error ORA-00001: unique constraint (HR.PAY_POPULATION_RANGES_PK)
 violated
line_text = 56, ORA-06512: at "APPS.PAY_POPULATION_RANGES_PKG", line 499
line_text = 56, ORA-06512: at "APPS.PAY_POPULATION_RANGES_PKG", line 599
line_text = 20, ORA-06512: at line 1
line_text = 30, has occurred in table pay_pop



Steps to Reproduce:
The issue can be reproduced at will with the following steps.

1. Applied RUP patching recommended for International legislation
2. Running Retro-Notifications Report (Enhanced) PDF
3. Running Payroll


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