Engineering Change Order Implementation Fails When More Than 100 Revised Items (Doc ID 260843.1)

Last updated on AUGUST 21, 2016

Applies to:

Oracle Engineering - Version 11.5.5 and later
Information in this document applies to any platform.
ENGFDECN - Define engineering change order
ENCACN - Automatic Engineering Change Order Implementation

Symptoms

Whenever Engineering Change Order is implemented With More Than 100 Revised Items,
the Process Fails with Cryptic Errors in the Log File

ORACLE error 3114 in AFPRSR-Resubmit_Time
Cause: AFPRSR-Resubmit_Time failed due to ORA-03114: not connected to ORACLE
The SQL statement being executed at the time of the error
was: declare rev_date date ; rtg_rev_date date ; BEGIN ENG
Routine FDPCLS encountered an error changing request 1248289 status.

Contact your support representative.
APP-FND-01564: ORACLE error 1000 in close_server_files
Cause: close_server_files failed due to 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