R12 PAPAYIMP: Attempt To Run " PRC: Process Payroll Actuals" Fails With ORACLE Error 1000 in FDPSTP ORA-06512 At APPS.PA_PAY_INTERFACE (Doc ID 2057617.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Project Costing - Version 12.2 and later
Information in this document applies to any platform.

Symptoms

You submit "PAPAYIMP module: PRC: Process Payroll Actuals"
It fails with the following error in the request log file:

RACLE error 1000 in FDPSTP

Cause: FDPSTP failed due to ORA-01000: maximum open cursors exceeded
ORA-06512: at "APPS.PA_PAY_INTERFACE", line 1106
ORA-06512: at "APPS.PA_PAY_INTERFACE", line 511
ORA-06512: at line 1

Routine AFPPRD has encountered a fatal error. ORA-01000: maximum open cursors exceeded

 

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