Transactions Stuck In MTL_TRANSACTIONS_INTERFACE with lock flag Yes

Oracle EBS Oracle Inventory Management - Version 12.2.5 and later:

Transactions Stuck In MTL_TRANSACTIONS_INTERFACE with To Locking Issue (lock Flag=Yes)

There are thousands of sales order issue transactions in the mtl_transactions_interface table that will not process even when resubmitted.
The transactions all have the following flags:

process_flag = 1
lock_flag = 2
transaction_mode = 3
error_code = NULL,
error_explanation = NULL

Solution:

CREATE TABLE MTI_BAKUP_1 AS
     SELECT * FROM MTL_TRANSACTIONS_INTERFACE
     WHERE TRANSACTION_INTERFACE_ID  = &ID
     and LOCK_FLAG  = 1;

Run the following scripts in a TEST environment first:

     UPDATE apps.MTL_TRANSACTIONS_INTERFACE
     SET LOCK_FLAG = NULL
     WHERE TRANSACTION_INTERFACE_ID  = &XXXX
     and LOCK_FLAG  = 1;

 Apply patch 27358054:R12.INV.C to address the root cause.

Reference: Oracle (Doc ID 2435389.1)

Hope This Help