Below script is useful in finding On hand quantity accurately using Oracle Standard API INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES. This script is tested in R12.1.3 instance. 1 2 3… Read More »API approach to find On Hand Quantity of an Item
Available to Transact = Quantity already reserved and ready to transact Available to Reserve = (Total Quantity in Reservable Subinventory) – (Total Quantity of the… Read More »What is the Difference between Available to Reserve & Available to Transact
Here is the query to find out the status of Inventory Accounting Periods from back end: SELECT ood.organization_id "Organization ID" , ood.organization_code "Organization Code" ,… Read More »SQL Query to find Status of Inventory Accounting Periods
A unit of measure conversion is a mathematical relationship between two different units of measure. For example, 12 Each = 1 Dozen. If you want… Read More »API for UOM Conversion
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25… Read More »SQL Query to find out the status of Interface Mangers
How and when costing will be done for material transactions? Once inventory transactions are completed then records will be inserted into MTL_MATERIAL_TRANSACTIONS table and can… Read More »How costing is performed on Inventory Material Transactions
Once I encountered a situation where in a Shipment Line of Inter-Org Transfer has Zero Quantity on Receiving end. Here is the screenshot of the… Read More »Inter-Org Transfer has Zero Quantity on Receiving end!