When Creating Transactions through Transactions Open Interface, Get Error: "Mtl_Transactions_Interface: Error_Code=Invalid Item" with Explanation "Inventory Item ID Is Invalid...." (Doc ID 274891.1)

Last updated on JANUARY 14, 2016

Applies to:

Oracle Inventory Management - Version 11.5.10.0 to 11.5.10.0 [Release 11.5.10]
Information in this document applies to any platform.
***Checked for relevance on 14-Aug-2014***

This document includes all versions of 11i


Symptoms

-- Cannot create transactions through the transaction open interface.
For example Miscellaneous Receipts and Issues both fail with the same error.
-- Can create transactions through the forms (Inventory > Transactions > Miscellaneous Transactions)
-- This has never worked.

See the following errors in the MTL_TRANSACTIONS_INTERFACE Table:
ERROR_CODE: Invalid item
ERROR_EXPLANATION: Inventory item ID is invalid or does not have the flags
enabled correctly to be processed by material processor

See the following error in the request log:
INCTCW module: Inventory transaction worker
08:08:43 : INV_USE_NEWTM = 1 , table = 3
08:08:43 : Table = 3
08:08:43 : callTM fails: err:

VERSIONS
-----------------------
Oracle Applications Release 11.5.5
inltev.ppc 115.48
inctcm.ppc 115.47
INVTXMGB.pls 115.19.11571.8
INVTXMGS.pls 115.6.11571.3

See the error in the select from the transaction interface table
(MTL_TRANSACTIONS_INTERFACE)

Here is an example script that causes the issue when the transaction open interface is run:

spool mti_insert4.lst
PROMPT mti_insert4.sql
PROMPT Misc. Receipt

prompt
accept YourSegment1 DEFAULT 'JBP Item' prompt 'Please enter your segment1
(Default JBP Item): '
prompt

prompt
accept YourOrgID DEFAULT 207 prompt 'Please enter your Org ID (Default 207): '
prompt

prompt
accept YourSubinventory DEFAULT 'JBP Subinv' prompt 'Please enter your
Subinventory Code (Default JBP Subinv): '
prompt

prompt
accept YourDistAccountID DEFAULT '13496' prompt 'Please enter your Distribution
Account ID (Default 13496): '
prompt


INSERT INTO MTL_TRANSACTIONS_INTERFACE
(
TRANSACTION_INTERFACE_ID,
TRANSACTION_HEADER_ID,
SOURCE_CODE,
SOURCE_LINE_ID,
SOURCE_HEADER_ID,
PROCESS_FLAG,
VALIDATION_REQUIRED,
TRANSACTION_MODE,
LOCK_FLAG,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_LOGIN,
REQUEST_ID,
PROGRAM_APPLICATION_ID,
PROGRAM_ID,
PROGRAM_UPDATE_DATE,
INVENTORY_ITEM_ID,
ITEM_SEGMENT1,
ORGANIZATION_ID,
TRANSACTION_QUANTITY,
PRIMARY_QUANTITY,
TRANSACTION_UOM,
TRANSACTION_DATE,
SUBINVENTORY_CODE,
DISTRIBUTION_ACCOUNT_ID,
TRANSACTION_SOURCE_TYPE_ID,
TRANSACTION_ACTION_ID,
TRANSACTION_TYPE_ID,
TRANSACTION_REFERENCE,
TRANSFER_SUBINVENTORY,
TRANSFER_ORGANIZATION,
ERROR_EXPLANATION,
ERROR_CODE,
ATTRIBUTE11
) VALUES (
NULL, -- 21406943, --TRANSACTION_INTERFACE_ID -- req'd for lot/serial
NULL, -- 21407367, --TRANSACTION_HEADER_ID --NULL
'JBP Test', --SOURCE_CODE -- Reference to legacy data
-999991, --SOURCE_LINE_ID -- Reference to legacy data
-999991, --SOURCE_HEADER_ID -- Reference to legacy data
1, --PROCESS_FLAG
1, --VALIDATION_REQUIRED -- 1=FULL
3, --TRANSACTION_MODE -- 2=Concurrent, 3=Background
null, --LOCK_FLAG
sysdate, --LAST_UPDATE_DATE
1216, --LAST_UPDATED_BY
sysdate, --CREATION_DATE
-1, --CREATED_BY
3533073, --LAST_UPDATE_LOGIN
NULL, -- 3248282, --REQUEST_ID
NULL, -- 401, --PROGRAM_APPLICATION_ID
NULL, -- 32321, --PROGRAM_ID
sysdate, --PROGRAM_UPDATE_DATE
NULL, --INVENTORY_ITEM_ID
'&YourSegment1', --ITEM_SEGMENT1 -- JBP Item
&YourOrgID, --ORGANIZATION_ID -- 207
2, --TRANSACTION_QUANTITY
2, --PRIMARY_QUANTITY
'Ea', --TRANSACTION_UOM
sysdate, --TRANSACTION_DATE
'&YourSubinventory', --SUBINVENTORY_CODE -- FGI
'&YourDistAccountID', -- DISTRIBUTION_ACCOUNT_ID
13, --TRANSACTION_SOURCE_TYPE_ID
27, --TRANSACTION_ACTION_ID
42, --TRANSACTION_TYPE_ID
'LOADED BY ORACLE SUPPORT ON '|| sysdate, --TRANSACTION_REFERENCE
NULL, --TRANSFER_SUBINVENTORY
NULL, --TRANSFER_ORGANIZATION
NULL, --ERROR_EXPLANATION
NULL, --ERROR_CODE
'LOADED BY ORACLE SUPPORT ON '|| sysdate --ATTRIBUTE11
);
commit;
spool off

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