Search Results msc_satp_func




Overview
Explore in AI Chat

Overview

MSC_SATP_FUNC is an Oracle E-Business Suite PL/SQL package body owned by the APPS schema. Its classification within the ETRM repository is OTHER, and its status is VALID. The package forms part of the Oracle Advanced Supply Chain Planning (ASCP) scheduling and Available-to-Promise (ATP) infrastructure, specifically the subset of logic that supports supply chain ATP calculations used by the planning engine.

The business function of MSC_SATP_FUNC is to resolve the sourcing decisions, calendar-based timing, and regional mapping data required to evaluate ATP across a supply chain network. It determines the source location for a given demand, derives default ship methods and in-transit times, performs working-day navigation and date offsetting against manufacturing and shipping calendars, and builds the region and zone membership structures used in sourcing rules. In effect, it supplies the calculation primitives that higher-level ATP packages consume when answering whether a requested quantity can be promised on a requested date.

The package is self-referential: MSC_SATP_FUNC references itself, indicating internal calls between its own procedures and functions. It is not referenced by any database object in the dependency listing, though the documented metadata records it as being referenced by 25 other packages, which is consistent with its role as a shared utility layer within the ATP and planning stack.

Key Procedures and Functions

The package exposes 29 documented procedures and functions. They fall into several functional groupings.

Tables Accessed

The package reads and writes a defined set of tables through APPS synonyms. Temporary and working structures include MSC_ATP_SRC_PROFILE_TEMP, MSC_REGIONS_TEMP, MSC_REGIONS, MSC_REGION_LOCATIONS, MSC_REGION_SITES, and MSC_ZONE_REGIONS, which hold region, zone, and sourcing profile data during ATP evaluation. Trading partner and customer data are drawn from MSC_TRADING_PARTNER_SITES, MSC_TP_SITE_ID_LID, HZ_CUST_ACCT_SITES_ALL, HZ_CUST_SITE_USES_ALL, HZ_PARTY_SITES, HZ_LOCATIONS, and HR_ALL_ORGANIZATION_UNITS. Shipping and calendar information is sourced from BOM_CALENDAR_DATES, MTL_INTERORG_SHIP_METHODS, and WSH-related calendar, carrier, and region views listed in the dependency metadata.

Usage Notes

MSC_SATP_FUNC is an internal engine package rather than an end-user entry point. It is normally invoked indirectly by ATP and planning packages such as MSC_ATP_PVT, MSC_ATP_GLOBAL, MSC_ATP_24X7, MRP_ATP_PUB, MSC_SCH_WB, and ORDER_SCH_WB, which appear in its dependency list and call into it during plan execution or order promising. It is not exposed through a standard concurrent program of its own. Customizations should treat the package as an unsupported internal interface; direct calls are advisable only when replicating ATP sourcing or calendar logic in a controlled extension. Because it relies on FND_GLOBAL, FND_PROFILE, and FND_MESSAGE, correct application context and profile options must be established before invocation.