Search Results gmd_test_classes_tl_pk

Overview

GMD.GMD_TEST_CLASSES_TL is the translation table for OPM Quality test classes within the Oracle E-Business Suite Process Manufacturing Product Development module (GMD). In Oracle EBS, entities that require multilingual descriptions are split into a base table and a companion _TL table. The base table GMD_TEST_CLASSES_B stores language-independent attributes (the test class code and operational flags), while GMD_TEST_CLASSES_TL stores the translatable descriptive text associated with each test class per installed language. This separation allows a single test class definition to carry distinct descriptions in every enabled language without duplicating the core record.

The ETRM documentation classifies this object as standalone under a heuristic Data Vault analysis. In Data Vault modeling terms, this suggests the table behaves most like a satellite attached to the test class business key: it holds descriptive, language-dependent context keyed by the natural business key (TEST_CLASS) plus LANGUAGE, rather than acting as a hub or a link. Analysts designing a vault layer should treat GMD_TEST_CLASSES_TL as a descriptive satellite rather than a relationship-bearing structure.

Key Information Stored

The table's documented physical schema contains nine columns. The most significant are:

• TEST_CLASS — The business identifier of the quality test class. Together with LANGUAGE it forms the composite primary key GMD_TEST_CLASSES_TL_PK, which is also the sole documented unique index and therefore the business-key candidate. It joins back to the base table's TEST_CLASS.
• LANGUAGE — The language code identifying which translation row applies. It is the second component of the composite primary key and the discriminator that makes this a translation table.
• TEST_CLASS_DESC — The translated description of the test class. This is the principal payload column and the reason the table exists.
• SOURCE_LANG — The language of the source record from which the translation was derived, used by the multi-language support (MLS) framework to track translation provenance.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — The standard Oracle EBS audit columns. These record who created and last modified each translation row and when, supporting audit trails and concurrent-program change tracking.

No surrogate system-generated primary key column is documented; the primary key is the composite natural key of TEST_CLASS and LANGUAGE.

Common Use Cases and Queries

Typical usage involves retrieving the localized description for a test class in a user's session language, or reporting test classes with their translations. A standard MLS-enabled query joins the base and translation tables and filters by language:

SELECT b.test_class, t.test_class_desc, t.language
FROM gmd_test_classes_b b, gmd_test_classes_tl t
WHERE b.test_class = t.test_class
AND t.language = USERENV('LANG');

Reporting scenarios include generating lists of quality test classes for documentation, validating that every test class has a translation in all enabled languages, and auditing when translations were last maintained. A completeness check can be expressed as:

SELECT b.test_class
FROM gmd_test_classes_b b
WHERE NOT EXISTS (SELECT 1 FROM gmd_test_classes_tl t
WHERE t.test_class = b.test_class AND t.language = 'US');

Because the table is maintained by the MLS framework, direct DML should generally be avoided in favor of the application's test class maintenance forms and concurrent programs.

Related Objects

The most significant objects related to this table are:

• GMD_TEST_CLASSES_B — The base (non-translated) table holding language-independent test class attributes. Join on TEST_CLASS.
• GMD_TEST_CLASSES_TL_PK — The composite primary key/unique index on (TEST_CLASS, LANGUAGE) that enforces one translation per class per language.
• OPM Quality test definition tables (such as GMD_TESTS_B and related test-class assignment objects) that reference test classes by TEST_CLASS and surface the translated description.
• The FND multi-language support views and the standard who-columns audit infrastructure that populate SOURCE_LANG and the audit columns.
• Process Manufacturing Product Development test class maintenance forms and APIs that write through to both the base and translation tables.

Because the ETRM classification is standalone, the table has no documented foreign-key dependents of its own; its principal relationship is upward to GMD_TEST_CLASSES_B via TEST_CLASS.