Search Results mrpbv_forecasts




Overview
Explore in AI Chat

Overview

MRPBV_FORECASTS is a read-only view owned by the APPS schema in Oracle E-Business Suite, delivered under the MRP (Master Scheduling/MRP) product family. It presents forecast designator information for a given inventory organization in a denormalized, reporting-friendly form, joining forecast header data to organization identifiers and names. The view is documented as "Retrofitted," indicating it is a legacy object maintained for backward compatibility, and it is exposed WITH READ ONLY to prevent DML against the underlying base tables through the view. In both 12.1.1 and 12.2.2, the object retains a VALID status and its definition is unchanged.

Its principal role is to support inquiry, reporting, and integration scenarios where forecast sets and their associated designators must be listed alongside the owning organization's code and name. Because it joins organization definition tables, it removes the need for consumers to resolve organization identifiers manually, making it convenient for custom reports, BI Publisher data models, and interface extracts.

Underlying Base Objects

The view is defined over three base objects, each referenced through a synonym in the APPS schema:

The three tables are joined on ORGANIZATION_ID: the forecast rows are linked to MTL_PARAMETERS and HR_ALL_ORGANIZATION_UNITS through their respective ORGANIZATION_ID columns. A filter restricts results to rows where FORECAST_SET is not null. The definition also embeds a security predicate ('_SEC:DE.ORGANIZATION_ID'), which enforces organization-level access control consistent with Oracle's Multi-Org architecture, so results are limited to organizations the querying responsibility may access.

Key Columns

Common Use Cases and Queries

Typical uses include validating forecast setup before running a master scheduling or MPS/MRP plan, extracting forecast designators for a data warehouse or interface, and building inquiry pages that display forecasts by organization. The view is also useful for auditing which forecast sets and demand classes are active in each organization.

A representative query listing all forecasts for a specific organization:

  • SELECT organization_code, organization_name, forecast_name, forecast_set_name, demand_class, inactive_date FROM apps.mrpbv_forecasts WHERE organization_code = :org_code ORDER BY forecast_name;
  • SELECT forecast_name, forecast_description, forecast_set_name, inactive_date FROM apps.mrpbv_forecasts WHERE inactive_date IS NULL OR inactive_date > SYSDATE; — returns only currently active forecasts.
  • SELECT organization_code, COUNT(*) FROM apps.mrpbv_forecasts GROUP BY organization_code; — summarizes forecast counts per organization.

Because access is subject to organization security, queries executed from a responsibility limited to certain organizations return only the permitted subset. The view remains a stable, read-only reporting artifact in both 12.1.1 and 12.2.2.