Oracle Apps Training Index

Min Max Planning / Replenishment in Oracle Inventory and Purchasing R12

You can use min-max planning to maintain inventory levels for all 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 drops below the minimum, Oracle Inventory suggests a new requisition or job to bring the balance back up to the maximum.

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 open sales orders and work in process component requirements as demand in the min-max planning calculation. Purchase 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.

When you min-max plan at the subinventory level, you can optionally include only open sales orders as demand in the min-max planning calculation. Requisitions for the suggested replenishment quantities can be optionally created. Also, subinventory level planning cannot generate jobs and does not consider WIP jobs as supply or WIP components as demand. You can then turn these requisitions into purchase orders or internal orders for the required items.

Navigate to Navigate to the Inventory Super User responsibility
Items > Organization Items

You need to set Inventory Planning Method as Min-Max and make it as Buy item. You can set reorder level for the item in min-Max Quantity. Here Item is configured in M1 organization and source is mentioned as S1.

Submit Request for Min Max Report - Min-max planning report

Here you set parameter Restock as Yes to interface request for the items. Submit request.

Click on View Output

Here request has interfaced in for the item with reorder quantity 988335.
Reorder Order Quantity = Maximum Quantity - Total Available (On Hand Quantity)
988335 = 100000 – 11665
Once data has interfaced you need to import data in Purchasing module and create requisitions.
Navigate to Purchasing Responsibility and submit request – Requisition Import

Here source of the item is Inventory from the S1 Organization so it creating Internal Requisitions.
Requisitions > Requisitions Summery

Click Find button

Reorder Quantity is 988335 and item order quantity has set with maximum amount as 500000. So you can see the request is divided into 2 separate requisitions one with 500000 quantity and other with 488335 to fulfil the inventory stock.

Kalyani Balbudhe

Add comment