Search Results fc_text_hdr




Overview
Explore in AI Chat

Overview

The FC_TEXT_HDR table is a core reference data object within the Oracle E-Business Suite (EBS) Process Manufacturing Process Planning (GMP) module. It functions as a master repository for defining and storing distinct text types used specifically within the Forecasting functionality. This table provides a centralized, controlled mechanism for categorizing and managing descriptive text annotations associated with forecast headers, forecast details, and schedule forecasts. Its existence ensures data integrity and consistency across the forecasting process by standardizing the types of textual information that can be attached to key planning entities.

Key Information Stored

The primary data element stored in the FC_TEXT_HDR table is the text type code. The table's structure is defined by its primary key, TEXT_CODE, which uniquely identifies each valid text classification within the forecasting context. While the provided ETRM metadata does not list all column details, the primary key and foreign key relationships indicate that TEXT_CODE is the critical identifier. This code is referenced by other transactional tables to link specific forecast records to a particular category of descriptive text. The table likely contains additional descriptive columns, such as a name or description for the text type, to make the codes meaningful to end-users within the application interface.

Common Use Cases and Queries

The primary use case for the FC_TEXT_HDR table is to support the management and reporting of forecast-related notes and comments. For instance, a planner may attach internal notes, customer instructions, or planning assumptions to a forecast. The FC_TEXT_HDR table defines what these note types are (e.g., 'CUSTOMER_INSTRUCTION', 'PLANNING_NOTE'). A common reporting query would join this table to forecast transaction tables to retrieve all forecasts annotated with a specific type of text. A typical SQL pattern involves selecting forecast details filtered by a particular TEXT_CODE.

SELECT fh.forecast_number, fd.*, th.text_code
FROM gmp.fc_fcst_hdr fh,
     gmp.fc_fcst_dtl fd,
     gmp.fc_text_hdr th
WHERE fh.forecast_id = fd.forecast_id
  AND fd.text_code = th.text_code
  AND th.text_code = '&TEXT_TYPE';

Related Objects

The FC_TEXT_HDR table maintains critical referential integrity with several key transactional tables in the GMP module, as documented by its foreign key relationships. These relationships demonstrate where the defined text types are applied:

  • FC_FCST_HDR: The TEXT_CODE column in the forecast header table references FC_TEXT_HDR, allowing text categorization at the overall forecast level.
  • FC_FCST_DTL: The TEXT_CODE column in the forecast detail table references FC_TEXT_HDR, enabling text annotations on individual forecast lines.
  • PS_SCHD_FOR: The TEXT_CODE column in the schedule forecast table references FC_TEXT_HDR, linking text types to scheduled forecast entries.

All relationships are enforced through the primary key of FC_TEXT_HDR (TEXT_CODE), ensuring that any text code used in these transactional tables is a valid, pre-defined type.