MSCCPP5: Copy Plan Fails With APP-FND-01564: ORACLE Error 904 In Mrctbdt_copy_tab
(Doc ID 2021868.1)
Last updated on JUNE 26, 2017
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,
MSCCPP5: Copy Plan
MSCCPP5: Copy Plan fails with APP-FND-01564: ORACLE error 904 in mrctbdt_copy_tab
Copy plan fails with following messages:
APP-FND-01564: ORACLE error 904 in mrctbdt_copy_table_data
Cause: mrctbdt_copy_table_data failed due to ORA-00904: "ALTERNATE_BOM_DESIGNATOR": invalid identifier
.The SQL statement being executed at the time of the error was: INSERT /*+ PARALLEL(BOMS22, 10) */ INTO BOMS22
appli and was executed from the file .
After that we found that we cannot save any new plan (plan already exists). We have meanwhile applied patch Patch #19828038 for an issue which also pointed to ALTERNATE_BOM_DESIGNATOR": invalid identifier
The issue can be reproduced at will with the following steps:
1. Copy The plan
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!