My Oracle Support Banner

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

Last updated on DECEMBER 12, 2018

Applies to:

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


On :  12.2.4 version, Install/Configuration

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:

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.

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.

The issue has the following business impact:
Due to this issue, users cannot setup their instances.


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

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.