My Oracle Support Banner

ORA-00904: "COLL_STATUS": Invalid Identifier ORA-06512: At "APPS.MSC_CL_PULL", Line 3676 (Doc ID 2745925.1)

Last updated on JANUARY 25, 2021

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


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