My Oracle Support Banner

Unable To Save Plan in Rapid Planning Get Errors ORA-14402 & ORA-00001 (Doc ID 2026868.1)

Last updated on AUGUST 19, 2019

Applies to:

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

Symptoms

On : 12.2.4 version, Planning Engine

When customer tries to save a copied plan, customer got following error.


ERROR
-----------------------
Error saving data to input tables. Check server log for more information.

In the rpengine log file, we see ORA-14402(first time) and ORA-00001(second try).
-------------------
  <timestamp> Error saving Input Tables java.sql.SQLException: ORA-14402: updating partition key column would cause a partition change
-------------------
  <timestamp> Error saving Input Tables java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (MSC.MSC_SYSTEM_ITEMS_U1) violated
-------------------

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to Responsibility > Supply Chain Simulation Planner.
2. Save a Copied plan
3. See the above error.

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.