Search Results gmp_process_parameters_tl




Overview
Explore in AI Chat

Overview

The GMP_PROCESS_PARAMETERS_TL table is a core data object within the Oracle E-Business Suite (EBS) Process Manufacturing Process Planning (GMP) module. As indicated by the "TL" suffix, this is a Translation Table, specifically designed to store multilingual support (MLS) data. Its primary role is to hold language-specific textual descriptions for process parameters defined in the system. This table enables the EBS application to display parameter names and descriptions in a user's preferred language, a critical feature for global deployments. It operates in conjunction with its base table, GMP_PROCESS_PARAMETERS_B, which stores the language-independent, transactional data for process parameters.

Key Information Stored

The table's structure is characteristic of Oracle EBS translation tables. The most critical columns, as defined by its primary key (GMP_PROCESS_PARAM_TL_PK), are PARAMETER_ID and LANGUAGE. The PARAMETER_ID is a foreign key that links each translated row to its corresponding master record in the GMP_PROCESS_PARAMETERS_B table. The LANGUAGE column stores the language code (e.g., 'US' for American English, 'KO' for Korean) for the translation. Beyond these key columns, the table typically contains at least one descriptive field, such as PARAMETER_DESC or PARAMETER_NAME, which holds the translated text. Other standard columns common to EBS translation tables, like SOURCE_LANG, CREATION_DATE, and LAST_UPDATE_DATE, are also present to manage data integrity and audit trails.

Common Use Cases and Queries

The primary use case is retrieving process parameter descriptions for a user session's current language, which is fundamental to all user interfaces and reports within the Process Planning module. A common SQL pattern involves joining the TL table with its base table while filtering on the desired language. For example, to fetch all parameter descriptions in American English for a specific process, a query would resemble:

  • SELECT b.parameter_code, tl.parameter_description
  • FROM gmp_process_parameters_b b,
  • gmp_process_parameters_tl tl
  • WHERE b.parameter_id = tl.parameter_id
  • AND tl.language = USERENV('LANG')
  • AND b.process_id = :p_process_id;

Reporting use cases include generating multi-language process documentation and validating translation completeness across installed languages. Data fixes often target this table to correct or populate missing translations for key parameters.

Related Objects

This table has a direct and essential relationship with its base table, GMP_PROCESS_PARAMETERS_B, as enforced by the documented foreign key constraint. The TL table is wholly dependent on the B table for its existence; each PARAMETER_ID in the TL table must have a corresponding record in the B table. In application logic, this table is accessed via views or APIs that abstract the language selection logic, such as seeded views that automatically filter on the session language. While not explicitly listed in the provided metadata, it is common for key Process Planning forms, such as those defining process operations and parameters, to rely on this table to display translated descriptions to the end-user.