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

Oracle EBS Vision Free Online (for Training)

Oracle EBS Vision Free Online (for Training)

Here you can train your self for Oracle Apps (Vision 12.2.8)  :

link Below :
 http://apps.example.com:8000/

configure Host files:

go to --> C:\Windows\System32\drivers\etc

edit hosts file add entry :
129.213.210.159           apps.example.com  apps

Configure java security to add
 http://apps.example.com:8000/ 

Post a comment to get username and password , and responsibilities you want:

Note:
This is for training only all data may be erased daily, so be careful.

Thanks ,

Free Oracle Cloud (Database, Instance, APEX)

Best and Cheapest Oracle APEX

Oracle Free Oracle Tier 

1- instances (Always free) two. 1OCPU , ~ 45GB 

2- Autonomous Databases (Always Free) two , 1 OCPU ,~20 GB 

3- 20GB Object Storage 

4- 1 Load balancer.

Then next blog how to Deploy Apex on Oracle Cloud Autonomous Database .

Thank you,