My Oracle Support Banner

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 later
Information 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


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