Search Results forecast_set_name




Overview
Explore in AI Chat

Overview

The view EDW_MRP_FCDM_FCST_SET_LTC_IV is a reporting and integration object belonging to the BIS (Business Intelligence System) product family, historically associated with Oracle's Enterprise Data Warehouse and Demand Planning analytics layer. It exposes forecast set master data in a shape suitable for extraction, transformation, and load into downstream analytical models. The view is documented in the ETRM repository for Oracle EBS 12.1.1 and 12.2.2, though it is flagged as "Not implemented in this database," meaning the object may only exist where the corresponding BIS/EDW staging components have been deployed.

The suffix _IV typically denotes an "interface view" used to publish a canonical column set to external consumers, while the presence of a literal OPERATION_CODE constant column reflects a change-data-capture or replication convention common in EDW feed definitions. This view surfaces the forecast set name through the FORECAST_SET_NAME column, which is directly relevant to users searching on that term.

Underlying Base Objects

The view is defined over a single underlying object, EDW_MRP_FCDM_FORECAST_SET_LTC, which is an LTC (Large Table Collection / logical table collection) staging object housing forecast set records. The view is essentially a direct projection of that base table, adding two computed columns: a constant blank OPERATION_CODE and the base table's ROWID aliased as ROW_ID.

The column naming convention FORECAST_SET_PK, FORECAST_SET_PK_KEY, and FORECAST_SET_PK_ROWID indicates a surrogate key derivation strategy used by the EDW extraction framework, and FORECAST_SET_DP captures the associated data processing or data pump attribute. No additional base objects are documented in the ETRM metadata.

Key Columns

  • FORECAST_SET_NAME — The primary business identifier of the forecast set; the column most commonly queried.
  • NAME and DESCRIPTION — Descriptive attributes of the forecast set record.
  • CONSUMPTION_LEVEL — Indicates the level at which forecast consumption is applied.
  • INSTANCE_CODE — Identifies the source EBS instance in a multi-instance EDW feed.
  • FORECAST_SET_PK / _KEY / _ROWID — Surrogate key components used for downstream joins and change tracking.
  • FORECAST_SET_DP — Data processing attribute associated with the forecast set extract.
  • CREATION_DATE / LAST_UPDATE_DATE — Standard audit columns supporting incremental loads.
  • USER_ATTRIBUTE1 … USER_ATTRIBUTE15 — Descriptive flexfield segments carried through from the base table.
  • OPERATION_CODE — Constant placeholder (blank) reserved for CDC/replication operations.
  • ROW_ID — Row identifier projected from the base table ROWID.

Common Use Cases and Queries

This view is typically consumed by EDW loaders and analytics reports that require a stable, named interface for forecast set data. A common retrieval follows the pattern below:

  • Locate a forecast set by name: SELECT FORECAST_SET_NAME, NAME, DESCRIPTION, CONSUMPTION_LEVEL FROM EDW_MRP_FCDM_FCST_SET_LTC_IV WHERE FORECAST_SET_NAME = :p_name;
  • Extract all forecast sets for a specific instance: SELECT * FROM EDW_MRP_FCDM_FCST_SET_LTC_IV WHERE INSTANCE_CODE = :p_instance;
  • Incremental extraction by audit columns: SELECT FORECAST_SET_NAME, LAST_UPDATE_DATE FROM EDW_MRP_FCDM_FCST_SET_LTC_IV WHERE LAST_UPDATE_DATE > :last_run;
  • Count and group forecast sets: SELECT INSTANCE_CODE, COUNT(*) FROM EDW_MRP_FCDM_FCST_SET_LTC_IV GROUP BY INSTANCE_CODE;

Because the view is reported as not implemented in the current database, confirm its existence in ALL_VIEWS before relying on it, and validate that the base object EDW_MRP_FCDM_FORECAST_SET_LTC is present in the target environment.