Results for “gmd_formula_class_b”

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

Overview

GMD.GMD_FORMULA_CLASS_B is the formula class base table within the Oracle EBS Process Manufacturing Product Development (GMD) module. Formula classes provide the classification framework by which formulas are grouped and organized in Oracle Process Manufacturing (OPM). Each row defines a distinct formula class code together with its description, and that class can then be assigned to individual formulas in the FM_FORM_MST_B master table. Formula classes are commonly used to segment formulas by product line, manufacturing process, regulatory category, or business function, enabling filtered lookups and grouped reporting across the formula population.

The table resides in the GMD schema and is documented in ETRM 12.2.2 with 10 columns. From a Data Vault modeling perspective, the heuristic classification of this object is satellite-leaning. This suggests the table is best treated as a descriptive grouping or reference dataset rather than as a transactional hub or an associative link. Modeling it as a hub with an attached satellite is a reasonable convention when the formula class is the durable business key, with descriptive attributes such as the description and text code held in the satellite.

Key Information Stored

The primary key of the table is GMD_FORMULA_CLASS_B_PK, defined on the single column FORMULA_CLASS. Because the unique index is built on FORMULA_CLASS rather than on a separately generated numeric identifier, FORMULA_CLASS functions simultaneously as the primary key and the business-key candidate. Its values are the class codes that users select when classifying formulas, and its uniqueness is enforced at the database level.

• FORMULA_CLASS — the unique class code serving as the primary key and business key.
• FORMULA_CLASS_DESC — the descriptive name or description presented to users when selecting a class.
• TEXT_CODE — the foreign key to FM_TEXT_HDR, used to retrieve associated descriptive or translated text. This is the only documented outbound foreign key from this table.
• TRANS_CNT — the transaction count or version counter maintained for concurrency and change-detection purposes.
• DELETE_MARK — the logical delete flag; classes are inactivated rather than physically removed.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — the standard Oracle EBS WHO columns capturing audit and accountability information.

Common Use Cases and Queries

The most frequent use of this table is to drive validation lists, LOVs, and joins when reporting on formulas. A typical query resolves class descriptions for formula reporting:

• SELECT f.FORMULA_NO, f.FORMULA_CLASS, c.FORMULA_CLASS_DESC FROM FM_FORM_MST_B f, GMD_FORMULA_CLASS_B c WHERE f.FORMULA_CLASS = c.FORMULA_CLASS AND c.DELETE_MARK = 0 — a standard join that adds the class description to formula listings.
• SELECT COUNT(*) FROM FM_FORM_MST_B f, GMD_FORMULA_CLASS_B c WHERE f.FORMULA_CLASS = c.FORMULA_CLASS GROUP BY c.FORMULA_CLASS — formula counts by class, used to identify under-utilized or dominant classifications.
• Filtering the FORMULA_CLASS lookup in custom extensions or validation routines that restrict the selectable classes for a given business process.
• Joining to FM_TEXT_HDR on TEXT_CODE to extract longer descriptive text or translated descriptions for documentation and label generation.

Regardless of the scenario, the DELETE_MARK column should be filtered so that only active classes appear in operational queries and user-facing lists.

Related Objects

• FM_FORM_MST_B — the primary dependent table. Its FORMULA_CLASS column references GMD_FORMULA_CLASS_B.FORMULA_CLASS, so every formula master record draws its classification from this table.
• FM_TEXT_HDR — referenced by GMD_FORMULA_CLASS_B.TEXT_CODE; supplies header-level descriptive text associated with the class.
• GMD_FORMULA_CLASS_B_PK — the unique index enforcing the primary key on FORMULA_CLASS, and the constraint that governs all referencing foreign keys.
• GMD_FORMULA_CLASS_TL — the translated-language counterpart typically present in multi-language installations, keyed on FORMULA_CLASS.
• FM_FORM_MST_TL — the translated master table whose joins to FM_FORM_MST_B ultimately depend on this classification.

Because FM_FORM_MST_B is a direct child, any maintenance of formula class values must be coordinated with existing formula assignments to avoid orphaned or invalid references.