Search Results send_dates

Overview

The APPS.MSC_ALLOCATION_PLAN package is a PL/SQL program unit in the Oracle E-Business Suite Advanced Supply Chain Planning (ASCP) module, part of the MSC (Master Scheduling/MRP and Supply Chain Planning) schema family. Its primary business function is to support the allocation planning and supply/demand pegging workflow, particularly the drill-down and drill-across capabilities used by planners when reviewing how supplies are allocated to demands across a planning horizon. The package operates against the ASCP planning engine's transaction tables, assembling the data structures required to present allocation results within the Planner Workbench and related horizontal plan inquiries. The package is classified as an "OTHER" API, indicating it is intended primarily for internal engine and UI consumption rather than as a public integration interface.

Key Procedures and Functions

The documented package exposes five procedures/functions, each supporting a specific phase of allocation planning and drill-down presentation:

• POPULATE_ALLOCATION_PLAN — The principal driver that assembles and populates the allocation plan data set for a given plan, materializing the relationships between supplies and the demands they satisfy.
• SEND_DATES — Transmits and reconciles date information, typically for calendar/horizon date ranges used to bucket allocation results across planning periods.
• CREATE_PLANNED_ARRIVAL — Creates planned arrival records, supporting the arrival of supply into the plan and its subsequent eligibility for allocation to demand.
• QUERY_LIST — Returns a list of records used to drive the allocation inquiry/drill-down list, enabling the Planner Workbench to enumerate allocation results.
• FLUSH_SUGGALLOC_DRILLDOWN — Clears the temporary drill-down structure that holds suggested allocation detail, ensuring the workspace is reset between allocation inquiries.

Tables Accessed

The package reads and writes a focused set of ASCP planning tables via APPS synonyms:

• MSC_ALLOCATION_BUCKETS — Stores allocation results grouped by planning bucket.
• MSC_DEMANDS and MSC_SUPPLIES / MSC_SUPPLIES_S — Provide the demand and supply records being allocated.
• MSC_ITEM_SOURCING — Supplies sourcing rules that determine which supply satisfies which demand.
• MSC_SINGLE_LVL_PEG — The single-level pegging records that define allocation relationships.
• MSC_DRP_HORI_PLANS — Distribution/horizontal plan definitions that scope the allocation horizon.
• MSC_PLANS and MSC_PQ_TYPES — Plan definitions and plan query types.
• MSC_FORM_QUERY / MSC_FORM_QUERY_S — Stores form query criteria for the allocation UI.
• DUAL and PLITBLM — Standard utility references.

Usage Notes

MSC_ALLOCATION_PLAN is typically invoked indirectly by ASCP forms and concurrent programs rather than called directly from custom code. It is referenced by MSC_ALLOCATION_PLAN (the allocation plan form/entity) and MSC_HORIZONTAL_PLAN_SC, confirming its role in the Planner Workbench's allocation and horizontal plan screens. Customizations that call it directly should be treated as unsupported. Planners trigger allocation review through the Allocation and Horizontal Plan windows; the package assembles, queries, and flushes the drill-down data behind those actions. Because the package is documented as VALID and classified OTHER, Oracle support covers it as internal engine code. 12.1.1 and 12.2.2 behavior is consistent; the 12.2.x online patching model does not alter its runtime semantics.