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

Last updated on FEBRUARY 17, 2017

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)

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:

APP-FND-00756: Invalid Transaction Source


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).

INSERT INTO mtl_transactions_interface(
TRANSACTION_INTERFACE_ID,
SOURCE_CODE,
SOURCE_LINE_ID,
SOURCE_HEADER_ID,
PROCESS_FLAG,
TRANSACTION_MODE,
LOCK_FLAG,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_LOGIN,
INVENTORY_ITEM_ID,
ORGANIZATION_ID,
TRANSACTION_QUANTITY,
PRIMARY_QUANTITY,
TRANSACTION_UOM,
TRANSACTION_DATE,
SUBINVENTORY_CODE,
TRANSACTION_SOURCE_NAME,
TRANSACTION_SOURCE_TYPE_ID,
TRANSACTION_ACTION_ID,
TRANSACTION_TYPE_ID,
TRANSACTION_REFERENCE
)
VALUES (1, -- transaction_interface_id
'Note 786918.1 Test', -- source_code
99, -- source_line_id
1, -- source_header_id
1, -- process_flag
3, -- transaction_mode
2, -- lock_flag
sysdate, -- last_update_date
-1, -- last_updated_by
sysdate, -- creation_date
-1, -- created_by
-1, -- last_update_login
&Inventory_item_id, -- Example 155 for Inventory_item_id AS18947
&organization_id, -- Example 207 for organization_id M1
1, -- transaction_quantity
1, -- primary_quantity
'Ea', -- transaction_UOM
sysdate, -- transaction_date
'&Subinventory_Code', -- Example Stores is subinventory_code
'&Alias_name', -- Example STD_MATL_CST is an alias for transaction_source_name
6, -- transaction_source_type_id
27, -- transaction_action_id
41, -- transaction_type_id
'Note 786918.1 Test' -- transaction_reference
);
COMMIT;

Changes

Applied <Patch 7327648>.

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