Batch SCCEXT Fails When Running in Multi-Threaded Mode (Doc ID 1955660.1)

Last updated on JULY 27, 2017

Applies to:

Oracle Retail Merchandising System - Version 13.1.3 to 13.1.9 [Release 13.1]
Information in this document applies to any platform.

Symptoms

When attempting to run the SCCEXT batch in multi-threaded mode, the following error occurs:

sccext_2~20131108015925~process~~105~RET-0105: generic stored procedure error~INTERNAL STORED FUNCTION ERROR: function=COST_EXTRACT_SQL.UPDATE_COSTS, error=Table ORDLOC@350756376 with key values of %s2, %s3 is locked by another user., cost_chg=7129

Steps to Reproduce:

  1. Choose any regular item which has more than one supplier associated and that has a primary supplier.
  2. Raise a Non Basic (N/B) Purchase Order for that item for a virtual warehouse location.  Order for some large quantity (say, 100 - so that the order cost recalculation amount is non-negligible) with a future date.
  3. Create more than one cost change for the item mentioned above, for all suppliers, one cost change per supplier.  Importantly, the cost change IDs should be consecutive, so that different threads pick up the cost changes for the same item.
  4. Run SCCEXT batch with 3 threads.  One of the threads fails with the  error.

 

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