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:
- RECIPE_ID — foreign key to the recipe header (GMD_RECIPES_B), identifying which recipe the parameter belongs to.
- ORGANIZATION_ID and ORGN_CODE — the operating organization context; ORGN_CODE references SY_ORGN_MST_B.
- ROUTINGSTEP_ID — foreign key to the routing detail (FM_ROUT_DTL), pinpointing the step at which the parameter applies. This is the column referenced in the user search for "routingstep_id".
- OPRN_LINE_ID — foreign key to GMD_OPERATION_RESOURCES, tying the parameter to a specific resource line.
- RESOURCES — the resource identifier that participates in the composite key and the unique constraint.
- PARAMETER_ID — foreign key to GMP_PROCESS_PARAMETERS_B, defining which parameter is being constrained.
- TARGET_VALUE, MINIMUM_VALUE, MAXIMUM_VALUE — the numeric or textual limits that the resource must meet.
- CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard audit 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_IDand 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.
-
Table associating process parameters to Recipe orgn resource
-
Table associating process parameters to Recipe orgn resource
-
12.2.2 DBA Data 12.2.2
-
12.1.1 FND Design Data 12.1.1
-
12.1.1 DBA Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
12.2.2 DBA Data 12.2.2
-
12.2.2 DBA Data 12.2.2
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
12.1.1 DBA Data 12.1.1
-
12.2.2 FND Design Data 12.2.2