Search Results gmd_recipe_process_parameters

Overview

The GMP_PROCESS_PARAMETERS_B table is a core master data table within the Oracle E-Business Suite Process Manufacturing (GMP) module. It serves as the central repository for defining process parameters, which are measurable or controllable variables critical to manufacturing operations. These parameters are foundational elements used to define, monitor, and control the execution of recipes and process instructions across the Process Planning and Process Execution functions. The table stores the technical definition and attributes of each parameter, enabling their consistent application in recipe steps, resource requirements, and operational instructions.

Key Information Stored

While the provided metadata does not list specific columns, the structure and foreign key relationships indicate it is a base table for translatable entities, typically containing key technical identifiers and control columns. Based on standard Oracle EBS patterns and the table's role, the primary column is PARAMETER_ID, a unique system-generated identifier serving as the primary key. Other likely columns include CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY for auditing, and ENABLED_FLAG or similar to control active status. The table's corresponding translatable table, GMP_PROCESS_PARAMETERS_TL, would store language-specific names and descriptions linked via the PARAMETER_ID.

Common Use Cases and Queries

This table is primarily referenced in master data setup and reporting scenarios. Common use cases include validating parameter definitions used in active recipes, listing all available parameters for a specific process or plant resource, and auditing parameter usage. A typical query would join the base table with its translation table to retrieve meaningful names, and potentially with referencing tables to assess impact.

• Sample Query to List Active Parameters:
  SELECT b.PARAMETER_ID, tl.PARAMETER_NAME
FROM GMP.GMP_PROCESS_PARAMETERS_B b,
GMP.GMP_PROCESS_PARAMETERS_TL tl
WHERE b.PARAMETER_ID = tl.PARAMETER_ID
AND tl.LANGUAGE = USERENV('LANG')
AND b.ENABLED_FLAG = 'Y';
• Reporting Use Case: Identifying all recipe steps that reference a specific process parameter to assess the scope of a planned parameter definition change.

Related Objects

The GMP_PROCESS_PARAMETERS_B table is a central hub referenced by numerous child tables across the GMP and GMD (Process Operations) modules, as detailed in the foreign key metadata. Key related objects include:

• GMP_PROCESS_PARAMETERS_TL: The translatable table storing language-specific names and descriptions.
• GMD_RECIPE_PROCESS_PARAMETERS / GMD_OPRN_PROCESS_PARAMETERS: Tables that assign these master parameters to specific recipe details and operational instructions.
• GMP_RESOURCE_PARAMETERS / GMP_PLANT_RSRC_PARAMETERS: Tables linking parameters to resources and plant resources for capability definition.
• GMP_PARAMETER_VALUES_B: Likely stores allowed or default values for a parameter.
• GMP_PROCESS_PARAMETER_SETS: Used to group related parameters together.