QA Collection Result Upload – Oracle EBS SQL Report

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

Overview

Enters and updates quality results of any collection plan, as the Enter Quality Results and Update Quality Results forms do, through the Oracle Quality results API with its element validations.

The Plan parameter selects the collection plan. The plan’s text and comment elements are shown in the columns Char1 to Char40, its number elements in Number1 to Number20 and its date elements in Date1 to Date10, each type in the plan’s prompt sequence, with the column headings showing the element prompts. Columns without an element keep their generic heading and stay empty; hide them with a template per plan.

Create, Update mode downloads the plan’s existing results. An updated row writes only the element values that were changed, and Oracle records each in the result update history.

Plans with actions, Sequence elements or Date and Time elements are not supported.

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

Upload Mode, Organization, Plan, Result Date From, Result Date To

Oracle EBS Tables Used

qa_plans, mtl_parameters, qa_results, xxen_report_org_access

Report Categories

Enginatics, R12 only, Upload

QA Quality Results, QA Collection Plans, QA Collection Plan Element Values, QA Collection Plan Actions, QA Collection Plan Relationships, QA Collection Plan Transactions, QA Collection Plan Elements, QP Customer Pricing Engine Request, FND Attached Documents

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 QA Collection Result Upload 07-Nov-2026 154548.xlsx
Blitz Report™ XML Import QA_Collection_Result_Upload.xml
SQL Source QA Collection Result Upload.sql
Full Report on Enginatics www.enginatics.com/reports/qa-collection-result-upload/

© Enginatics GmbH