Error Code=Oracle error : Stuck Inventory Material Transactions Open Interface (MTI) or Failing Interface Trip Stop (ITS) Request (Doc ID 1601941.1)

Last updated on JUNE 21, 2023

Applies to:

Symptoms

When attempting to reprocess a transaction that was stuck in the Inventory Transaction Open Interface form (INVTVPTX), the new attempt failed too and the form is now showing Error Code = 'Oracle error'.
-OR-
This Error Code 'Oracle error' appears in the request log of the Interface Trip Stop concurrent program (WSHINTERFACES) for a run to reprocess a failed delivery.

Any attempt to resubmit the stuck transaction is unsuccessful.

The problem can occur with any kind of material transaction submitted to the material transaction interface manager:
- transactions originated in other products of the eBusiness suite (Order Management / Shipping Execution, Work in Process, etc.),
- transactions imported into table MTL_TRANSACTIONS_INTERFACE through a custom loader script.

Error
Case of the Interface Trip Stop request log:
[

 ]

-- Steps
1. Navigate to Inventory: (N) Transactions : Transaction Open Interface
2. In Find Interface Transactions:
Keep Process Flag=Error (defaulted)
Do not populate the field Error (because it is the Error Explanation, not the Error Code)
Press Find
3. In Transaction Interface window:
In the first tabbed region "Error":
Scroll right and review the field Error Code
If too many records got retrieved, then you may refine as below:
Press F11 key (Enter Query Mode)
Set Error Code=Oracle error
Press CTRL-F11 key (Execute Query)

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.