Search Results msd_dp_formula_pkg




Overview
Explore in AI Chat

Overview

MSD_DP_FORMULA_PKG is an Oracle Applications (APPS) schema PL/SQL package that forms part of the Oracle Advanced Planning / Demand Planning (MSD) product family within Oracle E-Business Suite. In ETRM terms it is classified as an "OTHER" API object, meaning it is not a public, customer-facing interface such as an open interface or public API, but rather an internal support package used by the Demand Planning application logic. Its central business function is the maintenance and loading of demand planning formula definitions — the analytical or mathematical expressions that Demand Planning uses to derive forecast values, apply adjustments, and model demand at various levels of the planning hierarchy. The package exists in both a package specification and a package body (both reported as VALID in the APPS schema), and its only documented dependency other than the SYS.STANDARD package is a self-reference, confirming it is a self-contained utility rather than a layered component sitting on top of other MSD packages.

Key Procedures and Functions

The documented interface for MSD_DP_FORMULA_PKG exposes one procedure: LOAD_ROW. Consistent with the ETRM metadata, no parameter list is published here and none should be assumed. Its evident purpose is to load a single row of formula definition data into the Demand Planning repository — that is, to insert or update one formula record together with any associated parameter values. This pattern is typical of Oracle's "row loader" utilities used to seed and migrate application reference or setup data. Because only a single documented entry point exists, the package should be regarded as a narrow, focused loader rather than a general formula-processing engine.

Tables Accessed

The package operates against three documented tables, accessed through APPS synonyms:

  • MSD_DEMAND_PLANS — the demand plan header/definition table, consulted to identify the plan context to which a formula row belongs.
  • MSD_DP_FORMULAS — the primary target table holding formula definitions; LOAD_ROW will insert or update rows here.
  • MSD_DP_PARAMETERS_S — the dated ("_S" suffix) parameter table, typically carrying effective-dated attributes associated with the formula or plan; the loader will populate or maintain parameter records alongside the formula.

The involvement of the effective-dated parameters table indicates that formula loading is date-sensitive and must preserve the temporal validity of planning parameters.

Usage Notes

Given its classification and its dependency profile, MSD_DP_FORMULA_PKG is not intended for direct invocation by end users or by general custom code. The metadata reports that it is referenced by zero other packages, so within the shipped application it is invoked either by Demand Planning forms, by concurrent programs performing setup data seeding or migration, or by internal MSD routines during plan or formula administration. Practical guidance for 12.1.1 and 12.2.2 environments is as follows: treat the package as internal and version-sensitive; do not build customer extensions directly against it without confirming behaviour in the target release; and exercise caution if calling LOAD_ROW from custom code, since it writes into core Demand Planning setup tables (MSD_DP_FORMULAS and MSD_DP_PARAMETERS_S) and can affect plan definitions referenced by MSD_DEMAND_PLANS. Where formula data must be migrated between environments, prefer supported setup-data movement utilities, reserving direct execution for controlled administrative scenarios with appropriate backups.