Retail Merchandising System (MOSC)

MOSC Banner

Locking issues in ASN processing due to multi threading

edited Jul 15, 2015 6:10PM in Retail Merchandising System (MOSC) Question

We are facing locking issues in ASN processing due to multi-threading. ASNs were threaded randomly, when ASNs coming from the same WareHouse (WH) are processed by a different thread it causes a locking error when the ASN processing attempts to update the FROM_LOCATION's Stock On Hand (SOH) in ITEM_LOC_SOH table.

So we have changed the threading logic to thread by FROM Location instead of random , but now the ASNOUT messages coming from WMS is getting threaded by from location before TAFR processing. After TAFR processing the ASNOUT messages again getting distributed randomly. Please suggest how to ensure that messages from one TAFR channel will route to particular subscriber channel of RMS only.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center