ASCP Plan Erroring Out In MSCSDW Snapshot Delete Worker With Lock On Table MSC_SUPPLIES

(Doc ID 1242077.1)

Last updated on MAY 02, 2017

Applies to:

Oracle Advanced Supply Chain Planning - Version 11.5.10.2 and later
Information in this document applies to any platform.
Executable:MSCSDW - Snapshot Delete Worker

Symptoms

 When attempting to run an ASCP plan, the MSCSDW - Snapshot Delete Worker shows thousands of the following message:

LOCK TABLE msc_snapshot_tasks IN EXCLUSIVE MODE

Then it errors out with no specific error message as per the bottom of the log:

LOCK TABLE msc_snapshot_tasks IN EXCLUSIVE MODE
..Locked msc_snapshot_tasks at 14-OCT-2010 11:12:27 0:00
.SNAP-PROCESS TASK (ACTION=E_FETCHED) (TASK_ID=-2) (DATE=14-OCT-2010 11: 0:00
.14-OCT-2010 11:12:37: executed -2 (-2) (TASK=-2) 0:10
LOCK TABLE msc_snapshot_tasks IN EXCLUSIVE MODE
..Locked msc_snapshot_tasks at 14-OCT-2010 11:12:37 0:00
.SNAP-PROCESS TASK (ACTION=E_FETCHED) (TASK_ID=40) (DATE=14-OCT-2010 11: 0:00
wait for lock in MSC_SUPPLIES

***** End Of Program - Snapshot Delete Worker *****
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+
No completion options were requested.

Output is not being printed because:
The print option has been disabled for this report.
Concurrent program returned no reason for failure.

There were no other concurrent requests running apart from the plan.

STEPS:
1. Run ASCP plan
2. Plan fails in snapshot delete worker with no detailed message as to why

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