Search Results gmp_form_eff




Overview
Explore in AI Chat

Overview

The GMP_FORM_EFF table is a core data object within the Oracle E-Business Suite (EBS) Process Manufacturing (GMP) module, specifically for Process Planning. It functions as the Formula Effectivity Mapping Table. Its primary role is to establish and maintain the relationships between a manufacturing formula, its associated routing, and the specific organizational and inventory contexts where that formula-routing combination is valid and effective. This mapping is essential for defining which production instructions (formula and routing) apply to a given item within a specific plant, warehouse, and date range, enabling precise control over manufacturing processes.

Key Information Stored

The table stores mapping records that link key manufacturing entities. While the full column list is not detailed in the provided metadata, the foreign key relationships explicitly identify the critical columns. The primary identifier is the APS_FMEFF_ID column, which constitutes the primary key (GMP_FORM_EFF_PK). Each record centrally stores a FORMULA_ID, linking to the master formula definition, and a ROUTING_ID, linking to the process routing. The organizational context is defined by the PLANT_CODE (organization) and WHSE_CODE (warehouse). The table's description as an "Effectivity" table implies it likely contains additional columns for managing effective date ranges (e.g., EFFECTIVE_FROM_DATE, EFFECTIVE_TO_DATE), status, and control attributes to govern the active period of the mapping.

Common Use Cases and Queries

A primary use case is validating and retrieving the active formula and routing for a production batch based on the item, plant, and warehouse. Planners use this data to ensure the correct manufacturing instructions are selected. For reporting, it is central to queries analyzing formula coverage and routing assignments across the enterprise. A typical SQL pattern involves joining to master tables to get descriptive information.

SELECT gfe.formula_id, fm.formula_no, gfe.routing_id, gr.routing_no,
       gfe.plant_code, org.organization_name, gfe.whse_code
FROM gmp.gmp_form_eff gfe
JOIN fm_form_mst fm ON gfe.formula_id = fm.formula_id
JOIN gmd_routings_b gr ON gfe.routing_id = gr.routing_id
JOIN sy_orgn_mst org ON gfe.plant_code = org.organization_code
WHERE SYSDATE BETWEEN gfe.effective_from_date AND NVL(gfe.effective_to_date, SYSDATE)
  AND gfe.plant_code = 'M1';

Related Objects

The GMP_FORM_EFF table is a central hub with documented foreign key relationships to several critical master and transaction tables:

  • FM_FORM_MST: Links via FORMULA_ID to the master formula definition.
  • GMD_ROUTINGS_B and FM_ROUT_HDR: Both link via ROUTING_ID to routing definitions, indicating potential integration points between different schema representations of routings.
  • SY_ORGN_MST_B and SY_ORGN_MST: Link via PLANT_CODE to organization master data.
  • IC_WHSE_MST: Links via WHSE_CODE to the warehouse master table.
  • FM_FORM_EFF: Links via FMEFF_ID, suggesting a relationship with another effectivity structure within the formula module.