Min Max Planning

 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.

Min-Max Planning can be done in below levels

1. Organization level

2. Subinventory level

Setup

Organization Level

1.Create an item (mm_new1) & apply Purchasing Template.

2.Enter List Price if it “Buy” item.

3.In General Planning Tab, Inventory Planning Method:Min-Max; Enter Min-Max Qty & Ordered Quantity.  Source Type: Supplier

As per the above setup, following can be concluded

1.Maximum 1000 items can be present

2.Minimum of 100 items needs to be present in inventory

3.If there are no items in an inventory then a single requisition order with 2 lines each of 400 will be raised.

Transaction Process Flow

Give Planning Options as Organization Level

Also set restock value to yes. If we give this option as no then only a report will be created

but interface tables won't be hit.

Submit the concurrent program once its completed min max planning report will be

generated.

Now we need to run requisition import from purchasing responsibility, but we need to cross verify few points if requisition import to get completed successfully

1. At Item level, list price should be set

2. At Item lvel, in purchasing tab expense account has to be provided

3. In General planning tab, source type must be set as supplier

4. A Location should be assigned to Inventory Organization

5. An employee must be assigned to the login id

6. Master organizations should be associated with financial options

Now run the requisition import concurrent from purchase responsibility this will trigger couple of other concurrents as well

Concurrent status

Click on Requisition Import "View Output" to get the output details

In case the requisition import program ends in error then you can run requisition import exception report concurrent program with delete exceptions parameter as yes

Query the PR with Item details and you can find PR details

PR Details

Subinventory Level

Click on Item / Subinventory tab

Enable the min max planning and set the minimum and maximum quantity

Set the minimum and maximum order quantity and fixed lot multiplier

Set source type as supplier

Run the min max planning by selecting the planning level as subinventory

Set restock as Yes

Run the concurrent and view the concurrent status.