Instance Creation Fails with ORA-14313 Error (Doc ID 2005213.1)

Last updated on JUNE 28, 2017

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.0.6 and later
Information in this document applies to any platform.
MSCFINST
MSCCIP

Symptoms

On : 12.0.6 or later

When saving a new instance definition in the Application Instances form,
an error like the following is raised

ERROR
-----------------------
ORA-14313: Value 4023 does not exist in partition ST_BOMS_DEF
ORA-06512: at "APPS.MSC_CL_EXCHANGE_PARTTBL", line 1569
ORA-06512: at line 1
ORA-06512: at "APPS.MSC_APPS_INSTANCES_T1", line 10
ORA-04088: error during execution of trigger 'APPS.MSC_APPS_INSTANCES_T1'

--------------------------------------------------------------
FRM-40735: ON-INSERT trigger raised unhandled exception ORA-14313.




STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Login to Application.
2. Define a new instance in the instance definition form and save.
(R) Advanced Planning Administrator
(N) Admin /  Instances.
(M) File / Save
3. Observe the noted error.
The instance definition is not saved.

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