Search Results gmp_process_parameter_set_tl




Overview
Explore in AI Chat

Overview

The GMP_PROCESS_PARAMETER_SET_TL table is a core data object within the Oracle E-Business Suite (EBS) Process Manufacturing Process Planning (GMP) module. It functions as a translation table, storing multilingual descriptions and names for Process Parameter Sets. In Process Manufacturing, a Process Parameter Set defines a collection of specific operational parameters (e.g., temperature, pressure, duration) required for a manufacturing step or recipe. The "_TL" suffix indicates this table's primary role is to support the application's multi-language capabilities, allowing the same parameter set to be referenced by users in different installed languages. It works in tandem with its base table, GMP_PROCESS_PARAMETER_SET_B, which holds the language-independent transactional data.

Key Information Stored

The table's structure is designed to manage translated text. Its primary key, which enforces uniqueness, is a composite of PARAMETER_SET_ID and LANGUAGE. The PARAMETER_SET_ID is a foreign key that links each row directly to a unique record in the GMP_PROCESS_PARAMETER_SET_B base table. The LANGUAGE column stores the language code (e.g., 'US' for American English) for the translation. The most critical user-facing columns are typically DESCRIPTION and SOURCE_LANG. The DESCRIPTION column holds the translated name or descriptive text of the parameter set in the specified language. The SOURCE_LANG column identifies the original language in which the record was created, which is crucial for the translation synchronization process. Other standard Translation Table columns like CREATION_DATE and LAST_UPDATE_DATE are also present for auditing.

Common Use Cases and Queries

The primary use case is retrieving parameter set information in a user's session language for display in forms, reports, and product data hubs. A common reporting query joins this table to its base table to present a comprehensive view. For example, to list all parameter sets with their English descriptions, one might use:

  • SELECT b.PARAMETER_SET_ID, tl.DESCRIPTION, b.other_base_columns
  • FROM GMP.GMP_PROCESS_PARAMETER_SET_B b,
  • GMP.GMP_PROCESS_PARAMETER_SET_TL tl
  • WHERE b.PARAMETER_SET_ID = tl.PARAMETER_SET_ID
  • AND tl.LANGUAGE = USERENV('LANG');

Data maintenance for this table is typically performed via the Oracle EBS application interface, which automatically manages the insertion and update of translated records. Direct data manipulation (DML) is strongly discouraged outside of approved APIs or migration scripts.

Related Objects

This table has a direct and essential relationship with the GMP_PROCESS_PARAMETER_SET_B table, as defined by its foreign key constraint. The base table (B) holds the core definition, while the translation table (TL) provides the language-specific labels. This B/TL pair is a standard Oracle EBS design pattern. The table is also integral to the GMP module's data model, meaning it is likely referenced by various Process Planning forms, product data management (PDM) screens, and reporting views that present parameter set information. While not listed in the provided metadata, related objects could include views like GMP_PROCESS_PARAMETER_SETS_VL (where "_VL" indicates a view with language support) that join the B and TL tables for easier querying.