Search Results fmconf_id

Overview

The FM_CONF_TBL is a core configuration table within the Oracle E-Business Suite Process Manufacturing (GMD) module, specifically for Product Development. Its primary function is to govern the creation and management of formula effectivities. In Process Manufacturing, a formula defines the materials and process steps to produce a product. Effectivity determines the validity of a specific formula version based on criteria like dates, quantities, or organizational assignments. This table stores the master configuration rules that control how these effectivity records are automatically generated and structured within the system, serving as a critical control point for formula lifecycle management.

Key Information Stored

The table's structure centers on a unique configuration identifier and organizational context. The primary column is FMCONF_ID, which serves as the system-generated unique key for each configuration record. The ORGN_CODE column ties the configuration to a specific organization, enforcing that effectivity rules are defined within the correct operational context. The FORMULA_USE column likely specifies the intended application of the formula (e.g., production, costing, planning), which influences the effectivity rules applied. The table also includes a TEXT_CODE column, which is a foreign key linking to the FM_TEXT_HDR table, suggesting the configuration may be associated with descriptive or instructional text.

Common Use Cases and Queries

This table is typically referenced during the setup and maintenance of Process Manufacturing and during formula creation or revision. A common administrative query retrieves all configuration rules for a specific organization to verify setup. For example: SELECT * FROM GMD.FM_CONF_TBL WHERE ORGN_CODE = :org_code;. When troubleshooting formula effectivity issues, such as missing or incorrect effective dates, support personnel may join this table to formula headers to validate the governing configuration. Reporting use cases are generally limited to configuration audits. Developers may query this table via APIs within custom integrations that create formulas to ensure the correct effectivity rules are applied programmatically.

Related Objects

FM_CONF_TBL has defined relationships with several key tables, primarily through foreign key constraints. Its primary key (FMCONF_ID) is referenced by other tables to associate data with a specific effectivity configuration. The documented foreign keys show it draws reference data from organizational and text entities:

• FM_TEXT_HDR: Joined via FM_CONF_TBL.TEXT_CODE = FM_TEXT_HDR.TEXT_CODE. This links configuration to descriptive text.
• SY_ORGN_MST_B and SY_ORGN_MST: Both joined via FM_CONF_TBL.ORGN_CODE. These tables validate the organization code against the master list of inventory organizations.

While not listed in the provided metadata, it is highly probable that core formula tables (e.g., FM_FORM_MST_B, FM_EFF_CTRL_B) have foreign key relationships referencing FMCONF_ID from FM_CONF_TBL to enforce the configured effectivity rules.