Results for “forecast_designator”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

EDW_FORECAST_FKV is a foreign key (FK) derivation view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the ISC – Supply Chain Intelligence product family. In the context of Oracle EBS 12.1.1 and 12.2.2, it serves as a supporting object for the Oracle Supply Chain Intelligence data warehouse rather than as a transactional or operational view. Its documented purpose is to allow fact views to derive the Forecast dimension foreign keys used when populating star-schema style reporting structures.

Forecast data in Oracle EBS originates in the MRP (Material Requirements Planning) and Advanced Supply Chain Planning schemas, where forecasts are identified by a forecast designator scoped to an inventory organization. The Supply Chain Intelligence warehouse needs a single, stable surrogate key to represent that natural combination in its dimension and fact tables. EDW_FORECAST_FKV supplies precisely that composite key, so fact views can join forecast facts to the forecast dimension without repeatedly reconstructing the identifier logic.

Underlying Base Objects

According to the documented view text, EDW_FORECAST_FKV is defined over three base objects:

• MRP_FORECAST_DESIGNATORS — the forecast designator master table. This is the object referenced in the original search term mrp_forecast_designators and is the primary source of the forecast identity.
• MTL_PARAMETERS — the inventory organization parameters table, used to validate and scope forecasts to valid organizations.
• EDW_LOCAL_INSTANCE — the Supply Chain Intelligence instance table that supplies the INSTANCE_CODE used to make the generated key unique within a multi-instance or multi-source warehouse configuration.

The join is restricted by the predicate FD.FORECAST_SET IS NOT NULL, ensuring only designators that belong to an actual forecast set are returned, and by FD.ORGANIZATION_ID = MP.ORGANIZATION_ID, which ties each designator to a defined inventory organization. Although the documented metadata lists no formal base objects, the view text explicitly references these three tables; they should be treated as the effective dependencies for any impact analysis or upgrade assessment between 12.1.1 and 12.2.2.

Key Columns

• FORECAST_FK — the generated foreign key, formed as FORECAST_DESIGNATOR concatenated with ORGANIZATION_ID and INSTANCE_CODE using a hyphen delimiter. Because the designator may itself be composed of multiple segments, this composite remains the reliable join key only within the same instance and organization context.
• FORECAST_DESIGNATOR — the business name of the forecast designator as stored in MRP_FORECAST_DESIGNATORS; used for display and for reconciliation back to the planning application.
• ORGANIZATION_ID — the inventory organization to which the designator is scoped, providing the organizational filter required by multi-org security and by organization-level forecast reporting.

Common Use Cases and Queries

The view is typically consumed indirectly: fact views in the Supply Chain Intelligence schema select from it to resolve forecast keys before loading or joining forecast facts. Reporting developers may also query it directly to enumerate valid forecast designators per organization.

• Populating a forecast fact load with the correct FK for each designator/organization pair.
• Validating that a forecast designator is associated with a forecast set and a defined inventory organization before reconciliation.
• Resolving the composite key back to its designator and organization components when investigating dimension mismatches.

A representative query is:

SELECT forecast_fk, forecast_designator, organization_id FROM apps.edw_forecast_fkv WHERE organization_id = :org_id ORDER BY forecast_designator;

Because the view performs the concatenation at runtime, filtering on ORGANIZATION_ID and FORECAST_DESIGNATOR is preferable to filtering on FORECAST_FK, which is a derived expression with no supporting index of its own.