Change Order Implementation (ENCACNC) Returns ORA-01000 Error (Doc ID 2082588.1)

Last updated on DECEMBER 10, 2015

Applies to:

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

Symptoms

Change Order Implementation(ENCACNC) fails with the following errors.

********* Update_BSB_Request_Id_Column procedure Start *********
Not stamping with -333 as Exception occurred in Update_BSB_Request_Id_Column
procedure
Others 100:ORA-01403: No Data Found
********* Update_BSB_Request_Id_Column procedure End *********

ORACLE error 1000 in post_req_processing
Cause: post_req_processing failed due to ORA-01000: maximum open cursors
exceeded.

The SQL statement being executed at the time of the error was: select
phase_code,status_code  into :p,:s  from fnd_concurrent_requests where
request_id=:r and was executed from the file &ERRFILE.

Routine FDPCLS encountered an error changing request 989516 status.

Contact your support representative.
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