Fixing Inventory Transactions Stuck In the Transaction Open Interface (MTL_TRANSACTIONS_INTERFACE) : Work With Your Technical Team For Custom Transactions (Doc ID 1668398.1)

Last updated on OCTOBER 04, 2016

Applies to:

Oracle Inventory Management - Version 12.1.2 and later
Information in this document applies to any platform.

Goal

Transactions are stuck in the transaction open interface for various types of Inventory transactions like Subinventory transfer, miscellaneous issue, miscellaneous receipt, and more. 

Why are the records duplicated and left in the interface table?

STEPS
1. Navigate to Inventory > Transactions > Transaction Open Interface.
2. Search for transactions.
3. See transactions in error and duplicates.

Note: All transactions are Inventory transaction types like Subinventory transfer, miscellaneous issue, miscellenaous receipt.

Solution

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