Month: April 2024

Fusion Inventory – Query to get Inventory On-Hand balances and Available To Reserve quantities

by

We have a common requirement from most of the businesses to get inventory on-hand balances and available to reserve quantities by item and sub-inventory for their operation(s). This will help them to understand the current inventory to fulfill the sales order(s)/work order(s) demand, commiting the delivery dates with the customers and planning to source the … Read more

Fusion SCM – SQL Query to get Transfer Orders data

by

Transfers Orders are used in Oracle Fusion SCM for the intercompany material transfers, similar to the Internal Requisition/Internal Sales Order process in the Oracle EBS. No cost markup for the material transfers within the BU. Across the Business Units/Legal entities, Transfer Pricing policies can be setup based on the Cost Plus markup / List Less … Read more