My Oracle Support Banner

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 DECEMBER 19, 2017

Applies to:

Oracle Shipping Execution - Version 12.1.3 and later
Oracle Inventory Management - Version 12.1.3 and later
Information in this document applies to any platform.
Form: INVTVPTX.fmb - Inventory Transaction Open Interface
Form: INVTVTXN.fmb - Inventory Material Transactions
Concurrent: INCTCM - Process transaction interface
Concurrent: INCTCW - Inventory transaction worker
Concurrent: WSHINTERFACE - Interface Trip Stop
Concurrent: WSHINTERFACES - Interface Trip Stop - SRS

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:
[

MTL_ONLINE_TRANSACTION_PUB.process_online returns false
Error Code:Oracle error
Error Explanation:

 ]

-- 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

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
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.