Search Results run_min_max_plan

Overview

CSP_MINMAX_PVT is a private PL/SQL package in the Oracle E-Business Suite Applications schema (APPS) that implements the core computational engine behind Oracle's Min-Max planning functionality, which is delivered as part of the Inventory and Advanced Supply Chain Planning footprint. Min-Max planning is a reorder-point style replenishment method in which each item/subinventory combination carries a minimum and maximum quantity target; when projected available supply falls below the minimum, a replenishment suggestion is generated to bring the balance back to the maximum. CSP_MINMAX_PVT encapsulates the logic that reads current on-hand, demand, and supply positions, applies the min-max thresholds, and produces the resulting replenishment and restock recommendations.

The package is classified as PVT (private) in the ETRM metadata, meaning it is not intended to be called directly by external integrations or customers. Its published entry points are invoked internally by other EBS packages — the ETRM records two dependent packages that reference it — and are exposed indirectly through the Min-Max planning concurrent program and the related planning forms.

Key Procedures and Functions

• RUN_MIN_MAX_PLAN — The principal driver procedure. It executes the min-max planning run for a selected scope of items and categories, using flags and selection parameters to control which supply types are netted (on-hand, purchase orders, WIP, internal requisitions), reserved and unreserved quantities, restock handling, approval behavior, buyer and customer filtering, subinventory and locator scope, and cutoff dates. It returns a standard status and message payload for error handling.
• GET_ONHAND_QTY — A function that returns the on-hand quantity for a given item, organization, subinventory, and effective date, with a flag to control inclusion of non-nettable inventory. Referenced in source comments as Bug# 2677358.
• DO_RESTOCK — Performs the restock processing for an item, taking lead-time, account, UOM, and purchasing/order flag inputs to drive replenishment or restock activity.
• GET_SHIPPED_QTY — Returns shipped quantity used in the planning computation.
• GET_STAGED_QTY — Returns staged (staged-to-ship) quantity used to adjust the available supply picture.
• GET_PICK_RELEASED_QTY — Returns pick-released quantity, typically consumed against demand or deducted from available supply.

Tables Accessed

• INV_MIN_MAX_TEMP — Working/interim table holding the min-max planning run results and thresholds.
• MTL_SYSTEM_ITEMS, MTL_SYSTEM_ITEMS_KFV, MTL_ITEM_REVISIONS — Item master, flexfield view, and revision data used to select and validate planned items.
• MTL_ONHAND_QUANTITIES_DETAIL, MTL_MATERIAL_TRANSACTIONS, MTL_MATERIAL_TRANSACTIONS_TEMP — Physical on-hand and transaction history supplying quantity inputs.
• MTL_DEMAND, MTL_RESERVATIONS — Demand and reservation records used in netting logic.
• MTL_PARAMETERS, MTL_SECONDARY_INVENTORIES — Organization and subinventory definitions that frame planning scope.
• MTL_CATEGORIES, MTL_CATEGORIES_KFV — Category selection and hierarchy handling.
• BOM_CALENDAR_DATES — Calendar data used for lead-time and cutoff date calculations.
• FND_USER — User context for the planning run.

Usage Notes

CSP_MINMAX_PVT is a private package and must not be called directly by customer extensions. It is invoked by other EBS packages (two documented dependents) and ultimately surfaced through the Min-Max planning concurrent program and the associated Inventory planning forms. Custom code requiring min-max results should consume the persisted output in INV_MIN_MAX_TEMP rather than calling this package. Because it uses AUTHID CURRENT_USER, execution is governed by the privileges of the invoker, and all table references are resolved through APPS synonyms.