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

Last updated on JUNE 29, 2017

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).
-------------------
  Wed May 27 09:59:01 JST 2015 Error saving Input Tables java.sql.SQLException: ORA-14402: updating partition key column would cause a partition change
-------------------
  Wed May 27 10:06:36 JST 2015 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

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