My Oracle Support Banner

Item Not Found Error In Transaction Open Interface (Doc ID 1543019.1)

Last updated on SEPTEMBER 27, 2018

Applies to:

Oracle Inventory Management - Version 12.1.3 and later
Information in this document applies to any platform.
INV_LOGICAL_TRANSACTIONS_PUB: Item not found for item id:

Symptoms

Sales order issue transaction stuck in Transaction Open Interface (mtl_transactions_interface) with error explanation 'Item not found.'
Item exist in organization, is an inventory item and is transactable

When resubmit transaction with debug enabled, in debug file have following messages:

INV_LOGICAL_TRANSACTIONS_PUB: Construct the logical I/C receipt/sales return of from_org_id
INV_LOGICAL_TRANSACTIONS_PUB: l_index for l_mtl_trx_tbl = 3
INV_LOGICAL_TRANSACTIONS_PUB: Enter get_acct_period
INV_LOGICAL_TRANSACTIONS_PUB: p_organization_id = 90
INV_LOGICAL_TRANSACTIONS_PUB: x_acct_period_id = 4014
INV_LOGICAL_TRANSACTIONS_PUB: Calling INV_TRANSACTION_FLOW_PUB.convert_currency, input params:
INV_LOGICAL_TRANSACTIONS_PUB: 1. p_org_id = 83
INV_LOGICAL_TRANSACTIONS_PUB: 2. p_transfer_price = 1424.024
INV_LOGICAL_TRANSACTIONS_PUB: 3. p_currency_code = LKR
INV_LOGICAL_TRANSACTIONS_PUB: Item not found for item id: 6457
INV_LOGICAL_TRANSACTIONS_PUB: create_logical_transactions: Expected Error, l_progress = 350
INV_LOGICAL_TRANSACTIONS_PUB: SQL Error: User-Defined Exception
INV_LOGICAL_TRANSACTIONS_PUB: Return Status :E


Records stuck in interface is for organization_id XX.
Item do not exist for organization_id NN, which is required to create the logical transaction for Intercompany.

Same error also show when try to Ship Confirm Sales order.
In Trip Stop Interface log see message:
INV_LOGICAL_TRANSACTIONS_PUB: Item not found for item id:

Note: The same error can occur when attempting to perform a receipt in a drop ship flow that uses intercompany pricing across organizations.

 

Changes

 

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
Changes
Cause
Solution
 A. Check that the item exists in each organization:
 B. Check organization access security:
References


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