My Oracle Support Banner

ORA-14313 Error While Creating Instances (Doc ID 1996151.1)

Last updated on JUNE 04, 2021

Applies to:

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

Symptoms

MSC – Error while creating Application Instances  

We are trying to create application instances (Advanced Planning Administrator > Admin > Instances). But on the form, it is giving us the following errors:

ERROR
-----------------------
ORA-14313: Value 1 does not exist in partition ST_CALENDAR_DATES_DEF
ORA-06512: at "APPS.MSC_CL_EXCHANGE_PARTTBL", line 1735
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.  Advanced Planning Administrator > Admin > Instances

2.  On the instance form, we will up the following values:
Field                                     Value
Instance Code                       TST
Instance Type                       Process
Version                                 12.2.4
GMT Difference                     0
Currency                                 PKR

Rest of the fields is left as default.

3.  Error occurs when form is saved.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.