Search Results gmp_param_values_b_pk




Overview
Explore in AI Chat

Overview

The GMP_PARAMETER_VALUES_B table is a core data object within the Oracle E-Business Suite (EBS) Process Manufacturing (GMP) Process Planning module. It functions as the master table for storing discrete, allowable values for process parameters defined within the system. In the context of process manufacturing, where production is governed by precise recipes and formulas, this table provides the critical, validated set of values (e.g., temperature ranges, pressure settings, time durations) that can be assigned to parameters during process step definition. Its role is to enforce data integrity and consistency by restricting parameter inputs to a predefined list, ensuring that process plans are built using standardized, approved operational data.

Key Information Stored

The table's structure is centered on a composite primary key, which uniquely identifies each valid parameter value combination. The most significant columns are:

  • PARAMETER_ID: A foreign key that links the value to its parent process parameter definition in the GMP_PROCESS_PARAMETERS_B table. This identifies *which* parameter the value belongs to.
  • PARAMETER_VALUE: The actual discrete value (e.g., '100', 'HIGH', '30.5') that is permissible for the associated parameter. This column, together with PARAMETER_ID, forms the table's primary key (GMP_PARAM_VALUES_B_PK).

This simple but effective design allows for the management of value lists for various parameter types, from numeric ranges to specific text-based codes.

Common Use Cases and Queries

A primary use case is the validation and population of value lists in the Process Plan and Recipe definition user interfaces. When a planner selects a parameter for a process step, the application queries this table to present a list of valid choices. For reporting and data analysis, common queries involve joining to parameter descriptions to audit available settings. A typical SQL pattern to retrieve all valid values for a specific parameter would be:

SELECT gpvb.PARAMETER_VALUE, gptl.DESCRIPTION
FROM GMP.GMP_PARAMETER_VALUES_B gpvb
JOIN GMP.GMP_PROCESS_PARAMETERS_B gppb ON gpvb.PARAMETER_ID = gppb.PARAMETER_ID
JOIN GMP.GMP_PARAMETER_VALUES_TL gptl ON gpvb.PARAMETER_ID = gptl.PARAMETER_ID AND gpvb.PARAMETER_VALUE = gptl.PARAMETER_VALUE
WHERE gppb.PARAMETER_CODE = '&PARAMETER_CODE' AND gptl.LANGUAGE = USERENV('LANG');

This query leverages the key relationships to fetch translated descriptions of the stored values.

Related Objects

The GMP_PARAMETER_VALUES_B table is centrally connected to other critical Process Planning entities through documented foreign key relationships:

  • GMP_PROCESS_PARAMETERS_B: This is the parent table. The foreign key on GMP_PARAMETER_VALUES_B.PARAMETER_ID references GMP_PROCESS_PARAMETERS_B.PARAMETER_ID, ensuring every value is associated with a defined parameter.
  • GMP_PARAMETER_VALUES_TL: This is the corresponding Translation table. It holds language-specific descriptions for the parameter values. A foreign key from the TL table references both the PARAMETER_ID and PARAMETER_VALUE columns in GMP_PARAMETER_VALUES_B, enabling multilingual support for the value descriptions.

These relationships form a logical hierarchy: Process Parameter (B) -> Parameter Value (B) -> Translated Value Description (TL), which is fundamental to the configuration of process manufacturing data.