Search Results msc_atp_global




Overview
Explore in AI Chat

Overview

MSC_ATP_GLOBAL is an Oracle EBS Advanced Supply Chain Planning (ASCP) package owned by the APPS schema. Its name reflects its purpose: managing global Advanced Planning and Scheduling (APS) session state and ATP (Available-to-Promise) processing logic shared across the MSC (MSC = "Master Scheduling and Capacity") family of packages. In 12.1.1 and 12.2.2, ATP calculations for the planning engine rely on session context and version information that must be established before ATP queries are executed. MSC_ATP_GLOBAL provides this shared infrastructure, allowing other MSC packages, particularly the public ATP API (MRP_ATP_PUB) and supporting routines (MSC_ATP_GLOBAL itself, MSC_SATP_FUNC, and MSC_SCH_WB), to operate against a common, consistent ATP session. The dependency list confirms that MSC_ATP_GLOBAL references FND_API, PLITBLM, MRP_ATP_PUB, MSC_SATP_FUNC, and MSC_SCH_WB, while it is not referenced by any database object — a characteristic of packages invoked indirectly through the planning engine and the ATP public API layer.

Key Procedures and Functions

  • EXTEND_ATP — Extends the ATP processing context, typically to calculate or propagate ATP for additional periods or resources beyond the initially established horizon. It is the primary business-facing entry point of the package.
  • GET_APS_VERSION — Returns the current APS (Advanced Planning and Scheduling) version identifier. This is used to ensure downstream ATP calls operate against the correct planning engine version and to guard against mismatched session state.
  • GET_ATP_SESSION_ID — Returns the identifier of the current ATP session. This session ID is used to correlate ATP requests with their persistent state, which is important when multiple ATP calls are made within one planning run.

These three documented procedures constitute the package's public surface. Detailed parameter lists are not part of the documented metadata, so only their purposes are described here.

Tables Accessed

Per the ETRM metadata, the only table referenced through an APPS synonym is PLITBLM. PLITBLM is a PL/SQL internal table type used by the Oracle PL/SQL engine for associative array (index-by table) support and is commonly used to pass collections between the package and FND_API. Its presence here is consistent with ATP session handling, where sets of items, resources, or date ranges are processed as collections. No application data tables are directly accessed by this package; the substantive ATP data access is delegated to MRP_ATP_PUB and MSC_SATP_FUNC.

Usage Notes

MSC_ATP_GLOBAL is not a user-facing form API. It is invoked programmatically from within the ASCP planning engine and from the public ATP API layer. The typical invocation flow is:

  • The planning engine establishes a session and calls GET_ATP_SESSION_ID to obtain a session handle.
  • The engine calls GET_APS_VERSION to verify compatibility between the caller and the planning engine version.
  • ATP processing is then executed via EXTEND_ATP or delegated to MRP_ATP_PUB, which in turn uses MSC_ATP_GLOBAL for shared session logic.

Because it is referenced by 16 other packages and is not referenced by any database object itself, MSC_ATP_GLOBAL functions as a shared utility/session layer rather than a standalone business API. Custom code should not call it directly unless emulating ASCP ATP behavior; the supported entry point for external ATP requests remains MRP_ATP_PUB. When diagnosing ATP issues in 12.1.1 or 12.2.2, check for invalid status on MSC_ATP_GLOBAL and its dependencies, since a compile failure here can cascade to the 16 dependent packages and disrupt ATP availability within the planning engine.