OPM Specifications and Test Limits – Oracle EBS SQL Report

Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™. Oracle EBS module: Process Manufacturing · all Process Manufacturing reports

Overview

Oracle Process Manufacturing (OPM) Quality specifications and test limits: every GMD specification with its version and status, the item and grade it applies to, and each specification test’s minimum, target and maximum limits, UOM, certificate-of-analysis print flag and report precision. The master reference for an organization’s quality standards.

Run this report in Excel in seconds: download Blitz Report™ free (your first 30 reports are free) or try it in the online demo.

Report Parameters

Organization Code, Item, Spec, Spec Status, Grade, Test

Oracle EBS Tables Used

gmd_specifications_b, gmd_specifications_tl, gmd_spec_tests_vl, gmd_qc_tests_b, gmd_qc_tests_tl, mtl_system_items_vl, org_organization_definitions, gmd_status_vl, org_access_view

Report Categories

Enginatics, R12 only

OPM Item Location Test Results, OPM Recipe Details, CAC OPM Costed Formula

Running This SQL Without Blitz Report

The SQL source can be run in any SQL client. Some Oracle EBS SQL reports in this library use functions from the utility package xxen_util – install it first. Blitz Report™ adds parameters, Excel output with pivots, scheduling and security on top.

Download & Import Options

Resource Link
Excel Example Output OPM Specifications and Test Limits 05-Jun-2026 120009.xlsx
Blitz Report™ XML Import OPM_Specifications_and_Test_Limits.xml
SQL Source OPM Specifications and Test Limits.sql
Full Report on Enginatics www.enginatics.com/reports/opm-specifications-and-test-limits/

Case Study & Technical Analysis: OPM Specifications and Test Limits

Executive Summary

This report is the master reference for quality standards in Oracle Process Manufacturing. It lists every GMD specification with its version and status, the item and grade it applies to, and each test in the specification with its minimum, target and maximum limits, unit of measure, certificate of analysis print flag and reporting precision. Quality managers, laboratory supervisors and regulatory teams use it to confirm the acceptance limits that finished and intermediate products must meet, and to compare them against the certificates of analysis issued. The report runs in Excel through Blitz Report.

Business Challenge

The Solution

Technical Architecture (High Level)

Primary Tables

Logical Relationships

  1. GMD_SPECIFICATIONS_B joins to GMD_SPECIFICATIONS_TL on specification id, restricted to the session language.
  2. GMD_SPECIFICATIONS_B joins to GMD_SPEC_TESTS_VL on specification id, and each test joins to GMD_QC_TESTS_B on test id.
  3. The test name joins to GMD_QC_TESTS_TL on test id, restricted to the session language.
  4. The specification’s item joins to MTL_SYSTEM_ITEMS_VL on inventory item id and owner organization id.
  5. The specification status joins to GMD_STATUS_VL as an outer join on the status code.

Parameters & Filtering

Performance & Optimization

FAQ

Q: Why does a test not appear on the certificate of analysis? A: The certificate includes only tests with the print flag set. The flag is shown on each row for checking.

Q: How do I find the active version of a specification? A: Filter by Spec and Spec Status, and read the version column for the status you need.

Q: Which limit is shown when a test has no numeric target? A: The character limit is shown in place of the numeric value for that limit.

© Enginatics GmbH