Search Results msc_atp_utils




Overview
Explore in AI Chat

Overview

MRP_ATP_UTILS is a utility package owned by the APPS schema in Oracle E-Business Suite releases 12.1.1 and 12.2.2. The name associates it with Available-to-Promise (ATP) processing within the Oracle Advanced Supply Chain Planning and Manufacturing family of modules, and the object is catalogued in the E-Business Suite Technical Reference Manual (ETRM) as an OTHER-classified API, meaning it is a supporting internal utility rather than a formally published public interface.

The package provides low-level plumbing that the ATP engine relies upon during availability checks against planned and on-hand supply. Its documented dependencies are narrow and deliberate: it references MRP_ATP_PUB and the SYS.STANDARD package, and it is itself referenced by MRP_ATP_UTILS (recursive or overloaded use), MSC_ATP_UTILS, and one additional dependent package. That MSC_ATP_UTILS appears in the dependency list confirms that the same utility logic is shared between the core MRP/ATP code path and the MSC (Advanced Supply Chain Planning) schema, which is consistent with how ATP routines are reused across planning products in the EBS architecture.

Key Procedures and Functions

The ETRM documents six callable units inside MRP_ATP_UTILS. Their responsibilities, as recorded in the reference metadata, are as follows.

  • PUT_INTO_TEMP_TABLE — Stores working data into a temporary staging structure for subsequent processing. This is the write half of the package's scratch-space mechanism.
  • GET_FROM_TEMP_TABLE — Retrieves previously staged data from that temporary structure. Used together with PUT_INTO_TEMP_TABLE to pass intermediate results between procedural steps without relying on persistent tables.
  • CALL_ATP_11 — Invokes an ATP availability calculation, corresponding to the ATP request path in the 11.x-lineage engine retained in later releases. Acts as the internal entry point that brokers the call to the published ATP API.
  • EXTEND_MAST — Expands a master schedule (mast) record or range, growing the scheduling horizon or the set of master schedule entries under evaluation. Used when an availability check spans a window wider than the initially supplied master schedule.
  • TRIM_MAST — The inverse operation; it reduces or truncates the master schedule range so that only the relevant portion is retained for the ATP calculation. EXTEND_MAST and TRIM_MAST together give the ATP engine control over the scope of master schedule data it processes.
  • TEST — A diagnostic entry point used for exercising the package's internal logic during development or validation.

Tables Accessed

The only table documented against this package is PLITBLM, accessed through an APPS synonym. PLITBLM is a long-standing Oracle EBS table used as a temporary storage location for lists and set-based values. Its presence here is consistent with the temporary-table procedures: PUT_INTO_TEMP_TABLE and GET_FROM_TEMP_TABLE stage intermediate ATP data in PLITBLM rather than creating application-owned tables, which keeps traffic out of permanent planning tables and allows the callers in MRP_ATP_PUB and MSC_ATP_UTILS to share state across procedure boundaries.

Usage Notes

MRP_ATP_UTILS is an internal utility. It is not intended to be called directly from forms, concurrent programs, or customer extensions. Invocation normally originates from within MRP_ATP_PUB or from the MSC schema's ATP utilities, which call these procedures during availability and scheduling calculations. Because it is not a published API, its signature and behaviour are not guaranteed across patch levels, and Oracle does not document it for external consumption. Customizations that need ATP availability should use the supported ATP APIs exposed in MRP_ATP_PUB instead. The package is listed as VALID in the ETRM, indicating a successfully compiled state at the time of the reference documentation.