account_alias_definition_issue

1. What is account alias
2. how to define account alias
3. Steps missed in Odev


--> Error --> Invalid transaction source segments..

Records Stuck in Mtl_transactions_interface, Invalid Transaction Source Segment. [ID 98358.1]

Cause

The imported record was missing the transaction source segment

Solution

You have to have an account alias defined before you can use it as a transaction source in a transaction.

Determine the type of transaction. Run this select statement to find out the type of transaction:

select transaction_type_id
from mtl_transactions_interface
where process_flag = 3;

If it returns transaction_type_id = 31, it is an account alias issue transaction.

Navigate to the define account aliases screen: Inv/setup/Account Aliases
Verify the account aliases value populated in the Mtl_Transactions_interface table
against the account alias combinations existing in the account alias screen.

For additional information on defining account aliases, refer to the Oracle Inventory User's Guide > Dening Account Aliases. Go to My Oracle Support | Knowledge | Online Documentation | Release 11.5.10 Documentation | Documentation | Logistics | Inventory Management.

Stuck Sales Orders in Mtl_material_transactions - Invalid Source Segment [ID 100567.1]

To Bottom

---

Modified:Feb 12, 2011Type:PROBLEMStatus:ARCHIVEDPriority:3

Comments (0)

Problem Description
-------------------

Sales order transactions are stuck in the mtl_transactions_interface with the following
error:

error_explanation: APP-010756 - vlaue 11865 is not defined

error_code: app-05337 - invalid transaction source segment

The AR:substitute Balancing segment had been modified using Flex Builder to add a
segment to the Accounting Flexfield.
       
Solution Description
--------------------

The solution comes from an old bug that was almost disregarded. This entry is to 
update the solution for a newer release. 

Recompile the accounting flexfield from the General Ledger responsibility.

Setup/Financials/flexfields/key/segments  query up the General Ledger application and
recompile the flexfield from within the application.

       


References
----------

        Bug 294497

Additional Search Words
-----------------------

        app-05337 app-01756, stuck sales order transactions, mtl_transanctions_interface,
invalid transaction source segment, segment, transaction source, transaction, sales orders,
Flex Builder, flexfield, value not defined.