Viewing Item Supply and Demand Information

You can view supply/demand information, and the current and projected available quantities of an item.

arrow icon   To choose the item for which you want to view supply/demand information:

  1. Navigate to the Find Supply Demand Item window.

  2. Enter the item for which to review supply and demand history.

  3. Optionally, enter a cutoff date. Supply and demand scheduled beyond the cutoff date are not displayed in the Supply/Demand Detail window.

  4. Select the on-hand source. Choose from ATP subinventories only, Net subinventories only, or All subinventories.

  5. Click Find. The results display in the Supply/Demand Detail window.

  6. View information for:

    Supply/Demand Type: The supply source or demand source type, such asAccount number, Purchase order, Sales order, and WIP discrete job.

    Identifier: The identifier for the supply source or demand source, such as the purchase order number or work in process discrete job number.

    UOM: The primary unit of measure for the item.

    Quantity: The scheduled supply quantity or demand quantity for the item. Demand quantities are displayed as negative numbers. Supply quantities are displayed as positive numbers.

    Available Quantity: The projected on-hand quantity of the item, defined as Current Available + all future sources of supply and - all future sources of demand.

    Secondary UOM: The item secondary UOM if applicable.

    Secondary Quantity: The scheduled supply quantity or demand quantity for the item in the secondary UOM. Demand quantities are displayed as negative numbers. Supply quantities are displayed as positive numbers.

    Secondary Available Quantity: The projected on-hand quantity of the item defined as Current Available + All future sources of supply - all future sources of demand in the secondary UOM.

    Attention: Oracle Inventory does not deduct a reservation from this value as it already deducted reservations from Current On-hand to calculate Current Available.

Related Topics