Results for “gmp_process_parameter_set_vl”

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

Overview

GMP_PROCESS_PARAMETER_SET_VL is a seeded, valid database view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the GMP — Process Manufacturing Process Planning product family. The view presents process parameter set definitions in a language-aware form. In the EBS data model, the "_VL" suffix denotes a "view language" object that joins a transactional base table (the "_B" table) to its translation table (the "_TL" table), resolving the translation row for the session's current language. This view therefore exposes one row per parameter set, with descriptive text rendered in the user's active language.

The object is read-only from the perspective of application logic and is intended for reporting, ad-hoc querying, and inbound integration lookups rather than for direct DML. Its principal role is to provide a stable, human-readable access point to process parameter set headers, including the SET_DESCRIPTION column, which is the attribute most frequently referenced by users searching for parameter set descriptive text. Because it conforms to the standard EBS MLS (Multi-Language Support) pattern, it is safe to expose through custom concurrent programs, BI Publisher data models, and OBIEE/OTBI-style extracts.

Underlying Base Objects

The view text defines an inner join between two documented base objects, both referenced through synonyms in the APPS schema:

• GMP_PROCESS_PARAMETER_SET_B — the base (transactional) table holding the parameter set header, including the primary key PARAMETER_SET_ID and the non-translated attribute PARAMETER_SET.
• GMP_PROCESS_PARAMETER_SET_TL — the translation table holding language-specific descriptive attributes, notably SET_DESCRIPTION, keyed by PARAMETER_SET_ID and LANGUAGE.

The join predicate is B.PARAMETER_SET_ID = T.PARAMETER_SET_ID AND T.LANGUAGE = USERENV('LANG'). The USERENV('LANG') call restricts output to the single language matching the current session, which is why the view returns one row per parameter set rather than one row per installed language. The ROWID of the base table row is also projected, aliased as ROW_ID, giving consumers a unique physical row identifier.

Key Columns

• ROW_ID — the ROWID of the GMP_PROCESS_PARAMETER_SET_B row, useful as a surrogate unique identifier in reporting datasets.
• PARAMETER_SET_ID — the system-generated primary key for the parameter set; the join and foreign-key anchor for related parameter detail tables.
• PARAMETER_SET — the user-defined, untranslated parameter set name/code, drawn from the base table.
• SET_DESCRIPTION — the language-specific description of the parameter set, drawn from the translation table. This is the text most commonly surfaced in list-of-values and enquiry screens.
• CREATION_DATE, CREATED_BY — standard WHO audit columns recording when and by whom the parameter set was created.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard WHO audit columns capturing the most recent modification and the login that performed it.

Common Use Cases and Queries

Typical uses include parameter set list-of-values populations, descriptive reporting on process parameter configurations, and validation lookups during data conversion or interface loads. To retrieve all parameter sets with descriptions in the session language:

SELECT parameter_set_id,
       parameter_set,
       set_description,
       creation_date,
       last_update_date
FROM   apps.gmp_process_parameter_set_vl
ORDER BY parameter_set;

To resolve a specific set by its descriptive name (a common pattern for the "set_description" search):

SELECT parameter_set_id,
       parameter_set,
       set_description
FROM   apps.gmp_process_parameter_set_vl
WHERE  UPPER(set_description) LIKE UPPER('%&search_text%');

To audit recently modified parameter sets:

SELECT parameter_set,
       set_description,
       last_updated_by,
       last_update_date
FROM   apps.gmp_process_parameter_set_vl
WHERE  last_update_date >= TRUNC(SYSDATE) - 30
ORDER BY last_update_date DESC;

Because the view filters on USERENV('LANG'), multilingual environments must run extractions under the intended language session, or query the underlying GMP_PROCESS_PARAMETER_SET_TL table directly when descriptions for all installed languages are required.