Warning In Planning ODS Load Worker Log File - ORA-01001: invalid cursor - PROCEDURE=LOAD_ITEM_SUBSTITUTES (Doc ID 1484703.1)

Last updated on JUNE 28, 2017

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.1.3 and later
Information in this document applies to any platform.

Goal

Need to understand what problems are associated with this warning in the Planning ODS Load Worker when running Net Change Data Collections. This problem does not occur when running full or targeted collections

MSCPDCW module: Planning ODS Load Worker:


**Starts**14-AUG-2012 06:23:59
**Ends**14-AUG-2012 06:24:01
Planning ODS Load process succeeded.
...
14-AUG 06:24:00 : Worker Task Unpacked : 51
14-AUG 06:24:00 : Calling Execute Partial Task for task number: 51
14-AUG 06:24:00 : Procedure MSC_CL_ITEM_ODS_LOAD.LOAD_ITEM_SUBSTITUTES started.
14-AUG 06:24:00 : ========================================
14-AUG 06:24:00 : Error in PROCEDURE=LOAD_ITEM_SUBSTITUTES, TABLE=MSC_ITEM_SUBSTITUTES
14-AUG 06:24:00 : COLUMN=HIGHER_ITEM_ID, VALUE=&VALUE
14-AUG 06:24:00 : COLUMN=LOWER_ITEM_ID, VALUE=&VALUE
14-AUG 06:24:00 : ORA-01001: invalid cursor
14-AUG 06:24:00 : 0 minutes elapsed.

Solution

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