You are browsing the archive for Business Processes.

12.0 Min Max Planning for Buy Items

Min Max Planning is a two bin replenishment method where when one bin is emptied or stock levels falls the below minimum level it will replenished to maximum stock. Min Max planning will be more useful for items that has independent demand or indirect items such as shot floor consumables, stationary items etc. MRP kind of planning is more useful for direct items that is dependent on sales/forecast.

In Oracle Min-Max planning, first certain item attributes must be set like Inventory planning method, minimum level, maximum level, order quantity. Then Min-Max concurrent program can be scheduled to run at regular intervals that checks for items that falls below minimum stock level. For buy items Min-Max planning suggests purchase/internal requisitions based on sourcing rule. You needs to run ‘Requisition Import’ after Min-Max Planning. Min-Max planning can be run at organization level or sub-inventory level. Min-Max program can be run in simulation mode or actual mode.

Navigation: Planning -> Min-Max Planning

Enter the parameters for the concurrent program ‘Min-Max Planning Report’.

  • Planning Level: Organization or subinventory level
  • Subinventory: Enter specific subinventory if Min-Max planning is at subinventory level
  • Item Selection: Select one of the option
    • Items under minimum quantity
    • Items over maximum quantity
    • All min-max planned items
  • Category set: Select specific category set name
  • Categories From: Select the ‘From Category’
  • Categories To: Select the ‘To Category’
  • Items From: Select specific items from
  • Items To: Select specific items to
  • Planners From: Run for a specific planner
  • Planners To: Run for a range of planners
  • Buyers From: Run the report for items belong to a specific buyer
  • Buyers To: Run the report for a range of buyers
  • Sort by: Select sort by option for report output
  • Demand cut-off date: Cut-off date until which all demand is considered
  • Demand cut-off date offset
  • Supply cut-off date: Cut-off date until which all supply is considered
  • Supply cut-off date offset
  • Restock: Yes or No. If you select NO it means it runs in simulation mode
  • For Repetitive Item:
  • Default deliver to: Deliver to location
  • Net Unreserved Orders: Yes/ No
  • Net Reserved Orders: Yes / No
  • Net WIP Demand: Yes / No
  • Include PO Supply: Yes / No
  • Include Move Order Supply: Yes / No
  • Include WIP Supply: Yes / No
  • Include Interface Supply: Yes / No
  • Include Nonnettable: Yes / No
  • Lot Control:
  • Display Format:
  • Display Item Description: Yes / No

Submit the request and view the output of the concurrent request.

11.4 Approve Cycle Count Entries

 

  • Form Application: Inventory
  • Form Name: INVAMCAP
  • Form Path: /oracle/apps/r12/visr12/apps/apps_st/appl/inv/12.0.0/forms/US/INVAMCAP.fmx

Cycle count process is periodic schedule inventory counting and verification process. Once cycle count is setup it can be scheduled to run automatically based on ABC class and count frequency. Then actual physical counting happens and results of counting is captured in system. Based on cycle count setup, if quantity/value variance is beyond the limits then approval may be required.

Navigation: Inventory responsibility -> Counting -> Cycle Counting -> Approve Counts

  • Select the ‘Cycle Count’ name from the drop down
  • Click ‘Find’, choose ‘Yes’ when prompted with ‘Query counts pending approval only’
  • Verify the actual count quantity, system quantity and variance.
  • Decide if the variance can be approved or further investigation/recount is required.
  • Select the ‘Approved’ radio button

Save the changes. Now variance is approved and system onhand inventory is adjusted with actual count quantity.

Approve Cycle Count Entries

Approve Cycle Count Entries

11.3 Enter Cycle Count Entries

 

  • Form Application: Inventory
  • Form Name: INVATCEN
  • Form Path: /oracle/apps/r12/visr12/apps/apps_st/appl/inv/12.0.0/forms/US/INVATCEN.fmx

Cycle count process is periodic schedule inventory counting and verification process. Once cycle count is setup it can be scheduled to run automatically based on ABC class and count frequency or manual schedules can be entered to do cycle count for specific items on periodic basis. Once cycle count is scheduled the next step is actually doing the counting and capturing the results in count quantity. This will help is doing inventory variance and approval.

Navigation: Inventory responsibility -> Counting -> Cycle Counting -> Cycle Count Entries

  • Select the ‘Cycle Count’ name from the drop down
  • Click ‘Find’, choose ‘Yes’ when prompted with ‘Find all open count requests’
  • Select the specific count sequence you have counted or create a new count if dynamic count is allowed
  • Enter actual ‘Count quantity’

Save the changes. Now new count quantity is captured against the system quantity. The difference is variance and based on cycle count setup, system enforces if any approval is required.

Enter Cycle Count Entries

Enter Cycle Count Entries