Search Results msc_aatp_req




Overview
Explore in AI Chat

Overview

MSC_AATP_REQ is an Oracle E-Business Suite package owned by the APPS schema that supports Advance Available-to-Promise (AATP) processing within the Advanced Supply Chain Planning (ASCP) and Global Order Promising (GOP) modules. The package encapsulates the server-side logic required to evaluate allocated ATP — the portion of supply that has already been reserved or pre-allocated to specific demands — and to determine feasible promise dates when a supply source is consumed by higher-priority allocations. Its primary role is to answer the question of whether an item can be promised against a given organization, demand class, and request date, factoring in allocations, planning scenarios, and forward scheduling considerations.

The package sits within the MRP/ATP runtime stack and is referenced by four other packages, indicating that it functions as a shared utility layer invoked by higher-level ATP check routines rather than as a standalone entry point. It interacts with the MRP_ATP_PVT and MRP_ATP_PUB packages through typed OUT parameters, returning structured ATP information, ATP periods, and supply/demand detail sets to its callers.

Key Procedures and Functions

ETRM 12.2.2 documents two procedures for this package, although the source header reveals additional internal methods referenced in the specification.

  • ITEM_PRE_ALLOCATED_ATP — Evaluates ATP for an item at a specified planning level, scenario, and organization, returning the ATP information, ATP period, and supply/demand arrays through its OUT parameters. It accepts a request item identifier and ATF (Available To Future) date to support time-phased ATP evaluation, and takes a refresh number to accommodate summary enhancement processing. This procedure is the core allocation-aware ATP query.
  • GET_FORWARD_MATERIAL_ATP — Added in 2002 by copying logic from the earlier Get_Material_Atp_Info routine, this procedure performs forward-scheduling ATP evaluation. It is called by MSC_ATP_PVT.ATP_Check when forward stealing of allocated supply is required, and returns the requested date quantity, ATF date quantity, ATP date at the current level, pegging table, return status, and used available quantity. The header also documents GET_MAT_IN_REC and the legacy Get_Material_Atp_Info referenced from the specification.

Tables Accessed

The package reads and writes several MSC and MRP tables through APPS synonyms:

Usage Notes

MSC_AATP_REQ is not exposed as a user-facing API; it is invoked programmatically by ATP checking routines such as MSC_ATP_PVT.ATP_Check and by three additional referencing packages. It is typically called during order promising, scheduling, and planning runs when the system must determine whether allocated supply can be reassigned forward to satisfy a new demand. Customizations that need to replicate ATP logic should call the public procedures rather than querying the underlying MSC_ALLOC and MSC_ATP tables directly, as the package manages temporary table lifecycle and array typing. Because the two documented procedures accept plan, level, scenario, and instance identifiers, callers must ensure a valid planning context is established before invocation.