OPM Batch Details and Status Summary – Oracle EBS SQL Report

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

Overview

Oracle Process Manufacturing (OPM) batch details and status summary: one row per production batch showing batch status and type, recipe, primary product and planned/actual output quantity, planned versus actual start and completion dates, and whether the batch completed on time. Set a pending/released status with plan-date filters for a planned-production view.

Report Parameters

Organization Code, Batch Number, Product Item, Batch Status, Actual Start Date From, Actual Start Date To

Oracle EBS Tables Used

gme_batch_header, org_organization_definitions, gmd_recipe_validity_rules, gmd_recipes_vl, gme_material_details, mtl_system_items_vl, org_access_view

Report Categories

Enginatics

OPM Batch Yield Variance, OPM Batch Material Usage and Substitution Variance

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 Details and Status Summary 05-Jun-2026 120004.xlsx
Blitz Report™ XML Import OPM_Batch_Details_and_Status_Summary.xml
Full SQL on Enginatics www.enginatics.com/reports/opm-batch-details-and-status-summary/

© 2026 Enginatics