Results for “gmd_recipe_process_parameters”

50+ results




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

Overview

GMD.GMD_RECIPE_PROCESS_PARAMETERS is a Process Manufacturing Product Development table that associates process parameters with the resource of a recipe organization. In Oracle EBS 12.1.1 and 12.2.2, it records the target, minimum, and maximum values that a given resource must satisfy at a specific routing step within a recipe. Each row therefore ties a recipe, an organization, a routing step, an operation resource line, and a process parameter into a single controlled data point.

The ETRM metadata classifies this object heuristically as a link table in Data Vault terms. This is a modeling suggestion rather than a functional designation: the table resolves a many-to-many relationship between process parameters and recipe routing/resource definitions, and its composite key is built from foreign references rather than from an intrinsic business entity.

Key Information Stored

Column behavior is documented for 15 physical columns. The most significant are the key and reference columns:

The documented primary key is GMD_RCP_PROC_PARAM_PK over RECIPE_ID, ORGANIZATION_ID, ROUTINGSTEP_ID, OPRN_LINE_ID, PARAMETER_ID, and RESOURCES. A business-key candidate unique index, GMD_RCP_PROC_PARAM_UK, is documented over the same logical set using ORGN_CODE in place of ORGANIZATION_ID.

Common Use Cases and Queries

Typical reporting retrieves the tolerance envelope for each recipe step so that planners and quality engineers can verify that a resource is being operated within limits. A representative query joins the routing step and the parameter definition:

  • Retrieve all parameters for a given recipe and organization: SELECT ROUTINGSTEP_ID, OPRN_LINE_ID, RESOURCES, PARAMETER_ID, TARGET_VALUE, MINIMUM_VALUE, MAXIMUM_VALUE FROM GMD_RECIPE_PROCESS_PARAMETERS WHERE RECIPE_ID = :recipe_id AND ORGANIZATION_ID = :org_id;
  • Report parameters affected by a specific routing step: filter on ROUTINGSTEP_ID and join to FM_ROUT_DTL to obtain step descriptions.
  • Audit changes by filtering on LAST_UPDATE_DATE and LAST_UPDATED_BY to detect recent parameter limit modifications.
  • Exception reporting where TARGET_VALUE falls outside MINIMUM_VALUE and MAXIMUM_VALUE.

Related Objects

The FK metadata identifies the principal parent and dependent objects:

  • GMP_PROCESS_PARAMETERS_B — joined on PARAMETER_ID; supplies the parameter name and definition.
  • FM_ROUT_DTL — joined on ROUTINGSTEP_ID; provides routing step detail.
  • GMD_OPERATION_RESOURCES — joined on OPRN_LINE_ID and RESOURCES; defines the resource line.
  • GMD_RECIPES_B — joined on RECIPE_ID; the recipe header.
  • SY_ORGN_MST_B — joined on ORGN_CODE; the organization master reference.

These relationships make GMD_RECIPE_PROCESS_PARAMETERS a central integration point between recipe, routing, resource, and parameter definitions in Process Manufacturing Product Development.