Planning ODS Load (MSCPDC) Is Failing With ORA-00054 Error (Doc ID 1501130.1)

Last updated on AUGUST 01, 2017

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.1.3 to 12.2.6 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Symptoms

When attempting to run the Data Collections, the following error occurs in the Planning ODS Load/Worker (MSCPDC/MSCPDCW)...

ERROR
-----------------------
24-OCT 14:45:43 : exchange part:-ALTER TABLE MSC_SALES_ORDERS EXCHANGE PARTITION SALES_ORDERS__1 WITH TABLE SALES_ORDERS_GLD INCLUDING INDEXES
24-OCT 14:45:43 : ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired
24-OCT 14:45:43 : Fatal Error in Exchange Partition.
24-OCT 14:45:46 : Calling Linking of Sales Order for 11i source ...
24-OCT 14:45:46 : Procedure MSC_CL_DEMAND_ODS_LOAD.LINK_SUPP_SO_DEMAND_EXT started.
24-OCT 14:45:50 : .. In procedure GET_START_END_OP ..
24-OCT 14:45:51 : Truncated Source AD Tables Successfully
24-OCT 14:45:51 : exchange part:-ALTER TABLE MSC_ST_DELIVERY_DETAILS EXCHANGE PARTITION DELIVERY_DETAILS_1 WITH TABLE DELIVERY_DETAILS_GLD
24-OCT 14:45:51 : ORA-00942: table or view does not exist  << IGNORE THIS ERROR - ALWAYS CAUSED BY EARLIER ERROR IN THE PROCESS - IN THIS CASE THE ORA-00054 ABOVE
24-OCT 14:45:51 : Error while exchanging partition for table :MSC_ST_DELIVERY_DETAILS  <<<IGNORE THIS ERROR - ALWAYS CAUSED BY EARLIER ERROR IN THE PROCESS - IN THIS CASE THE ORA-00054 ABOVE
24-OCT 14:45:51 : Please launch planning data pull again for following entities :
24-OCT 14:45:51 : Delivery Details
24-OCT 14:45:51 : Sourcing Rules
24-OCT 14:45:51 : Sourcing Rules
24-OCT 14:45:51 : Sourcing Rules
24-OCT 14:45:51 : Exchange partition failed

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