Search Results gme_batch_step_resources_mig




Overview
Explore in AI Chat

Overview

The GME_BATCH_STEP_RESOURCES_MIG table is a Process Manufacturing Process Execution (GME) object owned by the GME schema in Oracle E-Business Suite 12.1.1 and 12.2.2. As its naming convention (_MIG) suggests, it functions as a migration or interface staging table used to load batch step resource definitions from external systems, legacy applications, or conversion programs into the Oracle Process Manufacturing (OPM) model. It holds resource-level information tied to a specific batch step activity within a batch, capturing planned and actual resource usage, capacity, cost analysis, and descriptive flexfield attributes.

The table contains 80 documented columns. Based on heuristic Data Vault classification mined from its foreign key structure, the object is characterized as standalone. In modeling terms, this suggests the table is not positioned as a classic hub, link, or satellite but rather as an operational staging or detail table whose identity is largely derived from parent batch step activity records. The sole documented foreign key points from BATCHSTEP_ACTIVITY_ID to the GME_BATCH_STEP_ACTIVITIES table.

Key Information Stored

The most significant columns capture the identity, quantity, timing, and costing context of a batch step resource:

Standard audit columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN) are also present.

Common Use Cases and Queries

Typical usage centers on migration validation and operational reporting. A conversion analyst might verify that staged resources loaded correctly by comparing planned versus original quantities:

  • Identifying unbalanced migration rows where PLAN_RSRC_QTY differs from ORIGINAL_RSRC_QTY.
  • Joining to GME_BATCH_STEP_ACTIVITIES to reconcile every activity with its resources.
  • Reporting capacity exceptions where actual usage exceeds MAX_CAPACITY.
  • Cost analysis extracts grouped by COST_ANALYSIS_CODE and COST_CMPNTCLS_ID.

A representative query pattern:

SELECT m.BATCH_ID, m.BATCHSTEP_ID, m.RESOURCES, m.PLAN_RSRC_QTY, m.ACTUAL_RSRC_QTY FROM GME.GME_BATCH_STEP_RESOURCES_MIG m JOIN GME.GME_BATCH_STEP_ACTIVITIES a ON a.BATCHSTEP_ACTIVITY_ID = m.BATCHSTEP_ACTIVITY_ID WHERE m.ORGANIZATION_ID = :org;

Related Objects