Search Results fc_fcst_dtl




Overview
Explore in AI Chat

Overview

The FC_FCST_DTL table is a core data object within the Oracle E-Business Suite (EBS) Process Manufacturing Process Planning (GMP) module. It functions as the detailed transactional repository for forecast line items. Each record in this table represents a specific item forecast for a given organization, warehouse, and time period, linked to a parent forecast header. Its primary role is to store the granular demand data used for production planning, material requirements planning (MRP), and supply chain execution within a process manufacturing environment. The integrity of this data is maintained through its foreign key relationships to master data tables for items, organizations, and warehouses.

Key Information Stored

While the full column list is not detailed in the provided metadata, the documented foreign key relationships explicitly identify several critical columns that define the table's structure and purpose. The primary key is the LINE_ID column, which uniquely identifies each forecast detail line. The FORECAST_ID column is a foreign key linking the detail line to its parent forecast definition in the FC_FCST_HDR table. Essential master data references are stored in ITEM_ID (for the forecasted item), ORGN_CODE (for the organization), and WHSE_CODE (for the warehouse). The TEXT_CODE column provides a link to descriptive text in the FC_TEXT_HDR table. Typically, this table would also contain columns for forecast quantities, dates (e.g., forecast date, bucket type), and potentially status flags.

Common Use Cases and Queries

This table is central to forecasting and planning operations. A common use case is generating reports to analyze forecasted demand by item and location. Technical consultants often query this table to troubleshoot data issues, validate forecast uploads, or support custom integrations. A typical query involves joining to its related master tables to retrieve meaningful descriptions.

Sample Query Pattern:
SELECT fcd.LINE_ID, fch.FORECAST_NAME, iim.ITEM_NO, som.ORGN_NAME, iwm.WHSE_NAME, fcd.FORECAST_QTY
FROM GMP.FC_FCST_DTL fcd,
GMP.FC_FCST_HDR fch,
INV.IC_ITEM_MST_B iim,
INV.SY_ORGN_MST som,
INV.IC_WHSE_MST iwm
WHERE fcd.FORECAST_ID = fch.FORECAST_ID
AND fcd.ITEM_ID = iim.ITEM_ID
AND fcd.ORGN_CODE = som.ORGN_CODE
AND fcd.WHSE_CODE = iwm.WHSE_CODE
AND fch.FORECAST_NAME = '<Forecast Name>';

Related Objects

The FC_FCST_DTL table has defined foreign key relationships with several key master and transactional tables, as documented in the ETRM metadata. These relationships are critical for data validation and reporting.

  • FC_FCST_HDR: Linked via FC_FCST_DTL.FORECAST_ID. This is the primary parent table containing the forecast header information.
  • FC_TEXT_HDR: Linked via FC_FCST_DTL.TEXT_CODE. Provides descriptive text for the forecast detail line.
  • IC_ITEM_MST_B and IC_ITEM_MST: Linked via FC_FCST_DTL.ITEM_ID. These tables store the master definition of the forecasted item.
  • IC_WHSE_MST: Linked via FC_FCST_DTL.WHSE_CODE. Contains the warehouse master data.
  • SY_ORGN_MST_B and SY_ORGN_MST: Linked via FC_FCST_DTL.ORGN_CODE. These tables hold the organization master data.