Sales Order Issue Hangs in Inventory Transaction Worker: Enq: TX - Allocate ITL Entry Wait

(Doc ID 2317909.1)

Last updated on OCTOBER 16, 2017

Applies to:

Oracle Inventory Management - Version 12.2.5 and later
Information in this document applies to any platform.
Lock: Enq: TX - Allocate ITL Entry Wait

Symptoms

Getting enq: TX - allocate ITL entry wait on Inventory Transaction Worker Program on the INV.MTL_TRANSACTION_LOTS_INTERFACE Table. On OEM the following Update statement in running:

LOCKING STATEMENT

STEPS
1. Review enterprise manager results.
2. See contention of inventory worker.

Changes

 

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