Oracle EBS Process Manufacturing Reports

15 ready-to-run SQL reports for Oracle E-Business Suite Process Manufacturing, maintained by Enginatics and used in production at Oracle EBS customers worldwide. Each report page lists its parameters, the Oracle EBS tables it reads and an Excel example output. The most frequently used Process Manufacturing tables in these reports are org_organization_definitions, mtl_system_items_vl, org_access_view, gme_batch_header, gmd_recipes_vl, gme_material_details.

Run any of these reports in Excel in seconds: download Blitz Report™ free – your first 30 reports are free.

Process Manufacturing SQL Reports

Report Description
OPM Batch Details and Status Summary Oracle Process Manufacturing (OPM) batch details and status summary: one row per production batch showing batch status and type, recipe, primary product and…
OPM Batch Lot Cost Details OPM Batch Lot Cost Details Report This report shows the Batch Lot Costs details for completed batches in the specified from/to Date Range and for the specified…
OPM Batch Lot Cost Trends OPM Batch Lot Costing Trends Report This report shows the Batch Lot Costs for the specified Organization and Product over a specified date range. The report…
OPM Batch Lot Genealogy Oracle Process Manufacturing (OPM) batch lot genealogy as a multi-level tree, as shown in the Source and Where Used tabs of the Oracle Genealogy form. Source…
OPM Batch Material Usage and Substitution Variance Oracle Process Manufacturing (OPM) batch material usage and substitution variance: per-ingredient planned versus actual consumption per production batch, with…
OPM Batch Steps and Resource Usage Oracle Process Manufacturing (OPM) batch steps and resource usage: each production batch routing step with its status, planned versus actual step quantity and…
OPM Batch Yield Variance Oracle Process Manufacturing (OPM) batch yield variance: compares planned versus actual product and by-product output quantities against total batch input…
OPM Detailed Subledger OPM Financials Detailed Subledger Report showing transaction headers, extract lines with debit/credit amounts, and GL account distributions. Based on Oracle…
OPM Formula Details Oracle Process Manufacturing (OPM) Product Development formula details: the ingredient, product and by-product lines of each formula with quantities, UOM…
OPM Formula Where-Used Oracle Process Manufacturing (OPM) formula where-used: lists which formulas consume a given ingredient item, with the ingredient quantity and UOM, the using…
OPM Item Location Test Results Oracle Process Manufacturing (OPM) Quality item/location test results: the QC test results recorded against inventory item, lot and subinventory samples, with…
OPM Item Process and Recipe Attributes Oracle Process Manufacturing (OPM) item attributes: for every process-manufacturing-enabled item, its recipe, process-execution, quality and costing enabled…
OPM Recipe Details OPM (Process Manufacturing) recipe details combining recipe status, validity rules, preferences, formula product quantity and routing step / resource…
OPM Reconcilation OPM Reconciliation Report. Blitz Report implementation of the Oracle sql script: OPMRecon.sql Reference MOS Document: OPM Inventory Balance Reconciliation (Doc…
OPM Specifications and Test Limits Oracle Process Manufacturing (OPM) Quality specifications and test limits: every GMD specification with its version and status, the item and grade it applies…

← All Oracle EBS modules

© Enginatics GmbH