Search Results msd_common_utilities




Overview
Explore in AI Chat

Overview

MSD_COMMON_UTILITIES is a foundational PL/SQL package body owned by the APPS schema in Oracle E-Business Suite, delivered as part of the Advanced Supply Chain Planning and Demand Planning (MSC/MSD) product family. Its primary business function is to centralize a broad set of reusable utility routines that other planning modules call to resolve surrogate keys, translate level and dimension definitions, perform unit-of-measure conversions, and retrieve instance and database link information. The package is classified as a utility ("OTHER") API rather than a public business API, and it is heavily reused across the application: the ETRM metadata records that MSD_COMMON_UTILITIES is referenced by 64 other packages. The package body is documented as VALID and carries 44 procedures and functions, making it one of the more broadly depended-upon objects in the planning data model. It supports both EBS 12.1.1 and 12.2.2, and its design reflects the need for a single, consistent layer that shields planning code from the complexity of the underlying multidimensional schema.

Key Procedures and Functions

The documented routines fall into several functional groups:

These utilities are invoked internally rather than exposed as a user-facing API. They encapsulate joins and lookups that would otherwise be repeated throughout the MSC and MSD code base.

Tables Accessed

MSD_COMMON_UTILITIES reads from a range of planning and setup tables through APPS synonyms. Instance and connectivity data come from MSC_APPS_INSTANCES. Item and sourcing information is drawn from MSC_SYSTEM_ITEMS, MSC_ITEM_SUPPLIERS, MSC_ASL_AUTH_DETAILS, and MSC_SAFETY_STOCKS. Plan-level configuration is obtained from MSC_PLANS, MSC_TRADING_PARTNERS, and MSC_TP_ID_LID. UOM processing relies on MSC_UOM_CONVERSIONS and MSC_UOM_CLASS_CONVERSIONS. The multidimensional level model is accessed through MSD_LEVELS, MSD_LEVEL_VALUES, MSD_LEVEL_VALUES_S, MSD_LEVEL_ASSOCIATIONS, MSD_ST_LEVEL_VALUES, MSD_SR_LEVEL_PK_S, MSD_TIME, MSD_DEMAND_PLANS, MSD_DP_SCENARIO_OUTPUT_LEVELS, and MSD_SETUP_PARAMETERS. Standard Oracle facilities including FND_CONCURRENT, FND_FILE, FND_LOOKUP_VALUES_VL, FND_PROFILE, DBMS_LOB, and DUAL are also referenced. The package provides a consistent read layer over these tables so that dependent packages need not embed the same join logic.

Usage Notes

MSD_COMMON_UTILITIES is not typically invoked directly by end users. It is called programmatically by other planning packages, concurrent programs, and planning engine routines during demand and supply planning processing. Because it is an internal utility with no documented public API contract, custom code should invoke it cautiously and only after confirming signature stability across the target release. In EBS 12.1.1 and 12.2.2 the package remains VALID; any customization should follow Oracle's documented support policy for modifying or extending seeded APPS objects, and callers should be aware that downstream behavior depends on the correctness of the level, UOM, and key-resolution logic this package provides.