Search Results view_allocation

Overview

MSC_AATP_PVT is a private (API classification PVT) PL/SQL package owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It belongs to the Advanced Supply Chain Planning (ASCP) and Global Available-to-Promise (Global ATP) family of modules and is not exposed for direct customer calls. Its role is to support allocation-based ATP processing, specifically the allocation and cumulative ATP enforcement logic that governs how supply is reserved and how demands consume available capacity.

Functionally, the package implements the notification and request-handling side of ATP allocation. Where the public package MSC_ATP_REQ raises allocation or cumulative ATP requests, MSC_AATP_PVT performs the underlying computation, evaluation, and consumption of those requests. It coordinates demand classification, resource allocation cumulation, supplier allocation cumulation, and the "stealing" of ATP across demands to satisfy higher-priority requirements, a characteristic behaviour in Global ATP allocation processing.

Key Procedures and Functions

The documented package exposes eight procedures and functions:

• ATP_DEMAND_CLASS_CONSUME — Handles consumption of ATP associated with a demand class, applying demand-class priority rules when multiple demands compete for the same supply.
• ADD_TO_NEXT_STEAL_ATP — Adds quantity to the next candidate available for ATP stealing, extending the pool from which lower-priority allocations may be reallocated.
• ITEM_ALLOC_CUM_ATP — Maintains cumulative ATP for item-level allocations, tracking the running total of ATP consumed against an item.
• RES_ALLOC_CUM_ATP — Performs equivalent cumulative ATP processing at the resource level, aggregating allocation totals for constrained resources.
• SUPPLIER_ALLOC_CUM_ATP — Applies cumulative ATP logic to supplier capacity allocations, supporting supplier-side ATP commitments.
• GET_DC_INFO — Retrieves demand-class and related configuration information used by the allocation logic.
• VIEW_ALLOCATION — Exposes allocation details for inspection, typically used for diagnostics or detail display.
• STEALING — Executes the ATP stealing operation, determining which already-committed allocations can be reallocated to satisfy higher-priority demands.

Tables Accessed

Through APPS synonyms, the package reads and writes: MSC_ALLOCATIONS, MSC_DEMANDS, MSC_SUPPLIES, MSC_NET_RESOURCE_AVAIL, MSC_RESOURCE_REQUIREMENTS, MSC_SUPPLIER_CAPACITIES, and MSC_CALENDAR_DATES for supply, demand, capacity, and calendar information. MSC_SYSTEM_ITEMS, MSC_DESIGNATORS, and MSC_TRADING_PARTNERS supply item, demand-class, and supplier master data. MSC_PLANS and MSC_APPS_INSTANCES identify the plan and application instance context. Working tables MRP_ATP_DETAILS_TEMP and MSC_ATP_SD_DETAILS_TEMP hold intermediate results, and MSC_DEPARTMENT_RESOURCES supports resource-level allocation.

Usage Notes

MSC_AATP_PVT is an internal companion to MSC_ATP_REQ and is invoked indirectly whenever ATP allocation requests are processed by Global ATP, ASCP planning runs, or order-management ATP checks originating from Oracle Order Management. It is referenced by six packages, including MSC_ATP_REQ, MSC_ATP_ALLOC, MSC_ATP_PF, MSC_ATP_PVT, MSC_ATP_SUBST, and MRP_AATP_PVT, confirming its position as a collaborative worker rather than an entry point.

Customers should not call these private procedures directly. Customizations requiring allocation or cumulative ATP behaviour should route through the supported MSC_ATP_REQ interface or the ATP checking APIs, allowing MSC_AATP_PVT to perform the allocation, cumulation, and stealing logic transparently.