MSCSDW - Error In Snapshot Delete Worker Failed In Storing The Firm Supplies (Doc ID 1504784.1)

Last updated on JUNE 28, 2017

Applies to:

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

Symptoms

When running an ASCP plan, the delete worker fails with:
  
ERROR
----------------------

MSCSDW module: Snapshot Delete Worker
+---------------------------------------------------------------------------+
Current system time is 05-NOV-2012 10:33:29
===================================================================
 Debug Mode : Disabled
===================================================================
 ALTER TABLE MSC.MSC_PART_DEMANDS TRUNCATE PARTITION PART_DEMANDS_1030
  .Deleted from MSC_PART_DEMANDS 0
  0:00
 The value of Snapshot Workers is 0
  Failed in storing the Firm Supplies.
   <<< THIS IS KEY ERROR

 
Trace files shows:
==================

 
STEPS 
Advanced supply chain planner
1. Run plan with overwrite set to none and having firm planned orders with an alternate bom designator > 10 chars

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