Search Results msd_constrained_forecast_v




Overview
Explore in AI Chat

Overview

The MSD_CONSTRAINED_FORECAST_V view is a Demand Planning (MSD) reporting object owned by the APPS schema. As its ETRM description — "Constrained Plan View" — indicates, it exposes forecast demand quantities that have been generated within the constrained planning process, where supply and capacity limitations have been applied to the demand signal. In Oracle EBS 12.1.1 and 12.2.2, this view is used almost exclusively for reporting and downstream data extraction rather than for transactional processing. It presents demand records at a resolved planning level key, allowing report writers, Discoverer workbooks, and integration routines to query constrained forecast data without having to reconstruct the complex joins between demand, plan, item, trading partner, and level-value tables themselves. The view abstracts several internal constructs — level PK resolution, customer/organization key lookups, and status filtering — into a flat, query-friendly projection.

Underlying Base Objects

The view is defined over a set of documented base objects, all accessed through APPS synonyms where applicable:

The inner query is wrapped by an outer SELECT that renames and projects the resolved columns from the aliased TOTAL inline view.

Key Columns

The view exposes the following principal columns:

Common Use Cases and Queries

Typical uses include constrained forecast reporting, comparison of constrained versus unconstrained demand, and extraction feeds into external planning or BI systems. The view filters demand to specific ORIGINATION_TYPE values (6, 7, 8, 9, 11, 29, 30, 42, 22), excludes non-planning items, and enforces ATO and MRP planning constraints, so it is well suited to "clean" forecast extracts. A representative query:

  • Forecast by plan and item: SELECT cs_name, prd_level_value_pk, end_date, SUM(quantity) FROM apps.msd_constrained_forecast_v WHERE plan_id = :p_plan GROUP BY cs_name, prd_level_value_pk, end_date;
  • Forecast by customer/geography: filter and group on geo_level_value_pk for demand-mix analysis.
  • Period-over-period comparison: join the view to itself on plan_id and end_date to trend constrained quantities across planning cycles.

Because the view is read-only and joins multiple high-volume planning tables, queries should always be filtered by PLAN_ID to avoid full-table scans.