Search Results gme_process_parameters_mig

Overview

GME_PROCESS_PARAMETERS_MIG is a table owned by the GME schema within Oracle Process Manufacturing (OPM) Process Execution. It serves as a migration and staging structure for process parameter data collected at the batch, batch step, batch step activity, and resource levels. In the Oracle EBS 12.1.1 / 12.2.2 context, this table supports the transfer, validation, or staging of parameter values that are ultimately consumed by the core GME_PROCESS_PARAMETERS table and its associated batch execution logic.

From a Data Vault modeling perspective, the heuristic classification of this object is standalone. This classification reflects that the table is not a classic hub, link, or satellite in a normalized Data Vault sense, but rather an operational migration staging entity that carries both descriptive and transactional attribute payloads. It holds foreign key references to upstream execution entities while retaining its own attribute columns, making it a denormalized intermediate store rather than a strictly hub or satellite construct.

Key Information Stored

The table contains 49 documented columns. The most functionally significant columns are:

• PROCESS_PARAM_ID — Foreign key to GME_PROCESS_PARAMETERS, identifying the process parameter definition being migrated. This is the primary business linkage column.
• BATCHSTEP_ACTIVITY_ID — Foreign key to GME_BATCH_STEP_ACTIVITIES, tying the staged parameter to a specific batch step activity.
• BATCH_ID — Identifies the manufacturing batch associated with the staged parameter.
• BATCHSTEP_ID — Identifies the batch step within the batch.
• BATCHSTEP_RESOURCE_ID — Identifies the specific resource used within the batch step.
• PARAMETER_ID — The parameter definition identifier.
• TARGET_VALUE, MINIMUM_VALUE, MAXIMUM_VALUE — Specification limits for the parameter being migrated.
• ACTUAL_VALUE — The recorded or measured value for the parameter.
• PARAMETER_UOM — Unit of measure associated with the parameter value.
• RESOURCES — Descriptive resource information.
• DEVICE_ID — Reference to the device or equipment generating the parameter reading.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE30 — The standard Oracle EBS descriptive flexfield (DFF) columns, providing extensible attribute capacity.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, LAST_UPDATE_DATE — Standard WHO audit columns tracking record provenance and change history.

The documented metadata does not explicitly identify a single-column surrogate primary key or named unique index. Functionally, the combination of PROCESS_PARAM_ID and BATCHSTEP_ACTIVITY_ID serves as the strongest business-key candidate, given both are foreign keys to parent execution entities.

Common Use Cases and Queries

Typical usage revolves around staging process parameter data for migration, bulk loading, or reconciliation against the production parameter tables. Common scenarios include validating migrated parameters against their expected batch context and generating exception reports for records that fail load conditions.

• Reconciliation query: Join GME_PROCESS_PARAMETERS_MIG to GME_PROCESS_PARAMETERS on PROCESS_PARAM_ID to confirm each staged parameter maps to a valid definition.
• Activity validation: Join to GME_BATCH_STEP_ACTIVITIES on BATCHSTEP_ACTIVITY_ID to verify the activity context exists for each migration row.
• Out-of-spec detection: Filter rows where ACTUAL_VALUE falls outside MINIMUM_VALUE and MAXIMUM_VALUE ranges.
• Batch-level reporting: Aggregate by BATCH_ID and BATCHSTEP_ID to summarize parameter coverage per batch.
• DFF extraction: Query ATTRIBUTE_CATEGORY with ATTRIBUTE1–ATTRIBUTE30 for site-specific custom data captured during migration.

Related Objects

The following objects are most directly related, based on documented foreign key relationships and product context:

• GME_PROCESS_PARAMETERS — Joined via GME_PROCESS_PARAMETERS_MIG.PROCESS_PARAM_ID = GME_PROCESS_PARAMETERS.PROCESS_PARAM_ID. This is the primary parent definition table.
• GME_BATCH_STEP_ACTIVITIES — Joined via GME_PROCESS_PARAMETERS_MIG.BATCHSTEP_ACTIVITY_ID = GME_BATCH_STEP_ACTIVITIES.BATCHSTEP_ACTIVITY_ID. Provides the activity execution context.
• GME_BATCH_STEPS — Referenced through BATCHSTEP_ID for batch step definition context.
• GME_BATCH_HEADERS — Referenced through BATCH_ID for batch-level header information.
• GME_BATCH_STEP_RESOURCES — Related through BATCHSTEP_RESOURCE_ID for resource assignment details.

These relationships position GME_PROCESS_PARAMETERS_MIG as a migration-oriented companion to the core process parameter model, enabling controlled data movement into the operational GME execution tables.