ORA-00904: "COLL_STATUS": Invalid Identifier ORA-06512: At "APPS.MSC_CL_PULL", Line 3676
(Doc ID 2745925.1)
Last updated on JULY 24, 2023
Applies to:
Oracle Advanced Supply Chain Planning - Version 12.1.3.8 to 12.1.3.9.1 [Release 12.1]Information in this document applies to any platform.
Symptoms
On : 12.1.3.9 version, Data Collections
Planning Data Collection process completes with error.
ERROR
ORA-00904: "COLL_STATUS": invalid identifier ORA-06512: at "APPS.MSC_CL_PULL", line 3676
13-JAN 14:46:15 : All the Assigned Tasks are completed.
13-JAN 14:46:15 : ORA-0000: normal, successful completion
13-JAN 14:46:15 : Telling the worker 1 to end.
13-JAN 14:46:15 : Telling the worker 2 to end.
13-JAN 14:46:15 : Telling the worker 3 to end.
13-JAN 14:46:15 : Telling the worker 4 to end.
13-JAN 14:46:15 : Telling the worker 5 to end.
13-JAN 14:46:15 : Telling the worker 6 to end.
13-JAN 14:46:15 : 1 Worker(s) Completed.
13-JAN 14:46:15 : 2 Worker(s) Completed.
13-JAN 14:46:15 : 3 Worker(s) Completed.
13-JAN 14:46:15 : 4 Worker(s) Completed.
13-JAN 14:46:15 : 5 Worker(s) Completed.
13-JAN 14:46:15 : 6 Worker(s) Completed.
13-JAN 14:46:15 : ORA-00904: "COLL_STATUS": invalid identifier
13-JAN 14:46:15 : Error_Stack...
13-JAN 14:46:15 : ORA-00904: "COLL_STATUS": invalid identifier
13-JAN 14:46:15 : Error_Backtrace...
13-JAN 14:46:15 : ORA-06512: at "APPS.MSC_CL_PULL", line 3676
STEPS
The issue can be reproduced at will with the following steps:
1. Navigation: Advanced Supply Chain Planner > Collections > Oracle Systems > Run Standard Data Collection process
Changes
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 |