After 12.2.5 Upgrade Existing Plans Fail/Error in MSCSDW - Snapshot Delete Worker With ORA-02149 On Partitioned Table MSC_ITEM_SOURCING
Last updated on JUNE 29, 2017
Applies to:Oracle Rapid Planning - Version 12.2.5 and later
Oracle Inventory Optimization - Version 12.2.5 and later
Oracle Service Parts Planning - Version 12.2.5 and later
Oracle Advanced Supply Chain Planning - Version 12.2.5 and later
Information in this document applies to any platform.
Failure in Snapshot Delete Worker after upgrade from 12.2.3 to 12.2.5 - Users are in the process of upgrading to VCP 12.2.5. After upgrade when running an RP Plan the Snapshot Delete Worker fails with the below error:-
Failed attempt to lock : LOCK TABLE MSC_ITEM_SOURCING PARTITION (ITEM_SOURCING_3) IN EXCLUSIVE MODE NOWAIT
ORA-02149: Specified partition does not exist
Unable to obtain a lock on table MSC_ITEM_SOURCING
Cause: The program is unable to obtain a lock on the table MSC_ITEM_SOURCING.
Action: Resubmit the program at a later time.
Important: This happens for ASCP, IO, RP, DRP and SPP plans that existed before the upgrade to 12.2.5
The issue can be reproduced at will with the following steps:
1. Upgrade from 12.2.3 to 12.2.5 apps
2. Run the RP planplan
Upgraded to 12.2.5
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