Results for “parameter_set”

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

Overview

GMP_PROCESS_PARAMETER_SET_B is the base (non-translated) table that defines Process Parameter Sets within the Oracle E-Business Suite Process Manufacturing Process Planning module. A process parameter set is a named grouping of process parameters that can be referenced and reused across process plans, recipes, and related manufacturing constructs. In Oracle EBS 12.1.1 and 12.2.2, this table resides in the GMP schema and is flagged as VALID in the data dictionary.

The table holds the language-independent attributes of each parameter set, while the translated, user-facing descriptive text is stored separately in GMP_PROCESS_PARAMETER_SET_TL. This base/translation split is the standard EBS pattern for enabling multi-language support. From a Data Vault modeling standpoint, the mined foreign-key structure suggests a hub-leaning classification: the table is the anchor entity for the parameter set identifier, with related satellite-style attributes (name and audit columns) attached directly. This is a heuristic suggestion rather than a documented architectural designation.

The primary key, GMP_PROCESS_PARAM_SET_B_PK, is defined on the PARAMETER_SET_ID column, establishing the table as the parent in several referential relationships across the GMP and PSB schemas.

Key Information Stored

The documented physical schema contains seven columns. The most significant are:

• PARAMETER_SET_ID — Surrogate primary key. This is the unique system-generated identifier (GMP_PROCESS_PARAM_SET_B_PK) that anchors each parameter set and is used as the foreign key by every dependent table.
• PARAMETER_SET — The business-key candidate holding the parameter set value or name used to identify the set within the application logic.
• CREATION_DATE — Timestamp captured when the parameter set record was first created.
• CREATED_BY — The application user ID that created the record.
• LAST_UPDATE_DATE — Timestamp of the most recent modification.
• LAST_UPDATED_BY — The user ID responsible for the last update.
• LAST_UPDATE_LOGIN — The login session associated with the last update, providing audit traceability.

The surrogate key PARAMETER_SET_ID is the sole documented unique index. The descriptive/language-dependent attributes are not stored here; they are held in the TL companion table. The audit columns follow the standard EBS who-column convention and should be treated as satellite-style metadata rather than business keys.

Common Use Cases and Queries

Typical usage centers on resolving parameter set identifiers during reporting and integration. A common query joins the base table to its translation table to retrieve the display name for a given set:

• Retrieving a parameter set with its translated name: SELECT b.PARAMETER_SET_ID, b.PARAMETER_SET, t.PARAMETER_SET_NAME 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');
• Auditing recently created or modified parameter sets by querying CREATION_DATE and LAST_UPDATE_DATE within a date range.
• Confirming existence of orphan or orphaned relationships by left-joining dependent tables (such as PSB_WORKSHEETS) to PARAMETER_SET_ID.
• Feeding downstream reporting tools that require the surrogate key to correlate worksheet, budget revision, and report definitions to their governing parameter set.

Related Objects

Several objects reference this table through the PARAMETER_SET_ID column, confirming its role as a parent hub:

• GMP_PROCESS_PARAMETER_SETS — references GMP_PROCESS_PARAMETER_SET_B.PARAMETER_SET_ID, linking individual parameter entries to the set.
• GMP_PROCESS_PARAMETER_SET_TL — the translation table, joined on PARAMETER_SET_ID for language-dependent names and descriptions.
• PSB_BUDGET_REVISIONS — references PARAMETER_SET_ID, tying process budget revisions to their parameter set.
• PSB_WORKSHEETS — references PARAMETER_SET_ID, connecting planning worksheets to the parameter set definition.
• RG_REPORTS — references PARAMETER_SET_ID, associating report definitions with the parameter set.

Together these relationships make GMP_PROCESS_PARAMETER_SET_B the central reference point for parameter set configuration across process planning, budgeting, and reporting functions in Oracle Process Manufacturing.