Search Results oprn_line_id




Overview
Explore in AI Chat

Overview

The GMD_RECIPE_PROCESS_PARAMETERS table is a core data object within Oracle E-Business Suite Process Manufacturing (GMD) Product Development. It functions as a junction table that establishes the critical association between a specific process parameter and a manufacturing resource within the context of a recipe. This table is essential for defining and controlling the precise operational conditions, such as temperature, pressure, or duration, that must be maintained by a resource (like a reactor or mixer) during a specific step in a production routing. Its existence enables the detailed specification and enforcement of quality and process standards, which are fundamental to regulated manufacturing environments.

Key Information Stored

The table's structure is defined by a composite primary key that uniquely identifies each parameter assignment. The key columns are RECIPE_ID, ORGANIZATION_ID, ROUTINGSTEP_ID, OPRN_LINE_ID, PARAMETER_ID, and RESOURCES. These fields collectively pinpoint the exact recipe, the executing organization, the specific routing step, the operational resource line, the parameter being controlled, and the resource itself. The PARAMETER_ID is a foreign key to GMP_PROCESS_PARAMETERS_B, linking to the master definition of the parameter, including its name, data type, and valid value ranges. The table also includes a column, ORGN_CODE, which is linked to SY_ORGN_MST_B, potentially for additional organizational context.

Common Use Cases and Queries

A primary use case is the generation of batch-specific manufacturing instructions or process control documentation. For instance, a report listing all parameters for a given recipe and routing step would join this table to the recipe, routing, resource, and parameter master tables. A typical query pattern involves filtering by RECIPE_ID and ROUTINGSTEP_ID to retrieve the associated resources and their mandated parameters. This data is also crucial for validation scripts that ensure parameter values defined in a recipe fall within the acceptable limits specified in the parameter master. Furthermore, integration with Manufacturing Execution Systems (MES) or Historian software often extracts data from this table to configure real-time process monitoring points.

Related Objects

The table maintains integral relationships with several master and transactional tables via foreign keys, as documented in the ETRM metadata. Key relationships include:

  • GMD_RECIPES_B: Via RECIPE_ID. This is the master recipe definition.
  • FM_ROUT_DTL: Via ROUTINGSTEP_ID. This links to the detailed routing step definition.
  • GMD_OPERATION_RESOURCES: Via OPRN_LINE_ID and RESOURCES. This identifies the specific resource assigned to the operation.
  • GMP_PROCESS_PARAMETERS_B: Via PARAMETER_ID. This is the master table defining the parameter's characteristics.
  • SY_ORGN_MST_B: Via ORGN_CODE. This provides organizational master data.
These relationships ensure data integrity and enable comprehensive joins for reporting and process definition.