My Oracle Support Banner

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

Last updated on FEBRUARY 20, 2019

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.


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.





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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.