R12.1.3 MSCPDP Planning Data Pull With ORA-00904: "CMRO_CLOSED_WO": Invalid Identifier
(Doc ID 2819668.1)
Last updated on SEPTEMBER 12, 2022
Applies to:
Oracle Advanced Supply Chain Planning - Version 12.1.3 to 12.1.3.9.2 [Release 12.1]Information in this document applies to any platform.
Symptoms
On : 12.1.3 version, Planning data pull fails with
ORA-00904: "CMRO_CLOSED_WO": invalid identifier
After upgrading the database to 19c
ERROR
-----------------------
ORA-00904: "CMRO_CLOSED_WO": invalid identifier
ORA-00904: "CMRO_CLOSED_WO": invalid identifier
ORA-06512: at "SYS.DBMS_SQL", line 1134
ORA-06512: at "APPS.MSC_UTIL", line 63
ORA-06512: at "APPS.MSC_UTIL", line 151
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Upgrade the db to 19c
2. Run Request - Planning Data Pull or Planning Data Collections request set
Changes
Database was upgraded in this scenario.
Cause
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
Symptoms |
Changes |
Cause |
Solution |
References |