My Oracle Support Banner

MSCCPP5: Copy Plan Fails With APP-FND-01564: ORACLE Error 904 In Mrctbdt_copy_tab (Doc ID 2021868.1)

Last updated on OCTOBER 24, 2019

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(BOMSXX, 10) */ INTO BOMSXX
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

APP-FND-01564 ORA-00904

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!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.