OPM Formula Details – Oracle EBS SQL Report

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

Overview

Oracle Process Manufacturing (OPM) Product Development formula details: the ingredient, product and by-product lines of each formula with quantities, UOM, scrap factor, scaling type, planned product percentage and yield contribution. Supports formulation review and data quality checks.

Report Parameters

Organization Code, Formula, Item, Formula Status, Line Type

Oracle EBS Tables Used

fm_form_mst, fm_matl_dtl, mtl_system_items_vl, org_organization_definitions, gmd_status_vl, gem_lookups, org_access_view

Report Categories

Enginatics

Related Reports

CAC OPM Costed Formula, OPM Formula Where-Used, OPM Formula Upload, OPM Recipe Upload, OPM Recipe Details

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 Formula Details 05-Jun-2026 120001.xlsx
Blitz Report™ XML Import	OPM_Formula_Details.xml
Full SQL on Enginatics	www.enginatics.com/reports/opm-formula-details/

---

Useful Links

• Blitz Report™ – World’s Fastest Oracle EBS Reporting Tool
• Oracle Discoverer Replacement – Import Worksheets into Blitz Report™
• Oracle EBS Reporting Toolkits by Blitz Report™
• Blitz Report™ FAQ & Community Q&A
• Supply Chain Hub by Blitz Report™
• Blitz Report™ Customer Case Studies
• Oracle EBS Reporting Blog
• Oracle EBS Reporting Resource Centre

© 2026 Enginatics