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.