Value Chain Planning - EBS (MOSC)

MOSC Banner

ASCP Copy Plan Error

Gurus,

We would like to have a backup plan before running our daily ASCP plan. To achieve this, we created a partition and would like to copy our current plan to this partition using the copy plan functionality. However, it is failing with the following message:

DELETE /*+ PARALLEL (MSC_ITEM_SOURCING , 10) */ FROM MSC_ITEM_SOURCING where plan_id = 1021

Error string=

Statement with the error:

INSERT /*+ PARALLEL(MSC_ITEM_SOURCING, 10) */ INTO MSC_ITEM_SOURCING

APP-FND-01564: ORACLE error 14400 in mrctbdt_copy_table_data

Cause: mrctbdt_copy_table_data failed due to ORA-14400: inserted partition key does not map to any partition

The SQL statement being executed at the time of the error was: INSERT /*+ PARALLEL(MSC_ITEM_SOURCING, 10) */ INTO MSC_ITEM_SOURCING and was executed from the file.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center