Search Results msc_ws_atp




Overview
Explore in AI Chat

Overview

MSC_WS_ATP is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It forms part of the MSC (Advanced Supply Chain Planning / VCP) family of database objects and exposes availability-to-promise (ATP) functionality through a web-service-oriented interface, as indicated by the "WS" prefix in its name. The package status is recorded as VALID in the ETRM metadata, confirming it is compiled and available in the environment.

The package depends on a set of collection types defined in the APPS schema: MSCCHAR1ARR, MSCCHAR3ARR, MSCCHAR7ARR, MSCCHAR30ARR, MSCCHAR40ARR, MSCCHAR60ARR, MSCCHAR80ARR, MSCCHAR255ARR, MSCDATEARR, and MSCNUMBERARR. These array types are characteristic of the MSC API layer, where tabular input and output values are passed between the caller and the underlying planning engine as PL/SQL collections rather than row-by-row cursor processing. This design allows the ATP logic to accept and return multiple values in a single call, which is consistent with its role as an integration entry point.

Key Procedures and Functions

The ETRM metadata documents two callable program units within the package. No parameter lists are recorded, so only their purpose is described here.

  • GETPROMISEDATE — The core processing routine that determines the earliest date on which a requested quantity of an item can be promised, based on the applicable ATP rules for the organization, item, and demand date supplied by the caller. It represents the internal implementation of the promise-date calculation.
  • GETPROMISEDATE_PUBLIC — The public entry point exposed for external invocation. This wrapper allows forms, concurrent programs, or external integration code to call the promise-date logic without depending on the private structure of the underlying routine, which is a common pattern in Oracle's MSC web-service packages.

Both procedures are classified under the generic "OTHER" API classification, indicating they are not governed by the documented interface controls applied to standard public APIs such as those carrying an FND standard designation.

Tables Accessed

The metadata documents a single referenced table via APPS synonyms: PLITBLM. PLITBLM is a standard Oracle EBS temporary (global temporary table) structure used to hold item, quantity, and date collections during PL/SQL table processing. MSC_WS_ATP reads and writes this table as a staging and working area for the data passed through the collection types listed above, allowing the ATP calculation to operate on a set of values in a single pass rather than processing one request at a time. No direct table references outside of PLITBLM are documented.

Usage Notes

MSC_WS_ATP is referenced by zero other packages according to the ETRM metadata, which indicates it is positioned as a terminal integration point rather than an internal building block for other PL/SQL modules. It is typically invoked when an external application or user interface needs to obtain a promise date for an order line — for example, during order capture in Order Management, through a supply chain planning web service, or from custom integration code that needs to query ATP results.

Because the package is classified as OTHER rather than an FND-standard public API, it should be called with caution from custom code. Oracle does not guarantee backward compatibility for non-standard APIs across patch or release boundaries, and the internal structure of GETPROMISEDATE may change without notice. When invoking GETPROMISEDATE_PUBLIC, callers should expect to supply and receive values through the documented MSC collection types, since the parameter lists are not otherwise published.