Results for “gmp_process_parameter_set_tl”

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

Overview

GMP_PROCESS_PARAMETER_SET_TL is a translation (TL) table in the GMP schema, belonging to the Process Manufacturing Process Planning module (Oracle Process Manufacturing, or OPM). It stores the language-dependent descriptive attributes of Process Parameter Sets — reusable groupings that define which process parameters are measured, tracked, and validated during manufacturing execution. The "_TL" suffix indicates that this table holds translatable text such as set descriptions, while the corresponding "_B" (base) table holds the language-independent, structural data.

A parameter set in OPM represents a logical collection of process parameter definitions that can be applied across recipes, batches, or quality workflows. This TL table supplies the human-readable description rendered in the operator's session language, supporting multilingual deployments of Oracle EBS 12.1.1 and 12.2.2.

From a Data Vault modeling perspective, the FK relationship (PARAMETER_SET_ID referencing GMP_PROCESS_PARAMETER_SET_B) and the composite primary key on (PARAMETER_SET_ID, LANGUAGE) suggest a satellite-leaning classification: this table extends the core base entity with language-dependent descriptive attributes keyed by the parent hub/business key plus a language discriminator. This is a heuristic suggestion, not a mandated model.

Key Information Stored

• PARAMETER_SET_ID — The surrogate identifier for the process parameter set. It is the leading column of the composite primary key and also the foreign key to GMP_PROCESS_PARAMETER_SET_B, linking each translated row to its base record.
• LANGUAGE — The language code identifying the translation. Together with PARAMETER_SET_ID it forms the unique primary key, ensuring one description row per language.
• SET_DESCRIPTION — The translatable, user-facing description of the parameter set, displayed in forms and reports according to the session language.
• SOURCE_LANG — The source language from which the description was derived, supporting Oracle's translated-entity conventions (e.g., US for the base language).
• CREATED_BY, CREATION_DATE — Standard WHO audit columns recording the creating user and timestamp.
• LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard WHO audit columns capturing the most recent modification user, timestamp, and login context.

The documented business-key candidate is the unique index GMP_PROCESS_PARAM_SET_TL_PK defined on (PARAMETER_SET_ID, LANGUAGE). The table contains nine documented columns in total.

Common Use Cases and Queries

Typical usage centers on resolving the correct description for a given parameter set in a specified language, or joining the base and translation tables to produce bilingual or multilingual reporting.

To retrieve the description for a specific language:

• SELECT SET_DESCRIPTION FROM GMP_PROCESS_PARAMETER_SET_TL WHERE PARAMETER_SET_ID = :p_id AND LANGUAGE = :lang;

To list all parameter sets with their base-language descriptions, join to the base table:

• SELECT B.PARAMETER_SET_ID, T.SET_DESCRIPTION FROM GMP_PROCESS_PARAMETER_SET_B B, GMP_PROCESS_PARAMETER_SET_TL T WHERE B.PARAMETER_SET_ID = T.PARAMETER_SET_ID AND T.LANGUAGE = USERENV('LANG');

Reporting scenarios include parameter-set catalogs, recipe documentation, quality specification listings, and audit extracts that reconcile translated versus base-language content. Because the TL table stores only descriptive text, it is frequently joined rather than queried in isolation.

Related Objects

• GMP_PROCESS_PARAMETER_SET_B — The base table holding language-independent attributes; joined on PARAMETER_SET_ID (documented FK).
• GMP_PROCESS_PARAMETER_SET_TL (PK) — GMP_PROCESS_PARAM_SET_TL_PK on (PARAMETER_SET_ID, LANGUAGE).
• Process parameter definition tables in the GMP schema — reference parameter sets by PARAMETER_SET_ID to associate measurable parameters.
• Recipe and batch execution entities in OPM — consume parameter sets during manufacturing.
• FND_LANGUAGES — Provides language validation for the LANGUAGE and SOURCE_LANG columns.

Understanding the base-to-translation relationship is essential for correct querying, since the structural identity of a parameter set resides in the _B table while its displayable description resides here.