Search Results view_allocation_details

Overview

The APPS.MSC_ATP_ALLOC package is a PL/SQL component within the Oracle E-Business Suite Advanced Supply Chain Planning (ASCP) and Available-to-Promise (ATP) infrastructure. Its principal business function is to support the allocation of supply to demand during ATP processing, providing the computational logic that determines how available on-hand and scheduled receipts are distributed against prioritized demand. The package is classified as an OTHER API within the ETRM repository, meaning it is an internal supporting package rather than a formally published public API. It carries a VALID status in the APPS schema and is a dependency target of the MSC_ATP_PF package, which confirms its role in the wider ATP planning function stack. In both Oracle EBS 12.1.1 and 12.2.2, the package is delivered as part of the standard ASCP/ATP code baseline and should not be modified.

Key Procedures and Functions

The ETRM metadata documents three public program units within the package:

• VIEW_ALLOCATION_DETAILS — Presents the allocation results computed for a given ATP context, exposing the matched supply-to-demand records to the calling session for inquiry or reporting purposes.
• REFRESH_ALLOCATION_DETAILS — Recomputes and repopulates the allocation detail structures, ensuring the working allocation data reflects the current state of supplies, demands, and planning hierarchies before downstream consumption.
• REFRESH_ALLOC_REQUEST — Initiates or services a request to refresh allocation data, acting as the entry point when an external caller (such as a concurrent program or a companion package) needs the allocation process re-executed.

Parameter signatures are not exposed in the available metadata and are therefore deliberately omitted. Callers should consult the shipped package specification in the APPS schema for exact argument lists.

Tables Accessed

The package operates against a defined set of planning tables, referenced through APPS synonyms:

• MSC_ALLOC_TEMP, MSC_ALLOC_SUPPLIES, MSC_ALLOC_DEMANDS, MSC_ALLOC_HIERARCHY_TEMP — the core allocation working tables where supply and demand records, their hierarchy relationships, and intermediate allocation results are staged and persisted.
• MSC_SUPPLIES and MSC_DEMANDS — the primary planning supply and demand repositories from which allocation candidates are sourced.
• MRP_ATP_DETAILS_TEMP — a temporary staging structure used during ATP detail computation.
• MSC_SYSTEM_ITEMS, MSC_TRADING_PARTNERS, MSC_TRADING_PARTNER_SITES — master and reference data used to resolve item attributes and trading partner relationships during allocation.
• MSC_CALENDAR_DATES — calendar information used to align allocation dates with valid working days.
• DUAL and PLITBLM — standard utilities; PLITBLM is the PL/SQL table-to-index-by binary integer mapping used for array handling.

Usage Notes

MSC_ATP_ALLOC is an internal engine package, not a callable public API. It is typically invoked indirectly by MSC_ATP_PF and the ATP planning concurrent programs during the schedule of allocation calculations. It is not exposed through a standard Oracle Forms interface as a direct user action; end users trigger ATP allocation indirectly through order entry, scheduling, or planning concurrent requests. Because the package touches temporary allocation tables, it must be executed within a controlled planning run context to avoid conflicting writes. Custom code should not call its procedures directly, as the signature and semantics are subject to change across patch levels. The only supported interaction is through Oracle's delivered ATP and ASCP concurrent programs. Its documented limitation as an unclassified ("OTHER") API further reinforces that it is a supporting object not intended for external integration.