Results for “formula_class_desc”

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

Overview

GMD_FORMULA_CLASS_VL is an APPS-owned, VALID database view in the Oracle E-Business Suite Process Manufacturing (GMD) module, specifically within Process Manufacturing Product Development. The view presents Formula Class information in a language-specific, multi-lingual (MLS) format. It is the "_VL" (translated) companion view that joins the base table holding the operational formula class data with the translation table that stores the user-facing description in each installed language. As such, it exposes the descriptive Formula Class text appropriate to the session's current language rather than the raw, non-translated attributes stored in the base table.

In Oracle EBS reporting and integration, this view functions as the standard read-only interface for retrieving formula class definitions. Because it resolves the language at query time via USERENV('LANG'), downstream reports, concurrent programs, and interfaces that reference GMD_FORMULA_CLASS_VL automatically return descriptions in the user's active language without requiring explicit language joins. The underlying object is a view, not a table, so it carries no independent data and inherits transaction semantics from its base objects. A user querying the object by the term "formula_class_desc" is typically looking for the translated formula class description column exposed by this view.

Underlying Base Objects

The view is defined over two synonym-referenced base tables within the same schema context: GMD_FORMULA_CLASS_B and GMD_FORMULA_CLASS_TL. GMD_FORMULA_CLASS_B is the base (operational) table that stores the actual formula class records, including identifiers, transaction control columns, and audit information. GMD_FORMULA_CLASS_TL is the translation table that stores language-specific descriptive text keyed to the same formula class identifier and the language code.

The join between the two is performed on FORMULA_CLASS in both tables, constrained additionally by the language condition A.LANGUAGE = USERENV('LANG'). This means the "_B" table supplies the technical and transactional attributes while the "_TL" table contributes the translated FORMULA_CLASS_DESC. The relationship is therefore a one-to-one (per language) association, and rows appear only where a matching translation exists for the session's current language. The view text selects from the two tables with an inner join via the WHERE clause.

Key Columns

The view exposes the following columns derived from the documented view text:

• ROW_ID — The ROWID of the base table (GMD_FORMULA_CLASS_B) row, used as an addressable row identifier.
• FORMULA_CLASS — The unique identifier/code for the formula class; the join key between the base and translation tables.
• FORMULA_CLASS_DESC — The translated description of the formula class, sourced from GMD_FORMULA_CLASS_TL in the session language. This is the column most commonly sought when users search for "formula_class_desc".
• TRANS_CNT — A transaction count column, typically used for internal concurrency/change tracking.
• DELETE_MARK — A logical delete flag indicating whether the record is active or marked for deletion.
• TEXT_CODE — A reference code associated with the translatable text.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, LAST_UPDATE_DATE — Standard EBS WHO (audit) columns capturing creation and last-update metadata.

The translated description is the principal consumer-facing attribute, whereas the remaining columns are technical, audit, or control fields inherited from the base table.

Common Use Cases and Queries

Typical use cases include displaying valid formula classes with their translated descriptions in custom reports, populating value lists, validating imported formula class codes, and joining formula class descriptions to formula records. The view is well suited to integration and reporting because it abstracts the MLS join away from the consuming query.

A representative query retrieving all visible formula classes with their descriptions is:

• SELECT FORMULA_CLASS, FORMULA_CLASS_DESC FROM APPS.GMD_FORMULA_CLASS_VL WHERE DELETE_MARK = 0 ORDER BY FORMULA_CLASS;
• SELECT FORMULA_CLASS_DESC FROM APPS.GMD_FORMULA_CLASS_VL WHERE FORMULA_CLASS = :p_formula_class;
• Lookup of a specific description to resolve a code used elsewhere, e.g. joining GMD_FORMULA_CLASS_VL.FORMULA_CLASS to a formula table for descriptive reporting.

Because language resolution depends on USERENV('LANG'), results are session-language dependent; consumers requiring a deterministic language should account for this behavior, or query the translation table directly with an explicit LANGUAGE predicate. Filters on DELETE_MARK should be applied where only active records are desired. The view must also be accessed with APPS privileges or appropriate synonyms/grants in custom code.