Search Results gl_item_cst

Overview

The FM_FORM_EFF table is a core data object within the Process Manufacturing Product Development (GMD) module of Oracle E-Business Suite (EBS). It defines the effectivity rules, or the specific conditions, under which a given formula or routing can be selected and used for manufacturing. This table is critical for enforcing business rules that dictate which production instructions are valid based on criteria such as customer, organization, item, and date ranges. By storing these conditional parameters, the system ensures that batch production is initiated only with the appropriate, authorized formula and routing combinations, maintaining compliance and operational integrity.

Key Information Stored

The table's primary purpose is to link a formula or routing to its applicable effectivity conditions. Its structure, as indicated by the foreign key relationships, points to the key data elements it stores. The central columns are FORMULA_ID and ROUTING_ID, which reference the master formula (FM_FORM_MST) and routing (FM_ROUT_HDR) respectively. The effectivity conditions are defined through columns like ITEM_ID (specific finished good), CUST_ID (customer), and ORGN_CODE (organization). The FMEFF_ID column serves as the unique primary key for each effectivity record. Additional columns such as TEXT_CODE (for reference notes) and ITEM_UM (unit of measure) provide further qualifying information for the effectivity rule.

Common Use Cases and Queries

A primary use case is the validation and automatic selection of a formula during batch creation. The system queries FM_FORM_EFF to find a formula whose effectivity rules match the batch's attributes, such as the item being produced, the manufacturing organization, and the requested date. For reporting and analysis, queries often join this table to master data to audit effectivity coverage or identify gaps. A typical query pattern might involve joining to FM_FORM_MST and IC_ITEM_MST to list all formulas eligible for a specific item.

SELECT ffm.formula_no, ffm.formula_vers, iim.item_no
FROM fm_form_eff ffe,
     fm_form_mst ffm,
     ic_item_mst iim
WHERE ffe.formula_id = ffm.formula_id
  AND ffe.item_id = iim.item_id
  AND iim.item_no = 'FINISHED_GOOD_123'
  AND SYSDATE BETWEEN ffe.start_date AND NVL(ffe.end_date, SYSDATE);

Related Objects

FM_FORM_EFF sits at the center of a network of related objects. It is a child of master data tables, including FM_FORM_MST, FM_ROUT_HDR, IC_ITEM_MST, OP_CUST_MST, and SY_ORGN_MST. Crucially, it is a parent table to several key transactional and costing entities. The FMEFF_ID primary key is referenced by tables such as PM_BTCH_HDR (linking a batch to its effectivity rule), GL_ITEM_CST (item costs), and CM_CMPT_DTL (component details). The existence of a table named GMP_FORM_EFF also referencing it suggests integration with the Process Manufacturing Process Execution (GMP) module, further extending its role into production execution.