Retropay(Enhanced) Fails: ORA-01002: fetch out of sequence and ORA-01000: maximum open cursors exceeded (Doc ID 2197192.1)

Last updated on FEBRUARY 09, 2017

Applies to:

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

Symptoms

Retropay (Enhanced) Fails, with the following issue:

 

HR_51119_HRPROC_ERR_OCC_ON_ET
ETNAME Garn DE Calculator
APP-PAY-51119: Error was encountered when processing Element Type XXXX
Accrued Deduction Balance > Total Owed by $XXX.XX. Adjust Balance for XXXX.
HR_6881_HRPROC_ORA_ERR
SQLERRMC ORA-20001: You cannot create an entry past the termination rule date.

Cause:        You are trying to create an element entry for an employee assignment which does not end before the termination rule date.  

Action:        Please remove your current changes.
ORA-06512: at "APPS.HR_UTILITY", line 939
ORA-06512: at "APPS.HR_ENTRY", line 1748
ORA-06512: at "APPS.HR_ENTRY", line 2160
ORA-06512: at "APPS.HR_ENTRY", line 3214
ORA-06512: at "APPS.HR_ENTRY_API", line 3786
ORA-06512: at "APPS.HR_ENTRY_API", line
SQL_NO 4517
TABLE_NAME insert_retro_entry
APP-PAY-06881: Error ORA-20001: You cannot create an entry past the termination rule date.

Cause:        You are trying to create an element entry for an employee assignment which does not end before the termination rule date.  

Action:        Please remove your current changes.
ORA-06512: at "APPS.HR_UTILITY", line 939
ORA-06512: at "APPS.HR_ENTRY", line 1748
ORA-06512: at "APPS.HR_ENTRY", line 2160
ORA-06512: at "APPS.HR_ENTRY", line 3214
ORA-06512: at "APPS.HR_ENTRY_API", line 3786
ORA-06512: at "APPS.HR_ENTRY_API", line  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: You cannot create an entry past the termination rule date.
Cause:        You are trying to create an element entry for an employee assignment which does not end before the termination rule date.  
Action:        Please remove your current changes.
ORA-06512: at "APPS.HR_UTILITY", line 939
ORA-06512: at "APPS.HR_ENTRY", line 1748
ORA-06512: at "APPS.HR_ENTRY", line 2160
ORA-06512: at "APPS.HR_ENTRY", line 3214
ORA-06512: at "APPS.HR_ENTRY_API", line 3786
ORA-06512: at "APPS.HR_ENTRY_API", line .  
Action:        Please contact your support representative.

-------------------------------------------------------------------------
PL/SQL Output
-------------------------------------------------------------------------
-------------------------------------------------------------------------
HR_6859_HRPROC_OTHER_PROC_ERR
APP-PAY-06859: An error has been detected by another process.

Cause:        During processing, the master or another slave process has detected an error, communicated by setting the Payroll status to 'Error'.  

Action:        Examine the error log file and payroll messages to investigate the cause of the error.



+----------------------------------


HR_6881_HRPROC_ORA_ERR
SQLERRMC ORA-01002: fetch out of sequence

SQL_NO 4024
TABLE_NAME pay_assignment_actions
APP-PAY-06881: Error ORA-01002: fetch out of sequence
has occurred in table pay_assignment_actions at location 4024

Cause:        an oracle error has occurred.  The failure was reported on table pay_assignment_actions at location 4024 with the error text ORA-01002: fetch out of sequence
.  

Action:        Please contact your support representative.


HR_6859_HRPROC_OTHER_PROC_ERR
APP-PAY-06859: An error has been detected by another process.

Cause:        During processing, the master or another slave process has detected an error, communicated by setting the Payroll status to 'Error'.  

Action:        Examine the error log file and payroll messages to investigate the cause of the error.

ORACLE error 1000 in AFPRSP

Cause: AFPRSP failed due to ORA-01000: maximum open cursors exceeded
.

The SQL statement being executed at the time of the error was:  and was executed from the file .
Routine FDPCLS encountered an error changing request 4393450 status.

Contact your support representative.
ORA-01000: maximum open cursors exceeded

lock TABLE FND_CONCURRENT_REQUESTS IN SHARE UPDATE MODE
*** glibc detected *** PYUGEN: free(): invalid pointer: 0x0848d300 ***
======= Backtrace: =========
/lib/libc.so.6[0xf686aa15]
/lib/libc.so.6(cfree+0x59)[0xf686ea89]
PYUGEN[0x822651c]
....

emsg:was terminated by signal 6
/ptkevi/applmgr/1213/pay/12.0.0/bin/PYUGEN
Program exited with status -1

 

 

Steps to Reproduce:

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

  1.  Run "Retropay(Enhanced)".
  2.  Error occurs.

 

Changes

 

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