Search Results gmp_parameter_values_tl




Overview
Explore in AI Chat

Overview

The GMP_PARAMETER_VALUES_TL table is a translation table within the Oracle E-Business Suite Process Manufacturing (GMP) module. Specifically, it supports the Process Planning sub-module in both releases 12.1.1 and 12.2.2. Its primary role is to store translated descriptions for process parameter values, enabling the application to present user-facing text in multiple languages. This table is a critical component for the internationalization (i18n) of the manufacturing process definitions, ensuring that parameter value descriptions are displayed correctly based on a user's session language. It operates in conjunction with its base table, GMP_PARAMETER_VALUES_B, which holds the core, language-independent data.

Key Information Stored

The table stores multilingual descriptions for specific values assigned to process parameters. Its structure is defined by a composite primary key that uniquely identifies each translation row. The most significant columns include:

  • PARAMETER_ID: A foreign key linking the translation to a specific process parameter defined in the base table (GMP_PARAMETER_VALUES_B).
  • PARAMETER_VALUE: The specific code or value for the parameter, forming part of the key with PARAMETER_ID.
  • LANGUAGE: The language code (e.g., 'US' for American English) for the translated text, completing the primary key.
  • DESCRIPTION (implied by translation table convention): While not explicitly listed in the provided metadata, translation tables in Oracle EBS universally contain a DESCRIPTION or similar column to hold the actual translated text. This is the user-friendly name for the parameter value in the specified language.

Common Use Cases and Queries

The primary use case is retrieving a parameter value's description in the user's current session language for display in forms, reports, and UIs within Process Planning. A typical query joins the translation table to its base table using the LANGUAGE column filtered by the user's session context. For example, to fetch all translated values for a specific parameter, one might use:

SELECT pvb.PARAMETER_ID, pvb.PARAMETER_VALUE, pvtl.DESCRIPTION
FROM GMP_PARAMETER_VALUES_B pvb,
GMP_PARAMETER_VALUES_TL pvtl
WHERE pvb.PARAMETER_ID = pvtl.PARAMETER_ID
AND pvb.PARAMETER_VALUE = pvtl.PARAMETER_VALUE
AND pvtl.LANGUAGE = USERENV('LANG')
AND pvb.PARAMETER_ID = :specific_parameter_id;

This table is also essential for generating multilingual process documentation, quality reports, and batch records where parameter specifications must be presented in a locale-specific manner.

Related Objects

The table has a direct and fundamental relationship with its base table, as documented in the provided metadata. The key related object is:

  • GMP_PARAMETER_VALUES_B: This is the base ("_B") table that stores the core, language-insensitive data for process parameter values. The foreign key relationship is defined on the composite columns (PARAMETER_ID, PARAMETER_VALUE). Every record in GMP_PARAMETER_VALUES_TL must correspond to a valid record in GMP_PARAMETER_VALUES_B. The translation table does not store standalone data; it exists solely to provide multilingual descriptions for the entities defined in the base table.