Results for “gmp_parameter_values_tl”

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

Overview

GMP_PARAMETER_VALUES_TL is the translation table for process parameter values within the Oracle EBS Process Manufacturing Process Planning module (product code GMP). It stores language-specific, user-facing text for the values that a process parameter may assume, allowing the same underlying parameter value definition to be presented in multiple installed languages. The table resides in the GMP schema and carries a VALID status in the ETRM 12.2.2 data dictionary.

The object follows the standard Oracle EBS multilingual (MLS) design pattern, in which a base table (GMP_PARAMETER_VALUES_B) holds language-independent attributes and a companion "_TL" table holds translatable descriptive columns keyed by language. The documented foreign key from GMP_PARAMETER_VALUES_TL.PARAMETER_ID (and PARAMETER_VALUE) back to GMP_PARAMETER_VALUES_B confirms this parent-child arrangement.

Under a heuristic Data Vault classification mined from the foreign-key structure, this table is assessed as satellite-leaning. In modeling terms, the combination of PARAMETER_ID and PARAMETER_VALUE behaves as the business key that would resolve to a hub or link, while the translation attributes (language-dependent descriptions) form the satellite payload. This classification is a modeling suggestion only; the physical implementation remains a conventional EBS relational table.

Key Information Stored

The table is documented with 10 columns. Its primary key, GMP_PARAM_VALUES_TL_PK, is a composite business-key candidate defined on PARAMETER_ID, PARAMETER_VALUE, and LANGUAGE. Because the key comprises descriptive identifiers plus language rather than a single synthetic column, the "primary key" here is effectively the business key, with no separate surrogate key documented.

• PARAMETER_ID — identifier of the process parameter to which the value belongs; part of the primary key and a foreign key to GMP_PARAMETER_VALUES_B.
• PARAMETER_VALUE — the coded value definition for the parameter; part of the primary key and the second component of the foreign key to the base table.
• PARAMETER_VALUE_DESCRIPTION — the translatable descriptive text displayed for the parameter value in the given language.
• LANGUAGE — the language code of the translated row; part of the primary key and the column that distinguishes otherwise identical parameter/value pairs.
• SOURCE_LANG — the language from which the row was originally entered or derived, used by the MLS framework to track translation provenance.
• CREATION_DATE, CREATED_BY — audit columns capturing when and by whom the translation row was created.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — audit columns capturing the most recent modification, the responsible user, and the login session.

Common Use Cases and Queries

Typical usage centers on multilingual reporting and validation of translated parameter values. A frequent pattern joins the translation table to the base table and filters by language to retrieve the correct display text:

• Retrieve translated descriptions for a parameter in a specific language, joining PARAMETER_ID and PARAMETER_VALUE to GMP_PARAMETER_VALUES_B and constraining LANGUAGE to the session or requested locale.
• Identify values that lack a translation in a target language by comparing the language set present per (PARAMETER_ID, PARAMETER_VALUE) against the expected installed languages and the SOURCE_LANG value.
• Audit translation freshness using LAST_UPDATE_DATE and LAST_UPDATED_BY to report recently changed parameter value text.
• Populate downstream reports or interfaces that require localized process parameter terminology for planning documents.

Because the table is an MLS companion, queries must always include a LANGUAGE predicate; omitting it returns multiple rows per value and can distort reporting totals.

Related Objects

The most significant related objects are those directly connected through the documented foreign-key and translation relationships:

• GMP_PARAMETER_VALUES_B — the base table; joined on PARAMETER_ID and PARAMETER_VALUE, and the referenced parent of the sole documented foreign key.
• GMP_PARAMETERS_B and GMP_PARAMETERS_TL — the parameter definition tables that own PARAMETER_ID values referenced by the base table and, indirectly, by these translations.
• GMP_PARAMETER_VALUES_VL — the customary MLS view that unions or resolves base and translation rows, presenting a single localized row per parameter value for application and reporting layers.
• GMP_PARAM_VALUES_TL_PK — the unique index enforcing uniqueness of PARAMETER_ID, PARAMETER_VALUE, and LANGUAGE.
• Process planning and recipe screens/APIs in the GMP module — consumers that resolve parameter value descriptions for display and validation during plan and recipe execution.

Oracle Proprietary, Confidential Information — Legal Notices apply.