OPM Batch Steps and Resource Usage – Oracle EBS SQL Report

Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.

Overview

Oracle Process Manufacturing (OPM) batch steps and resource usage: each production batch routing step with its status, planned versus actual step quantity and dates, and the planned versus actual usage, usage variance, count and UOM of each resource (machine / labor) on the step. Supports batch execution review and resource-efficiency analysis.

Report Parameters

Organization Code, Batch Number, Resource, Step Status

Oracle EBS Tables Used

gme_batch_steps, gme_batch_step_resources, gme_batch_header, org_organization_definitions, org_access_view

Report Categories

Enginatics

CAC OPM WIP Account Value, OPM Batch Yield Variance, OPM Batch Material Usage and Substitution Variance, OPM Batch Details and Status Summary, OPM Batch Lot Cost Details, OPM Batch Lot Cost Trends

Running This SQL Without Blitz Report

Some Oracle EBS SQL reports in this library require functions from the utility package xxen_util. Install it before running the SQL directly against your Oracle EBS database.

Download & Import Options

Resource Link
Excel Example Output OPM Batch Steps and Resource Usage 05-Jun-2026 120006.xlsx
Blitz Report™ XML Import OPM_Batch_Steps_and_Resource_Usage.xml
Full SQL on Enginatics www.enginatics.com/reports/opm-batch-steps-and-resource-usage/

© 2026 Enginatics