Search Results gmd_test_methods_tl_pk

Overview

GMD_TEST_METHODS_TL is the translation (TL) table for OPM Quality test methods within the Oracle Process Manufacturing (OPM) Product Development module. In Oracle EBS 12.1.1 and 12.2.2, the GMD schema stores quality management master data, and the GMD_TEST_METHODS_TL object holds the language-dependent descriptive attributes of each test method defined in the base GMD_TEST_METHODS_B table. A test method defines the analytical procedure or specification used to inspect raw materials, intermediates, and finished products, making this table central to quality specification and laboratory workflow configuration.

Because it is a TL table, it follows the standard Oracle multi-language design pattern: each row represents one test method for one installed language. The heuristic Data Vault classification mined from the FK structure is standalone. As a modeling suggestion, this indicates that GMD_TEST_METHODS_TL has no dependent child foreign keys and principally carries descriptive, context-dependent attributes keyed to its parent entity — behavior consistent with a satellite-like structure rather than a hub or link. The actual referential relationship to the base table is enforced by application logic and the shared surrogate key rather than a documented FK in the ETRM extract.

Key Information Stored

The documented physical schema contains ten columns. The most significant are listed below.

• TEST_METHOD_ID — Surrogate identifier of the test method. This is the foreign-key join column back to the base test methods table and forms part of the primary key.
• LANGUAGE — The language code for the translated row. Together with TEST_METHOD_ID it forms the composite primary key GMD_TEST_METHODS_TL_PK.
• TEST_METHOD_DESC — The translated description of the test method; the primary user-facing attribute in this table.
• SOURCE_LANG — The language from which the translated description was derived, used by the translation framework to identify the source row.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard Oracle Who columns capturing audit and concurrency metadata for each row.
• ZD_EDITION_NAME — Editioning column used in 12.2.2 by the E-Business Suite online patching (adop) framework to isolate edition-specific data.

The surrogate primary key is TEST_METHOD_ID plus LANGUAGE. The documented unique index GMD_TEST_METHODS_TL_PK is additionally expanded to include ZD_EDITION_NAME, reflecting the 12.2.2 editioning model. TEST_METHOD_ID and LANGUAGE are the effective business-key candidates, since together they uniquely identify a translated description for a given test method and locale.

Common Use Cases and Queries

Typical queries retrieve the localized description of a test method for reporting, specification printing, or laboratory integration. A standard pattern joins the TL table to its base parent and filters on the session or reporting language.

• Language-specific lookup: SELECT TEST_METHOD_ID, TEST_METHOD_DESC FROM GMD_TEST_METHODS_TL WHERE LANGUAGE = USERENV('LANG').
• Fallback to source language: join to GMD_TEST_METHODS_B and use NVL or COALESCE to substitute SOURCE_LANG descriptions when a translation is missing.
• Quality specification reporting: expose translated test method descriptions alongside specification limits in quality results reports.
• Translation completeness audit: compare counts per LANGUAGE to identify test methods lacking translations.
• Change tracking: query LAST_UPDATE_DATE and LAST_UPDATED_BY to report recent maintenance of test method descriptions.

Because 12.2.2 uses editioning, queries should generally rely on the editioning views rather than the base table directly, which transparently resolve ZD_EDITION_NAME for the active edition.

Related Objects

The following objects are most significant in relation to GMD_TEST_METHODS_TL.

• GMD_TEST_METHODS_B — The base (non-translated) test methods table, joined on TEST_METHOD_ID; it holds language-independent attributes.
• GMD_TEST_METHODS_VL — The translated view that presents base and TL columns together and is the recommended query entry point for multilingual access.
• GMD_TEST_METHODS_TL_PK — The primary key index enforcing uniqueness of TEST_METHOD_ID, LANGUAGE, and ZD_EDITION_NAME.
• GMD_SPEC_TESTS — Quality specifications that reference test methods; joins flow through TEST_METHOD_ID.
• GMD_QM_RESULTS — Quality results records that capture the outcome of executing a test method, linked indirectly through the specification test relationship.
• GMD_TEST_METHOD_TL API / DML — Translation maintenance is typically performed through the OPM Quality setup forms and their underlying PL/SQL DML, which manage the TL rows.

These objects collectively support test method definition, localization, specification assignment, and quality results capture across OPM Product Development.