My Oracle Support Banner

Log Files of Retro Processes Show Errors: ORA-00001: unique constraint violated, ORA-01422: exact fetch returns more than requested number of rows and Signal 6 (Doc ID 1554663.1)

Last updated on MARCH 05, 2024

Applies to:

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

Symptoms


When attempting to run "Retropay (Enhanced)" or "Retro-Notifications Report (Enhanced) - PDF", the following error occurs.

ORA-00001: unique constraint (HR.PAY_ACTION_CONTEXTS_PK) violated

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

  1.  Login as HRMS Manager responsibility.

  2. Submit "Retropay (Enhanced)" or "Retro-Notifications Report (Enhanced) - PDF".
    (N) Processes and Reports > Submit Processes and Reports > Single Request
     
  3.  Request fails with the error.


OR

When attempting to run Retropay (Enhanced), the following error occurs.

Cause: FDPCLS failed due to ORA-03114: not connected to ORACLE
.
The SQL statement being executed at the time of the error was: lock TABLE FND_CONCURRENT_REQUESTS IN SHARE UPDATE MODE and was executed from the
*** glibc detected *** PYUGEN: free(): invalid pointer: 0x08479600 ***
======= Backtrace: =========
/lib/libc.so.6[0x7ea595]
/lib/libc.so.6(cfree+0x59)[0x7ea9d9]
PYUGEN[0x821c220]
======= Memory map: ========
00763000-0077d000 r-xp 00000000 fd:00 47449052 /lib/ld-2.5.so
0077d000-0077e000 r-xp 00019000 fd:00 47449052 /lib/ld-2.5.so
0077e000-0077f000 rwxp 0001a000 fd:00 47449052 /lib/ld-2.5.so
00781000-008c0000 r-xp 00000000 fd:00 47448081 /lib/libc-2.5.so
....
.....
.......
.............
stat_low = 6
stat_high = 0
emsg:was terminated by signal 6
/prodapp/applprod/apps/apps_st/appl/pay/12.0.0/bin/PYUGEN
Program exited with status -1

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

    1. Using HRMS Manager responsibility.
    
    2. Run Retropay enhanced for a set with a large number of employees.

    3. Check the process log.

 

OR

 

Quick Retropay (Enhanced) completes with error.

HR_6881_HRPROC_ORA_ERR
SQLERRMC ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "APPS.PAY_RETRO_NOTIF_PKG", line 1820
ORA-06512: at line 4

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

    1. Using HRMS Manager responsibility.
    
    2. Run Quick Retropay (Enhanced) process.

    3. Check the process log.

 

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.