Results for “gmp_process_parameter_set_b”

4 results




Overview
Explore in AI Chat

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

Overview

GMD.GMD_OPRN_PROCESS_PARAMETERS is a Process Manufacturing Product Development (GMD) table in Oracle E-Business Suite 12.1.1 and 12.2.2 that associates process parameters with operation resources. Within the Process Manufacturing model, a recipe operation can be executed against one or more resources—equipment, labor, or utilities—and each resource can carry measurable process parameters such as temperature, pressure, pH, or cycle time. This table records those associations along with the acceptable value envelope (target, minimum, and maximum values) that governs how the parameter is permitted to behave at that resource.

In Data Vault modeling terms, the heuristic classification for this table is link. It sits between business keys originating in GMP_PROCESS_PARAMETERS_B and GMD_OPERATION_RESOURCES, resolving a many-to-many relationship rather than describing a single business entity. The table carries only limited descriptive attributes (the value limits) and no long-lived descriptive payload, reinforcing its role as an associative junction.

Key Information Stored

  • OPRN_LINE_ID — Identifies the operation resource line being annotated. This is a foreign key to GMD_OPERATION_RESOURCES and one third of the composite primary key.
  • RESOURCES — The resource qualifier within the operation line. Together with OPRN_LINE_ID and PARAMETER_ID, forms the unique business key.
  • PARAMETER_ID — Foreign key to GMP_PROCESS_PARAMETERS_B, identifying the process parameter definition (for example, temperature or hold time).
  • TARGET_VALUE — The nominal or set-point value expected for the parameter at this resource.
  • MINIMUM_VALUE — The lower acceptable bound; readings below this are non-conforming.
  • MAXIMUM_VALUE — The upper acceptable bound; readings above this are non-conforming.
  • CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard EBS audit columns capturing who created and last maintained the association, providing traceability for change control.

The surrogate primary key is GMD_OPRN_PROC_PARAM_PK, which spans (OPRN_LINE_ID, RESOURCES, PARAMETER_ID). No alternate surrogate is documented; the composite itself functions as both the surrogate and the business-key candidate. All three key columns must therefore be supplied on insert and are implicitly available for unique lookups.

Common Use Cases and Queries

Engineers query this table to review or validate the parameter limits attached to a resource before releasing a recipe. Quality and process control teams extract the target/min/max envelope to drive Statistical Process Control (SPC) limits, operator work instructions, or electronic batch record checks. Migration and configuration teams generate comparison reports to confirm parameter assignments match between source and target instances.

A representative query lists the parameters and limits for a given operation resource:

  • SELECT p.parameter_id, p.target_value, p.minimum_value, p.maximum_value FROM gmd.gmd_oprn_process_parameters p WHERE p.oprn_line_id = :oprn_line_id ORDER BY p.parameter_id;
  • SELECT opp.parameter_id, b.parameter_description FROM gmd.gmd_oprn_process_parameters opp JOIN gmp.gmp_process_parameters_b b ON b.parameter_id = opp.parameter_id;
  • SELECT COUNT(*) FROM gmd.gmd_oprn_process_parameters WHERE target_value IS NULL; — identifies parameters missing a target value, a common data-quality check.

Because the table is denormalized around three key columns, join-heavy reporting is typical, and indexes on the inherited foreign keys support lookups by parameter or by operation resource line.

Related Objects

  • GMP_PROCESS_PARAMETERS_B — Parent definition of process parameters; joined on PARAMETER_ID. This supplies the parameter name, description, and UOM.
  • GMD_OPERATION_RESOURCES — Parent of the resource line; joined on OPRN_LINE_ID. This is the immediate structural owner of the record.
  • GMD_OPERATIONS_B and GMD_ROUTING_HEADERS — Reached transitively through GMD_OPERATION_RESOURCES to determine which operation, routing, and recipe a parameter ultimately belongs to.
  • GMD_RECIPE_HEADERS — The product-development recipe context in which operation resources and their parameters are defined.
  • GMP_PROCESS_PARAMETERS_TL — Provides translated parameter descriptions for reporting in multiple languages.
  • GMD_OPRN_PROCESS_PARAMETERS_UI and related Process Manufacturing OAF pages / PL/SQL APIs — Used to maintain these associations in the EBS forms and web UI.

Collectively, these objects let reporting and validation routines travel from a recipe down to the individual parameter limit applied at each operation resource, which is the core purpose of GMD_OPRN_PROCESS_PARAMETERS.