Oracle Apps Techno Functional................

How to find item cost Another  common issue when  writing  queries is getting an item cost. Here are the  APIs  to use in queries: For discrete manufacturing: cst _cost_ api .get_item_cost(1,inventory_item_id, organization_id,NULL,NULL) here is a sample query: select segment1 item, cst _cost_ api .get_item_cost(1,inventory_item_id, organization_id,NULL,NULL) cost from  mtl _system_items_b If you are in an  OPM  organization the above won't work and instead you need to call select  msi .segment1 item, GMF _ CMCOMMON .get_ cmpt _cost( inventory_item_id, organization_id,  sysdate ,  cmm .cost_type_id ,0) cost from  mtl _system_items_b  msi , CM_ MTHD _MST  cmm where  cmm .cost_ mthd _ desc ='Standard Cost'

This blog provide basic understanding about Oracle Inventory Transactions and Cost processing procedure. SCOPE & APPLICATION ------------------- Oracle manufacturing customers, support, and consulting.    Transactions - Unprocessed Transactions/Closing INV Accounting Period (TRXN-STK) This document will be used to explain the flow of transactions from the MTL_TRANSACTIONS_INTERFACE to the GL_INTERFACE. The aim of this document is to help and assist in resolution of Interface related issues. CONTENTS -------- Q1.  What is the MTL_TRANSACTIONS_INTERFACE table used for? Q2.  What is the MTL_MATERIAL_TRANSACTIONS_TEMP table used for? Q3.  What type of issues will you see with the MTL__TRANSACTIONS_INTERFACE and      MTL_MATERIAL_TRANSACTIONS_TEMP tables? Q4.  What type of issues will you see with the MTL_MATERIAL_TRANSACTIONS table? Q5.  What type of issues will you see with the MTL_TRANSACTION_ACCOU...

In the processing of the sales order after Shipping Execution ships the delivery, Shipping module needs to interface the information back to Oracle Order Management and Oracle Inventory Management Modules also. This is done via the Interface Trips Stop Concurrent Program.   OM Interface occurs first,  then Inventory Interface You can also run Interfaces Individually for Order Management and Inventory.  However, the system will not allow you to run Inventory Interface until Order Management has completed successfully. The Delivery Detail status becomes Staged/Picked after Pick Release is successful. Thereafter when you ship confirm the delivery to which this Delivery Detail  belongs,  there are the following cases that could happen: Case 1: ====== If you ship confirm the delivery and do not run the interface (you Checked the Defer Interface Flag in the Confirm Delivery window before ship confirm), the delivery detail status would become "Shipped...