Planning ODS Load (MSCPDC) Is Failing With ORA-00054 Error
(Doc ID 1501130.1)
Last updated on APRIL 29, 2024
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
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 |
| Cause |
| Solution |
| References |