Receiving Transaction Processor Performance Due To Locator Capacity Creating Deadlock On MTL_ITEM_LOCATIONS
(Doc ID 2452713.1)
Last updated on MARCH 28, 2022
Applies to:
Oracle Inventory Management - Version 12.1.3 and laterInformation in this document applies to any platform.
Symptoms
ACTUAL BEHAVIOR
When user is performing Putaway which involves Nested LPNs, Locator Capacity triggers are causing Locks on MTL_ITEM_LOCATIONS.
Due to this there are Deadlocks created on MTL_ITEM_LOCATIONS table.
This is causing performance issues for "Receiving Transaction Processor".
EXPECTED BEHAVIOR
There should not be any dead locks.
Performance of "Receiving Transaction Processor" should be improved.
Steps to Reproduce
1) Identify nested LPN and do putaway.
2) This will launch "Receiving Transaction Processor"
Changes
Cause
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
Symptoms |
Changes |
Cause |
Solution |
References |