Inventory Management - EBS (MOSC)

MOSC Banner

mtl_transaction_accounts not having data for a transaction in mtl_material_transactions

edited Jul 19, 2010 6:18PM in Inventory Management - EBS (MOSC) 4 commentsAnswered
 Hi All,

mtl_transaction_accounts table doesnt have record for a transaction in mtl_material_transactions.

That transaction_id corresponds to the Subinventory Transfer type.

For a Subinventory Transfer transaction,there would be two records in mtl_material_transactions with +Qty and -Qty

Among these 2 transactions(2 transaction_id's),for one transaction_id 2 records are there in mtl_trabsaction_accounts table and for the other transaction_id,no records in mtl_transaction_accounts.

Can you please tell me what would be the cause?

Also,Kindly let me know how and which program will insert the data into mtl_transaction_accounts and from what are all the tables data would be inserted into mtl_transaction_accounts?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center