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

Last updated on AUGUST 23, 2023

Applies to:

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

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