Search Results msc_alloc

Overview

MSC_ATP_ALLOC is an Oracle EBS Advanced Supply Chain Planning (ASCP) package body owned by APPS that implements the allocation logic behind Available-to-Promise (ATP) processing. The package computes and persists ATP allocation details by matching supplies to demands across the planning horizon, including time-phased ATP, backward consumption, and forward consumption logic controlled by the MSC_ATP_FORWARD_CONSUME_METHOD profile option. Allocation results are written to transient staging tables that drive the ATP allocation inquiry and refresh processes exposed through a small set of documented entry points.

The package body is identified in the ETRM repository as a PACKAGE BODY with API classification OTHER. The header comments show a PL/SQL source referenced at version 120.2.12010000.2, populated by the standard ASCP ATP library (MSCATALB.pls). The package is referenced by one other package in the ETRM metadata, indicating it is consumed internally rather than called directly by end-user forms.

Key Procedures and Functions

• VIEW_ALLOCATION_DETAILS — Returns ATP allocation detail rows generated by a prior allocation run. Used to display allocation results for a given session, plan, and item context.
• REFRESH_ALLOCATION_DETAILS — Recomputes allocation detail records for an existing allocation set. Internally drives the Compute_Allocation_Details and Insert_Allocation_Details private procedures that evaluate supplies, demands, and calendar dates across the planning horizon.
• REFRESH_ALLOC_REQUEST — Executes a refresh of ATP allocation on behalf of a request (concurrent submission or programmatic invocation), coordinating session-level allocation recomputation and persistence.

The private procedures Compute_Allocation_Details, Insert_Allocation_Details, and Backward_Consume underpin these public routines, producing an ATP_Period_Typ record and destination item/family identifiers used for time-phased ATP allocation.

Tables Accessed

• MSC_ALLOC_TEMP — Primary staging table for computed allocation results for the current session.
• MSC_ALLOC_SUPPLIES and MSC_ALLOC_DEMANDS — Hold supply and demand records considered during allocation.
• MSC_ALLOC_HIERARCHY_TEMP — Stores item hierarchy used to resolve allocation across bill/component levels.
• MRP_ATP_DETAILS_TEMP — Transient detail records supporting ATP period computation.
• MSC_SUPPLIES, MSC_DEMANDS — Source planning supply and demand data read during allocation.
• MSC_SYSTEM_ITEMS — Item master data (organization, item validation).
• MSC_TRADING_PARTNERS, MSC_TRADING_PARTNER_SITES — Ship-to/customer partner and site lookups.
• MSC_CALENDAR_DATES — Calendar definitions used to align ATP periods with working days.
• DUAL and PLITBLM — Utility access for single-row queries and PL/SQL table manipulation.

Usage Notes

MSC_ATP_ALLOC is invoked indirectly through ASCP ATP frameworks and refresh flows rather than by user forms. The most common invocation path is the ATP allocation refresh concurrent program or an internal ASCP planning engine call that submits REFRESH_ALLOC_REQUEST after new supplies and demands are collected. Debug output is controlled by the MSC_ATP_DEBUG profile option, and forward-consumption behavior is governed by MSC_ATP_FORWARD_CONSUME_METHOD. Custom code should call the documented public procedures—VIEW_ALLOCATION_DETAILS, REFRESH_ALLOCATION_DETAILS, and REFRESH_ALLOC_REQUEST—after populating the associated MSC_ALLOC staging tables, and should treat the package as internal to ASCP since its parameter signatures depend on MRP_ATP_PUB types.