Account Alias Via Transaction Open Interface Fails With Error: APP-FND-00756: Invalid Transaction Source (Doc ID 786918.1)

Last updated on MAY 01, 2023

Applies to:

Symptoms

Account alias transactions inserted into the open interface (MTL_TRANSACTIONS_INTERFACE) fail with the following error.
Populate the source name with the account alias name.
Example account alias transactions include transaction type id of 31 / Account alias issue and 41 / Account alias receipt. Checked the Alias setup and it looks correct.

Error
See the following error on the transaction interface record:

See the following message in the log file:
INV_TXN_MANAGER_GRP: Transaction Source ID error No values have been entered for one or more segments required.
INV_TXN_MANAGER_GRP : Error in derive_segment_ids :
INV_TXN_MANAGER_GRP: Error:ORA-01403: No data found

Steps
1. Insert a row into MTL_TRANSACTIONS_INTERFACE
2. Run the inventory manager (Inventory > Setup > Transactions > Interface Managers)
3. The inventory manager completes with error

Example Insert
The following is an example SQL that could be used to insert the interface record and cause the issue. The example SQL prompts the user for the item id (&Inventory_item_id), organization id (&organization_id), subinventory code (&Subinventory_Code), and the alias name (&Alias_name).

Changes

Applied <Patch 7327648>.

Cause

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