Search Results msd_dp_parameters_cs_v




Overview
Explore in AI Chat

Overview

MSD_DP_PARAMETERS_CS_V is a read-only view owned by the APPS schema in Oracle E-Business Suite, belonging to the MSD (Demand Planning) product family within the Advanced Planning Command Center / Demand Management module. The view consolidates the input parameters that govern a Demand Plan, exposing both the configured parameter definitions and their human-readable decoded meanings. In EBS 12.1.1 and 12.2.2, this object serves as a reporting and integration layer over the raw planning setup tables, allowing reports, concurrent programs, and external extracts to retrieve Demand Plan parameters without manually joining the numerous lookup and definition tables that underlie the model.

The view's stated purpose in the ETRM metadata is to "provide Demand Plans Input Parameters." It therefore acts as a single denormalized source for the parameter set (forecast date, quantity, and amount measures, forecast type, fact type, scenarios, and rolling-cycle behavior) associated with each Demand Plan.

Underlying Base Objects

The view is defined over the following APPS objects:

Key Columns

Common Use Cases and Queries

Typical usage includes auditing plan configuration, driving BI Publisher extracts, and diagnosing forecast measure mappings. A representative query retrieves all parameters for a named plan:

  • SELECT DEMAND_PLAN_NAME, PARAMETER_NAME, PARAMETER_TYPE, FORECAST_DATE_USED, QUANTITY_USED, AMOUNT_USED, SCENARIO_NAME FROM APPS.MSD_DP_PARAMETERS_CS_V WHERE DEMAND_PLAN_NAME = :p_plan;
  • Filter by scenario or input plan to reconcile scenario-driven inputs.
  • Extract FORECAST_USED and FACT_TYPE meanings for configuration review and documentation.

Because the view performs outer joins to lookup and identifier views, it is safe for read-only reporting; parameter maintenance should be performed through the Demand Planning application forms rather than against the view.