QA Collection Plan Elements – Oracle EBS SQL Report

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

Overview

Every collection element assigned to an Oracle Quality collection plan, with the element’s prompt and sequence on the plan, its element type, datatype, display length, decimal precision and unit of measure, the plan level and element level default values, and the Mandatory, Enabled, Displayed, Read Only, Information and Poplist flags. Collection plans that have no elements are listed too.

Oracle Quality stores every collection result generically in qa_results, whose character1 to character100 columns carry no meaning of their own: the element to column mapping is held per plan in qa_plan_chars.result_column_name, and each plan gets its own dynamically generated results view. This report exposes that mapping as the Result Column, shown verbatim next to the element’s native Hardcoded Column so that a divergence between the two is visible at a glance. It also shows the Context Element classification, which separates a quality characteristic the operator enters from predefined reference information captured automatically from the transaction, and all three validation sources an element can use: a validation table with its additional where clause, a SQL validation string, and the number of plan level values the element offers. Use it to document or audit a Quality setup, and as the specification when building an interface or an upload that writes collection results.

Filter with the optional Organization, Collection Plan, Plan Type, Collection Element and Element Type parameters, or set Enabled Elements Only to Yes to hide elements that are disabled on the plan. Leaving Organization blank returns every collection plan the responsibility has inventory organization access to, plus the seeded template plans, which are not owned by an inventory organization and therefore show a blank Organization Code.

Report Parameters

Organization, Collection Plan, Plan Type, Collection Element, Element Type, Enabled Elements Only

Oracle EBS Tables Used

mtl_units_of_measure_vl, qa_plan_char_value_lookups, qa_plans, mtl_parameters, qa_plan_chars, qa_chars, org_access_view

Report Categories

Enginatics

QA Collection Plan Element Values, QA Collection Plans, QA Quality Results, QA Collection Plan Transactions, QA Collection Plan Actions, QA Collection Plan Relationships, QA Collection Plan Upload, QA Plan Relationship Upload

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 Collection Plan Elements 14-Aug-2026 071547.xlsx
Blitz Report™ XML Import QA_Collection_Plan_Elements.xml
Full SQL on Enginatics www.enginatics.com/reports/qa-collection-plan-elements/

© 2026 Enginatics