Results for “gmd_operation_class_b”

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

Overview

GMD_OPERATION_CLASS_B is the operation class base table in the Oracle EBS Process Manufacturing Product Development (GMD) module. It defines the master list of operation classes, which are logical groupings used to categorize routing operations in process manufacturing. Operation classes allow production engineers and planners to classify operations by process function — for example, mixing, reaction, filling, or packaging — so that similar operations can be reported on, reused, and selected consistently across routings, recipes, and production batches.

The table resides in the GMD schema and is present in both Oracle EBS 12.1.1 and 12.2.2. Because it holds descriptive attributes attached to a business entity (an operation class) rather than defining relationships between two or more hubs, the heuristic Data Vault classification of this object is satellite-leaning. In a dimensional or Data Vault model, it would typically be treated as a satellite supplying descriptive context to an operation-class key, rather than as a hub or a link.

Key Information Stored

The table is documented with 10 columns. The most significant are:

• OPRN_CLASS — The operation class identifier and the single column of the primary key GMD_OPERATION_CLASS_B_PK. This is the business key exposed to users and referenced by dependent tables.
• OPRN_CLASS_DESC — The descriptive name of the operation class, used in list of values and reports.
• TEXT_CODE — A foreign key to FM_TEXT_HDR, linking the operation class to extended descriptive text maintained in the common text framework.
• TRANS_CNT — A transaction count column used by Oracle's concurrency and record-versioning conventions to detect stale updates.
• DELETE_MARK — The soft-delete flag. Records are logically deleted rather than physically removed, so all queries should filter on this column.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — The standard Oracle EBS audit columns capturing who created and last modified the row, and from which login session.

The primary key is the surrogate-style unique index on OPRN_CLASS, which is also the sole documented business-key candidate. There is no separate meaningless surrogate key; the operation class code itself carries the identity.

Common Use Cases and Queries

Typical uses include validating operation class values in routing and recipe setup, populating list-of-values queries in process manufacturing forms, and supplying the grouping dimension in production reporting. A standard active-record lookup is:

• SELECT oprn_class, oprn_class_desc FROM gmd.gmd_operation_class_b WHERE delete_mark = 0 ORDER BY oprn_class;

To resolve extended text, join to the text header table:

• SELECT b.oprn_class, b.oprn_class_desc, t.text FROM gmd.gmd_operation_class_b b, fm_text_hdr t WHERE b.text_code = t.text_code AND b.delete_mark = 0;

Reporting queries frequently aggregate operation counts per class by joining to the operation and routing tables, and audit queries use LAST_UPDATE_DATE and LAST_UPDATED_BY to track configuration changes for SOX or change-control purposes.

Related Objects

The documented foreign key relationship links this table to the text framework:

• FM_TEXT_HDR — joined on GMD_OPERATION_CLASS_B.TEXT_CODE = FM_TEXT_HDR.TEXT_CODE; supplies long description text.

In practice, the operation class key is referenced by the operation definition tables in the GMD module (such as the operation master and routing operation tables), which carry OPRN_CLASS as a grouping attribute. Operation class values surface through the Process Manufacturing setup forms and their associated list-of-values views, and are consumed by production reporting and recipe/routing inquiry screens. Because the documented metadata identifies only the FM_TEXT_HDR relationship, DBAs should confirm additional referencing tables via the ALL_CONSTRAINTS and ALL_CONS_COLUMNS dictionary views on the target instance before building dependent extracts.