Loading Inventory Opening Balance

Hello, in this article i will guide any one need to know how to upload the inventory opening balance please check the steps and if you have any comments update on the site ================================ 1-Insert Records at MTL_TRANSACTIONS_INTERFACE 2-Commit
view Inserted Records:- ========================= SELECT *  FROM MTL_TRANSACTIONS_INTERFACE Delete Records From Inteface Tables:- ===================================== Delete From MTL_TRANSACTIONS_INTERFACE commit 3-to view loaded record from APP navigate to Inventory:Transactions:Transactions Open Interface 3- Navigate to Inventory:Setup:Transactions:Interface Manager Lunch:Material transaction (From Tools menuSelet Launch) 4-in case of Error Navigate to Inventory: Transactions: Transaction Open Interface 5-in case of serial items , load the Content of MTL_SERIAL to MTL_SERIAL interface table , thengo to Step no3 View the records Status:- ========================= SELECT PROCESS_FLAG,COUNT(*) FROM  MTL_TRANSACTIONS_INTERFACE GROUP BY PROCESS_FLAG Process flag    = 1    Not Processed Process flag    = 2    In Processe Process flag    = 3    Error Process flag    = 4    Validation Process flag    = 7    Completed
Admin bar avatar
Sameh Bakkar
Sameh Bakkar has over 15 years Oracle Applications implementation experience (EBS/Fusion) and he is an Oracle authorized trainer. He has in-depth technical and Functional knowledge of Oracle Applications and Oracle HCM Cloud. Sameh has excellent experience in Team management, Man Power and resource planning, and Pre-Sales management Process. Additionally he has also given Best Practices seminars on Oracle e-business suite and Oracle Fusion.

You may also like

Leave A Reply

Your email address will not be published. Required fields are marked *