Account Alias Via Transaction Open Interface Fails With Error: APP-FND-00756: Invalid Transaction Source
(Doc ID 786918.1)
Last updated on MAY 04, 2021
Applies to:Oracle Inventory Management - Version 12.0.3 and later
Information in this document applies to any platform.
FORM: INVTVPTX.FMB - View Pending Interface Activity (Open Interface)
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.
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
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
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).
Applied <Patch 7327648>.
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