My Oracle Support Banner

Container Pack Transactions Stuck With No Error In MTL_TRANSACTIONS_INTERFACE Due To Locking Issue (Doc ID 2904090.1)

Last updated on NOVEMBER 14, 2022

Applies to:

Oracle Warehouse Management - Version 12.2.10 and later
Information in this document applies to any platform.

Symptoms

Container Pack Transactions are stuck In MTL_TRANSACTIONS_INTERFACE due To locking Issue.  The transactions in the mtl_transactions_interface table will not process even when resubmitted.
The transactions all have the following flags:
process_flag = 1
lock_flag = 1
transaction_mode = 3
error_code = NULL,
error_explanation = NULL

Steps to Reproduce

1) Insert data into MTL_TRANSACTIONS_INTERFACE for Container Pack via Open Interface
2) Launch Inventory Manager (Process Transaction Interface concurrent) 
3) See some transaction fail in the interface , but show no errors.

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.