QA Quality Results – Oracle EBS SQL Report

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

Overview

One row per collection result and characteristic, so results from any number of collection plans stack in a single extract instead of one column per characteristic. Use Collection Plan like to pull a whole family of plans in one run, for example INC_MRC%.

Oracle Quality stores every element value as a string in a generic column of qa_results, and the plan’s element definition decides which column holds which characteristic. Result is therefore text. Result Number carries the numeric conversion for Number elements so the values can be charted or averaged, and Date elements arrive as YYYY/MM/DD.

Only the elements an operator fills in are listed as characteristic rows. The context elements a plan collects, being item, revision, lot, serial, subinventory, quantity, job, purchase order, supplier and customer, are columns on every row instead, so they can be filtered and pivoted without appearing as results.

Result Date is when the result was recorded. Exclude Empty Results defaults to Yes, so clear it to also list elements that are enabled on the plan but were left blank.

Report Parameters

Organization, Collection Plan, Collection Plan like, Result Date From, Result Date To, Collection Element, Item, Lot Number, Exclude Empty Results

Oracle EBS Tables Used

wip_entities, po_headers_all, po_vendors, hz_cust_accounts, hz_parties, qa_results, qa_plans, qa_plan_chars, qa_chars, mtl_parameters, mtl_system_items_vl, org_access_view

Report Categories

Enginatics

FND Attached Documents, QA Collection Plans, QP Customer Pricing Engine Request

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 QA Quality Results 18-Aug-2026 103121.xlsx
Blitz Report™ XML Import QA_Quality_Results.xml
Full SQL on Enginatics www.enginatics.com/reports/qa-quality-results/

© 2026 Enginatics