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