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 FEBRUARY 22, 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:
[

 ]

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

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