Search Results fc_fcst_hdr




Overview
Explore in AI Chat

Overview

The FC_FCST_HDR table is a core data object within the Oracle E-Business Suite (EBS) Process Manufacturing Process Planning (GMP) module. It functions as the master header record for production forecasts. In the context of process manufacturing, a forecast represents a projected demand plan for finished goods or co-products, which serves as a critical input for production scheduling and material planning. This table stores the defining attributes and control information for each unique forecast, establishing a one-to-many relationship with its detailed line items. Its primary role is to act as the parent entity for forecast data, enabling the system to manage, version, and reference forecast sets as cohesive units throughout the planning cycle.

Key Information Stored

While the provided metadata does not list all columns, the documented primary and foreign keys reveal the essential structural data. The primary identifier is the FORECAST_ID, a unique system-generated key. The FORECAST column, also constrained by a unique key, typically stores the user-defined name or code for the forecast, such as 'FY25-Q1-FINISHED-GOODS'. Another critical column is TEXT_CODE, which links to the FC_TEXT_HDR table, allowing for the association of descriptive notes or instructions with the forecast header. Other typical columns in such a header table, though not explicitly listed, would include control attributes like creation date, last update date, status, effective dates, and the organizational context.

Common Use Cases and Queries

This table is central to forecast management and integration. Common operational and reporting scenarios include retrieving a list of all active forecasts for a planning period, validating forecast existence before detail line import, and generating summary reports. A typical query involves joining with the detail table (FC_FCST_DTL) to aggregate forecasted quantities by item or period. For instance, a report summarizing total forecasted volume would use a SQL pattern joining FC_FCST_HDR to FC_FCST_DTL on FORECAST_ID. Integration with the Process Scheduling module occurs via the PS_SCHD_FOR table, which references this header to consume forecast data for generating production schedules. Data extracts for downstream planning systems also frequently source from this table and its dependencies.

Related Objects

The FC_FCST_HDR table maintains defined relationships with several key objects in the GMP schema, as per the provided metadata:

  • Parent Reference: The table references FC_TEXT_HDR via the foreign key on TEXT_CODE. This allows descriptive text to be attached to the forecast header.
  • Child Dependencies: Two tables hold foreign key references to FC_FCST_HDR.FORECAST_ID:
    • FC_FCST_DTL: This is the primary child table, storing the individual forecast lines (items, quantities, dates) for each header.
    • PS_SCHD_FOR: This table links forecasts to the Process Scheduling module, indicating which forecasts are consumed by production schedules.

These relationships form the structural backbone for forecast data integrity and navigation within the Process Manufacturing suite.