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.

Symptoms

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
(
new_plan_list,
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
 

ERROR
-----------------------
APP-FND-01564 ORA-00904




The issue can be reproduced at will with the following steps:
1. Copy The plan



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