Results for “fm_form_eff”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

FM_FORM_EFF is the effectivity table for formulas and routings within the Oracle E-Business Suite Process Manufacturing (GMD) module, specifically the Product Development family of applications. The table records the conditions under which a given formula or routing may legitimately be used. Each row represents a single effectivity definition, binding a formula, a routing, and an owning organization to a set of qualifying attributes such as item, customer, unit of measure, and descriptive text. Because formulations and routings in process manufacturing are rarely universal, effectivity records act as the control mechanism that determines which manufacturing instructions apply in a given production context.

The object is documented as not implemented in this database, and it carries the primary key constraint FM_FORM_EFF_PK. The ETRM metadata classifies this table heuristically as satellite-leaning. In Data Vault modeling terms, this suggests treating FM_FORM_EFF as a satellite attached to one or more business hubs — most plausibly the formula and routing hubs referenced by its foreign keys — rather than as an independent hub or a pure link. Such classification is a modeling suggestion derived from the foreign key shape, not a physical constraint of the table.

Key Information Stored

The surrogate primary key is FMEFF_ID, which uniquely identifies each effectivity record and is referenced by dependent transactional and cost tables. The principal business-key and descriptive columns documented in the metadata are:

• FORMULA_ID — foreign key to FM_FORM_MST; the formula whose usage is being qualified.
• ROUTING_ID — foreign key to FM_ROUT_HDR; the routing governed by the same effectivity conditions.
• TEXT_CODE — foreign key to FM_TEXT_HDR; points to descriptive text associated with the effectivity rule.
• ITEM_ID — foreign key to IC_ITEM_MST; the item for which the formula or routing is effective.
• CUST_ID — foreign key to OP_CUST_MST; restricts effectivity to a specific customer.
• ORGN_CODE — foreign key to SY_ORGN_MST; the organization in which the effectivity applies.
• ITEM_UM — foreign key to SY_UOMS_MST; the unit of measure qualifying the item quantity.

The combination of formula, routing, item, customer, organization, and unit of measure constitutes the effective business key candidates. Because effectivity rows are subordinate to the formula and routing masters, FMEFF_ID serves as the stable surrogate while the business columns carry the qualifying semantics.

Common Use Cases and Queries

Typical usage centers on resolving which formula or routing is valid for a given production scenario, and on tracing batch and cost records back to the effectivity that authorized them.

• Retrieve all effectivity records for a formula: SELECT fmeff_id, routing_id, item_id, cust_id, orgn_code, item_um FROM fm_form_eff WHERE formula_id = :p_formula_id;
• Find the effectivity applicable to a specific item, organization, and customer: join FM_FORM_EFF to FM_FORM_MST and filter on item_id, orgn_code, and cust_id.
• Report formula-to-routing assignments by organization for production planning.
• Audit batch history: join PM_BTCH_HDR to FM_FORM_EFF on FMEFF_ID to determine which effectivity governed each batch.
• Cost analysis: join GL_ITEM_CST to FM_FORM_EFF on FMEFF_ID to tie item costs to the originating formula effectivity.

Related Objects

FM_FORM_EFF sits at the intersection of master and transactional data. The most significant related objects are:

• FM_FORM_MST — parent formula master, joined on FORMULA_ID.
• FM_ROUT_HDR — parent routing header, joined on ROUTING_ID.
• IC_ITEM_MST — item master, joined on ITEM_ID.
• OP_CUST_MST — customer master, joined on CUST_ID.
• SY_ORGN_MST — organization master, joined on ORGN_CODE.
• PM_BTCH_HDR — batch header, referencing FMEFF_ID.
• GL_ITEM_CST — item cost records, referencing FMEFF_ID.
• CM_CMPT_DTL — compliance detail, referencing FMEFF_ID.
• GMP_FORM_EFF — quality/formula effectivity table, referencing FMEFF_ID.

These relationships confirm FM_FORM_EFF as a central effectivity reference relied upon by production, costing, and quality processes across Process Manufacturing.