You can use min-max planning to maintain inventory levels for all of your items or selected items. With min-max planning, you specify minimum and maximum inventory levels for your items. When the inventory level for an item (on-hand quantities plus quantities on order) drops below the minimum, Oracle Inventory suggests a new purchase requisition, internal requisition, move order, or job to bring the balance back up to the maximum. The Min-Max planning report does not initiate the Requisition Import process. The system writes requisition information into the Requisition Interface table, but you must run the Requisition Import report to create requisitions.
Oracle Inventory performs min-max planning for your items at either the organization level or the subinventory level. When you min-max plan at the organization level, you can optionally include the following transactions as demand in the min-max planning calculation: unreserved sales orders, reserved sales orders, account issue move orders, and work in process component requirements. Purchase requisitions and internal requisitions for buy items and WIP unreleased jobs for make items for the suggested replenishment quantities can be optionally created. You can then turn these requisitions into purchase orders or internal orders and the unreleased jobs into jobs for the required items.
Note: The INV: Purchasing by Revision profile option controls whether item revisions can be specified on purchase requisitions generated by min-max planning (purchasing by revision can be used for both non-revision controlled items and revision-controlled items). Item revisions may be defined and used when purchasing material, although the item may not be revision controlled in inventory. The latest revision will default onto the purchase requisition.
When you min-max plan at the subinventory level, you can optionally include only unreserved sales orders, reserved sales orders, account issue move orders, and subinventory transfer move orders as demand in the min-max planning calculation. Purchase requisitions, internal requisitions, or pre-approved move orders for the suggested replenishment quantities can be optionally created. You can then turn requisitions into purchase orders or internal orders for the required items. See: Overview of Move Orders.
Note: Subinventory level planning cannot generate jobs and does not consider WIP jobs as supply or WIP components as demand.
When you min-max plan at the organization level, Oracle Inventory looks at inventory balances, purchase requisitions, internal requisitions, internal sales orders, process batches, and WIP jobs as supply. It looks at sales orders, WIP job component requirements, process batches, and account issue move orders as demand.
To use min-max planning at the organization level, you must set the item attributes used by min-max planning. You can start by setting the Inventory Planning Method item attribute to Min-max planning. You establish your minimum and maximum levels used in the calculation using the Min-Max Minimum Quantity and the Min-Max Maximum Quantity item attributes. You can optionally set the order quantity modifier item attributes (Minimum Order Quantity, Maximum Order Quantity, and Fixed Lot Size Multiplier) to further control the suggested order quantities generated by min-max planning. Set the Make or Buy flag to Make to optionally generate unreleased jobs and to Buy to optionally generate requisitions. For buy items, set the List Price for the item to automatically generate requisitions. See: General Planning Attribute Group.
For repetitive items, since you cannot generate repetitive plans, you have the option of generating requisitions, unplanned jobs, or a report only.
Min-max planning is performed by running the Min-max planning report. By selecting organization level planning, you run min-max planning for your organization. In addition to the planning level option, Oracle Inventory offers the options to Net Reserved Orders, Net Unreserved Orders, Net WIP Demand, and Include Non-nettable Inventory Quantities when calculating availability. You also specify a Demand Cutoff Date and a Supply Cutoff Date. If you choose No to all the net demand options, Oracle Inventory performs the following calculation:
Nettable Quantity on Hand + On Order = Total Available, in which:
Nettable Quantity on Hand is the sum of the quantities on hand for the item across all the nettable subinventories within your organization. Non-nettable quantities may optionally be included.
On Order is the sum of open purchase orders, purchase requisitions, internal requisitions, internal orders, and work in process jobs scheduled for receipt on or before the supply cutoff date.
If Total Available < Minimum Quantity, suggest a new order, in which:
Minimum Quantity is the value for the Min-Max Minimum Quantity item attribute.
Order Quantity = Maximum Quantity - Total Available, adjusted for order quantity modifiers:
Oracle Inventory revises the order quantity if necessary for the quantity to be a multiple of the fixed lot size multiplier.
The order quantity must be greater than or equal to the minimum quantity, or Oracle Inventory revises the quantity upward to the minimum.
If you choose Yes to any of the net demand options, Oracle Inventory performs the following calculation:
Nettable Quantity on Hand + On Order - Open Demand = Total Available, in which
Nettable Quantity on Hand is the sum of the quantities on hand for the item across all the nettable subinventories within your organization. Non-nettable quantities may optionally be included.
On Order is the sum of open purchase orders, requisitions, internal orders, and work in process jobs scheduled for receipt on or before the supply cutoff date.
Open Demand is the sum of unreserved sales orders, inventory reservations, including reserved sales orders, account issue move orders, and WIP component demand scheduled for issue on or before the demand cutoff date.
If Total Available < Minimum Quantity, suggest a new order, in which
Minimum Quantity is the value for the Min-Max Minimum Quantity item attribute.
Order Quantity = Maximum Quantity - Total Available, adjusted for order quantity modifiers:
Oracle Inventory revises the order quantity if necessary for the quantity to be a multiple of the fixed lot size multiplier.
The order quantity must be greater than or equal to the minimum quantity, or Oracle Inventory revises the quantity upward to the minimum.
The order quantity must be less than or equal to the maximum quantity, or Oracle Inventory revises the quantity down to the maximum.
When you run the Min-Max Planning report, you can have Oracle Inventory create requisitions for buy items and unreleased jobs for make items by answering Yes to Restock. You must also specify a location to serve as the default deliver to location on the requisitions. Oracle Inventory creates purchase requisitions for Buy items when the item attribute Replenishment Source Type is set to Supplier. Oracle Inventory creates internal requisitions for internal sales orders for Buy items when the item attribute Replenishment Source Type is set to Inventory. For internal requisitions, Oracle Inventory uses the item attribute Source Organization to determine the organization from which the internal requisition sources the item. For Repetitive Items you optionally create requisitions or unreleased jobs. See: Min-max planning report.
The following example shows you how Oracle Inventory performs min-max planning. Assume an item has the following quantity values and item attribute settings:
Nettable quantity on hand = 25
Open supply quantity = 50
Open reserved sales order quantity = 90
Inventory planning method = Min-max planning
Min-max minimum quantity = 100
Min-max maximum quantity = 500
If you run the Min-max planning report, and specify No to Net Reserved Orders, Oracle Inventory performs the following calculations:
Total Available: 25 + 50 = 75
We assume that all the supply is within the supply cutoff date, for a supply total of 50.
Total available quantity is 75.
Below min check: 75 < 100
The total available quantity is less than the min-max minimum quantity, so Oracle Inventory plans a new order.
Max quantity less total available: 500 - 75 = 425
To bring the quantity available back to the min-max maximum, Oracle Inventory will plan an order for 425.
If you run the Min-max planning report, and specify Yes to Net Reserved Orders, Oracle Inventory performs the following calculations:
Total Available: (25 + 50) - 90 = (-15)
We assume that all the supply is within the supply cutoff date, for a supply total of 50.
We assume that all the demand is within the demand cutoff date, so open reserved orders total to 90.
Total available quantity is (-15).
Below min check: (-15) < 100
The total available quantity is less than the min-max minimum quantity, so Oracle Inventory plans a new order.
Max quantity less total available: 500 - (-15) = 515
To bring the quantity available back to the min-max maximum, Oracle Inventory will plan an order for 515.
Note: To include inventory reservations from an external order management system in the min-max calculation, create the sales order in the MTL_SALES_ORDER table using the Sales Order API, and then load the reservation using the Create/Update/Delete reservation interface or the Reservation APIs.
In Oracle Inventory, you can run the Min-max planning report at the Organization level to create work orders for Oracle Shop Floor Management (OSFM). When the Min-max report is run at the Organization level (and the network routing is present for the item and the OSFM version is 11510 or later), then the following actions occur:
For lot-controlled items, the lot-based jobs are created in the OSFM interface table and then processed into the job by a OSFM user.
For non lot-controlled items, discrete job details are inserted into the Oracle Work in Process (WIP) interface table and then processed into the job by the WIP mass load process.
Note: If neither of the preceding situations apply, then the job details are inserted into the WIP interface table and then processed into the job by the WIP mass load program.
When you min-max plan at the subinventory level, Oracle Inventory looks at inventory balances, purchase requisitions, internal requisitions, VMI stock and move orders as supply. In addition, rather than using item attribute planning modifiers, Oracle Inventory uses values and parameters set at the item/subinventory level.
To perform min-max planning at the subinventory level, you establish the following values at the subinventory level using either the Subinventory Items or the Item Subinventories windows:
Min-max minimum quantity
Min-max maximum quantity
Planning method set to Min-max planning
Fixed lot multiple (optional)
Maximum order quantity
Minimum order quantity
Item sourcing details
Sourcing type (supplier or inventory)
Sourcing organization (if type is inventory)
Sourcing subinventory (if type is subinventory or inventory) (optional for Inventory source type)
Lead times (optional)
Min-max planning is performed by running the Min-max planning report. By selecting the subinventory level planning and specifying a subinventory, you run min-max planning for a single subinventory only. In addition to the planning level option (organization or subinventory), Oracle Inventory offers the option to Net Reserved Demand and to Net Unreserved Demand when calculating availability. You also specify a Demand Cutoff Date and a Supply Cutoff Date. If you choose No to the Net Demand options, Inventory performs the following calculation:
Quantity on Hand + On Order = Total Available, in which:
Quantity on Hand is the quantity in the subinventory you specified in the Min-max planning report.
On Order is the sum of open purchase orders, purchase requisitions, internal requisitions, internal sales orders, and subinventory transfer move orders scheduled for receipt to the specified subinventory on or before the supply cutoff date. Note that supply orders referencing a different subinventory, or with no subinventory specified, are not included.
If Total Available < Minimum Quantity, suggest a new order, in which:
Minimum Quantity is the value for the Min-Max Minimum Quantity set at the item/subinventory level.
Order Quantity = Maximum Quantity - Total Available, adjusted for item/subinventory order quantity modifiers:
Oracle Inventory revises the order quantity if necessary for the quantity to be a multiple of the fixed lot size multiplier.
The order quantity must be greater than or equal to the minimum quantity, or Oracle Inventory revises the quantity upward to the minimum.
The order quantity must be less than or equal to the maximum quantity, or Oracle Inventory revises the quantity down to the maximum.
If you choose Yes to the Net Reserved Demand and/or the Net Unreserved Demand option, Oracle Inventory performs the following calculation:
Quantity on Hand + On Order - Open Demand = Total Available, where
Quantity on Hand is the quantity in the subinventory specified in the Min-max planning report.
On Order is the sum of open purchase orders, purchase requisitions, internal requisitions, internal sales orders, and subinventory transfer move orders scheduled for receipt to the specified subinventory on or before the supply cutoff date. Note that supply orders referencing a different subinventory, or with no subinventory specified, are not included.
Open Demand is the sum of inventory reservations (including reserved sales orders), account issue move orders, and subinventory transfer move orders scheduled to ship from this subinventory on or before the demand cutoff date. Note that inventory reservations referencing a different subinventory, or with no subinventory specified, are not included
If Total Available < Minimum Quantity, suggest a new order, where:
Minimum Quantity is the value for the Min-Max Minimum Quantity specified at the item/subinventory level.
Order Quantity = Maximum Quantity - Total Available, adjusted for order quantity modifiers specified at the item/subinventory level:
Oracle Inventory revises the order quantity if necessary for the quantity to be a multiple of the fixed lot size multiplier.
The order quantity must be greater than or equal to the minimum quantity, or Oracle Inventory revises the quantity upward to the minimum.
The order quantity must be less than or equal to the maximum quantity, or Oracle Inventory revises the quantity down to the maximum.
When you run the Min-max report, you can have Oracle Inventory create requisitions or move orders by answering Yes to Restock. You must also specify a location to serve as the deliver to location on the requisitions. If you set the Sourcing Details type to Supplier, the Min-Max report populates the Req Interface tables, and you must run the Req Import program to import the orders into purchasing. Inventory creates internal requisitions for internal sales orders for items with the item/ subinventory Sourcing Details Type set to Inventory. Oracle Inventory creates pre-approved move orders for items with the item/subinventory Sourcing Details Type set to Subinventory. For move orders, Inventory uses the item/subinventory Sourcing Details Subinventory to determine the subinventory from which the move order sources the item. For internal order requisitions, Inventory uses the item/ subinventory Sourcing Details Organization to determine the organization from which the internal requisition sources the item. See: Requesting the Min-Max Planning Report.
The following example shows you how Oracle Inventory performs min-max planning. Assume an item has the following quantity values and item attribute settings:
Quantity on hand for specified subinventory = 25
Open supply quantity for specified subinventory = 50
Open sales order quantity placed against specified subinventory= 90
Inventory planning method at item/subinventory level = Min-max planning
Min-max minimum quantity specified at the subinventory level = 100
Min-max maximum quantity specified at the subinventory level = 500
If you run the min-max planning report, and specify No to the Net Demand options, Inventory performs the following calculations:
Total Available: 25 + 50 = 75
The quantity on hand for the specified subinventory is 25.
We assume that all the supply is within the supply cutoff date, and is destined for our specified subinventory, for a supply total of 50.
Total available quantity is 75.
Below min check: 75 < 100
The total available quantity is less than the min-max minimum quantity, so Oracle Inventory plans a new order.
Max quantity less total available: 500 - 75 = 425
To bring the quantity available back to the min-max maximum, Oracle Inventory will plan an order for 425.
If you run the min-max planning report, and specify Yes to the Net Demand option, Oracle Inventory performs the following calculations:
Total Available: (25 + 50) - 90 = (-15)
The quantity on hand for the specified subinventory is 25.
We assume that all the supply is within the supply cutoff date, and is destined for our specified subinventory, for a supply total of 50.
We assume that all the demand is within the demand cutoff date, and the sales orders are against our specified subinventory, so open sales orders total to 90.
Total available quantity is (-15)
Below min check: (-15) < 100
The total available quantity is less than the min-max minimum quantity, so Oracle Inventory plans a new order.
Max quantity less total available: 500 - (-15) = 515
To bring the quantity available back to the min-max maximum, Oracle Inventory will plan an order for 515.
Note: To include unreserved sales orders from an external order management system in the min-max planning calculation, modify the definition of MTL_DEMAND_OM_VIEW to include the sales order line table from the external system.
Note: To include inventory reservations from an external order management system in the min-max calculation, create the sales order in the MTL_SALES_ORDER table using the sales order API, and then load the reservation using the Create/Update/Delete reservation interface or the Reservation APIs.