Results for “target_value”
4 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
GMP_PLANT_RSRC_PARAMETERS is a transactional configuration table in the Oracle EBS Process Manufacturing (OPM) Process Planning module. It associates process parameters with generic plant resources, allowing planners to define acceptable operating ranges for each parameter that a resource can produce or consume. In the Process Manufacturing data model, resources represent capacities such as reactors, mixers, or packaging lines, and parameters represent measurable process attributes such as temperature, pressure, pH, or viscosity. This table captures the per-resource parameter specification—including target, minimum, and maximum values—that governs how a resource may be used in a routing or recipe.
The object resides in the GMP schema and contains ten documented columns in ETRM 12.2.2. It functions as an intersection between two master entities: CR_RSRC_DTL (the resource) and GMP_PROCESS_PARAMETERS_B (the parameter). Because it resolves a many-to-many relationship between those two entities, a heuristic Data Vault classification suggests it be modeled as a link table, with the two foreign keys forming the relationship's composite business key and the value columns acting as link-level descriptive attributes.
Key Information Stored
The table's two identifying columns are RESOURCE_ID and PARAMETER_ID. RESOURCE_ID is a foreign key to CR_RSRC_DTL, identifying the generic resource to which the parameter applies. PARAMETER_ID is a foreign key to GMP_PROCESS_PARAMETERS_B, identifying the process parameter definition. Together these columns form the composite business key of the association and are the natural target of a unique constraint or unique index; there is no single-column surrogate key documented for this table.
The value-bearing columns define the operating envelope for the parameter on the given resource. TARGET_VALUE holds the nominal or ideal value, MINIMUM_VALUE holds the lower acceptable bound, and MAXIMUM_VALUE holds the upper acceptable bound. These three columns drive validations during recipe and routing maintenance, and they provide the reference figures used when a batch is executed against the resource.
The remaining documented columns are standard Oracle EBS audit columns: CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, and LAST_UPDATE_LOGIN. These record who created and last modified each association and when, supporting audit and concurrency control.
Common Use Cases and Queries
A frequent requirement is to list every parameter defined for a given resource, together with its permissible range. The following pattern joins the association to the parameter definition table:
- SELECT rp.resource_id, rp.parameter_id, rp.target_value, rp.minimum_value, rp.maximum_value FROM gmp.gmp_plant_rsrc_parameters rp WHERE rp.resource_id = :resource_id;
- Joining to GMP_PROCESS_PARAMETERS_B on PARAMETER_ID retrieves the parameter code and description for reporting.
- Joining to CR_RSRC_DTL on RESOURCE_ID retrieves the resource code and resource type for cross-resource comparisons.
- Range-violation reporting compares recorded values against MINIMUM_VALUE and MAXIMUM_VALUE to flag out-of-specification conditions.
- Completeness auditing identifies resources that have no parameter associations, or parameters that have never been assigned to a resource.
- Change tracking uses LAST_UPDATE_DATE and LAST_UPDATED_BY to report recent modifications to resource specifications.
Because the table is relatively small and keyed on two columns, queries against it are efficient when filtered by RESOURCE_ID or by PARAMETER_ID.
Related Objects
The following objects are most significant in relation to GMP_PLANT_RSRC_PARAMETERS:
- CR_RSRC_DTL — parent of RESOURCE_ID; holds the resource definition.
- GMP_PROCESS_PARAMETERS_B — parent of PARAMETER_ID; holds the parameter definition.
- GMP_ROUTING_DTL and related routing tables — consume resource and parameter specifications during routing maintenance.
- GMP_RECIPE_* tables — reference parameters when recipes are validated against resource capability.
- GMP_BATCH_* tables — record actual results that are compared with the target, minimum, and maximum values defined here.
These relationships place GMP_PLANT_RSRC_PARAMETERS at the intersection of resource master data and parameter master data within the Process Manufacturing planning and execution flow.
-
Table for Association of Parameters to the Generic Resources
-
Table for Association of Parameters to the Generic Resources
-
Table for Association of Parameters to the Generic Resources
-
Table for Association of Parameters to the Generic Resources