Search Results get_res_hierarchy_demand_class

Overview

MSC_AATP_FUNC is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It belongs to the Advanced Supply Chain Planning (ASCP) product family within the MSC schema domain and supports Available-to-Promise (ATP) and Available-to-Deliver (ATD) processing logic. The package encapsulates the allocation and demand-classification rules that drive ATP/ATD calculations in the planning engine, exposing reusable functions that other planning packages invoke rather than duplicating allocation logic inline.

The package is classified as OTHER in the ETRM API registry, indicating it is an internal, non-public API not intended for direct customer extension. Its documented status is VALID, and its dependency footprint confirms that it sits in the planning allocation layer: it consumes data from allocation, demand, and trading-partner tables and calls into MSC_ATP_PVT, the private ATP engine package.

Key Procedures and Functions

The documented interface exposes six functions, all read-only in nature and all returning calculation values rather than performing DML:

• GET_ALLOWED_STOLEN_PERCENT — returns the permitted percentage of "stolen" supply, i.e. inventory or supply that may be reallocated away from one demand in favor of another higher-priority demand.
• GET_DC_ALLOC_PERCENT — returns the allocation percentage applicable to a distribution center, used when distributing constrained supply across DC-level demands.
• GET_HIERARCHY_DEMAND_CLASS — derives the demand class associated with a hierarchy node, enabling demand-class-aware allocation across item or resource hierarchies.
• GET_ITEM_DEMAND_ALLOC_PERCENT — returns the allocation percentage for a given item and demand class combination.
• GET_RES_DEMAND_ALLOC_PERCENT — returns the equivalent allocation percentage at the resource level.
• GET_RES_HIERARCHY_DEMAND_CLASS — resolves demand class from a resource hierarchy path.

Together these functions implement the percentage-based allocation model used by ASCP: supply is apportioned to demands according to configurable percentages, with stolen-supply allowances and hierarchy-driven demand classes determining priority.

Tables Accessed

MSC_AATP_FUNC reads three documented tables through APPS synonyms:

• MSC_ALLOCATIONS — stores the allocation percentage definitions that the GET_*_ALLOC_PERCENT functions retrieve.
• MSC_DEMANDS — holds demand records whose demand class and hierarchy attributes feed GET_HIERARCHY_DEMAND_CLASS and GET_RES_HIERARCHY_DEMAND_CLASS.
• MSC_TRADING_PARTNERS — supplies partner-level attributes used in allocation and demand resolution.

Additional dependencies include the materialized views MSC_ITEM_HIERARCHY_MV and MSC_RESOURCE_HIERARCHY_MV, which resolve hierarchy paths, and FND_PROFILE for profile-option-driven behavior. The package also references MSC_ATP_PVT and MSC_SCH_WB, indicating delegation of lower-level ATP logic and plan workbench integration.

Usage Notes

Because the package is classified OTHER and is not referenced by any database object according to the ETRM record, it is invoked from within the planning stack—most likely from concurrent programs and planning-engine batch processes that need allocation percentages and demand-class resolution—rather than from open interfaces or public APIs. Oracle does not publish a supported signature for these functions; implementers should treat them as internal planning primitives.

Direct calls from custom code are discouraged, since the package contract may change between 12.1.1 and 12.2.2 and is not covered by Oracle's public API compatibility guarantee. Where custom extensions require allocation logic, the supported approach is to consume the underlying MSC_ALLOCATIONS data or the public ATP APIs exposed through MSC_ATP_PVT. The presence of eight downstream referencing packages confirms that the package is a shared internal dependency of the ATP/ATD subsystem.