Results for “fm_form_cls”

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

Overview

FM_FORM_CLS is a foundational reference table within the Oracle EBS Process Manufacturing Product Development module (product code GMD). Its documented purpose is to define formula classes — categorical groupings used to organize and classify formulas in process manufacturing environments. Because formulas in Oracle Process Manufacturing (OPM) are frequently numerous and span multiple product lines, plants, and regulatory contexts, formula classes provide a controlled vocabulary through which formulas can be grouped, filtered, and reported against consistently.

The relationship metadata classifies FM_FORM_CLS heuristically as hub-leaning in a Data Vault model. This is a meaningful modeling suggestion: the table holds a stable, non-transactional set of business entities (the formula classes themselves) that are referenced by downstream transactional and definitional tables. In a Data Vault design it would most naturally serve as a hub, with its descriptive attributes and text-code association modeled as satellites and its foreign-key references to header/text tables as links.

The documentation notes that the table is "Not implemented in this database," indicating that in a given installation the FM_FORM_CLS structure may exist in the data dictionary but contain no rows or may be unavailable unless the relevant OPM Product Development functionality has been configured. This is an important caveat for developers writing joins against it.

Key Information Stored

The metadata documents a deliberately narrow set of columns, centered on the primary key and one descriptive reference:

• FORMULA_CLASS — the business-key column and the sole component of the primary key FM_FORM_CLS_PK. This is the identifier by which each formula class is uniquely named and recognized across the application. It is also the column referenced by all child tables, making it the principal join key.
• TEXT_CODE — a foreign key to FM_TEXT_HDR. This links the formula-class record to a text header, which supplies multilingual or descriptive text associated with the class. It is the mechanism by which the class carries human-readable descriptions rather than only a short code.

No additional columns are documented in the supplied metadata. The surrogate-versus-business-key distinction here is essentially collapsed: FORMULA_CLASS functions as both the primary key and the natural business identifier, since FM_FORM_CLS_PK is defined on that single column. There is no separate system-generated surrogate column documented. Consumers should therefore treat FORMULA_CLASS as a stable, human-meaningful value rather than an artificial sequence.

Common Use Cases and Queries

The most frequent use of FM_FORM_CLS is as a lookup in formula reporting and validation. Typical patterns include:

• Validating that a formula's assigned class exists before insert/update, protecting the FK from FM_FORM_MST.FORMULA_CLASS.
• Producing class-based formula inventories, such as listing all active formulas grouped by formula class for a plant.
• Resolving descriptive text by joining through TEXT_CODE to FM_TEXT_HDR to display the class description in a report or LOV.
• Feeding downstream conversions that populate LM_FORM_MST in laboratory or LIMS contexts, where the class must be carried across.

A representative join pattern resolves the class description:

SELECT f.FORMULA_CLASS, t.TEXT_DESCRIPTION
FROM   FM_FORM_CLS f,
       FM_TEXT_HDR t
WHERE  f.TEXT_CODE = t.TEXT_CODE;

A formula-count-by-class report would join to the master formula table:

SELECT m.FORMULA_CLASS, COUNT(*) FORMULA_CNT
FROM   FM_FORM_MST m, FM_FORM_CLS c
WHERE  m.FORMULA_CLASS = c.FORMULA_CLASS
GROUP  BY m.FORMULA_CLASS;

Because the table is documented as not implemented in some databases, defensive coding — checking for existence or guarding with outer joins — is advisable in integrations.

Related Objects

FM_FORM_CLS participates in a small, well-defined relationship set:

• FM_TEXT_HDR — referenced by FM_FORM_CLS.TEXT_CODE; supplies descriptive text for each class.
• FM_FORM_MST — references FM_FORM_CLS via FM_FORM_MST.FORMULA_CLASS; the master formula table, whose formulas are grouped by class.
• LM_FORM_MST — references FM_FORM_CLS via LM_FORM_MST.FORMULA_CLASS; the laboratory formula master that mirrors the same classification.

These three relationships define the object's role: a lightweight hub of class codes consumed by the two principal formula master tables and enriched through a text header. Any query that reports formulas by class, or validates class assignments during formula creation, will traverse FM_FORM_CLS as the central reference point.