Planning ODS Load Fails In MSC_CL_ITEM_ODS_LOAD.Load_category ORA-00060 (Doc ID 1347868.1)

Last updated on JUNE 28, 2017

Applies to:

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

Symptoms

Using Advanced Supply Chain Planning / Standard Data Collection, when attempting to perform Planning Data Collection / Planning ODS Load the following error occurs:

25-JUL 11:30:19 : Error in PROCEDURE=LOAD_CATEGORY,
TABLE=MSC_ITEM_CATEGORIES
25-JUL 11:30:19 : ORA-00060: deadlock detected while waiting for resource
25-JUL 11:30:19 : Sending message :-9999999 to monitor.
25-JUL 11:30:19 : Error_Stack...
25-JUL 11:30:19 : ORA-00060: deadlock detected while waiting for resource
25-JUL 11:30:19 : Error_Backtrace...
25-JUL 11:30:19 : ORA-06512: at "APPS.MSC_CL_COLLECTION", line 2041
ORA-06512: at "APPS.MSC_CL_COLLECTION", line 3280


Steps:
1. (R) Advanced Supply Chain Planner
2. (N) Collections / Oracle Systems / Standard Collection
3. Observe Planning ODS Load failing due to a worker logging the error

Cause

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