Search Results qa_results

Overview

The QA_RESULTS table is the central data repository for quality inspection results within the Oracle E-Business Suite Quality Management module (QA). It stores the detailed outcomes of all quality collection plan transactions performed across the enterprise, including inspections for inventory, purchasing, manufacturing, and customer returns. Its role is to persist the factual measurements, attribute checks, and decision results that determine the acceptance or rejection of materials and products, forming the core of the quality history and traceability system in Oracle EBS releases 12.1.1 and 12.2.2.

Key Information Stored

The table's structure is defined by a composite primary key consisting of COLLECTION_ID and OCCURRENCE, which uniquely identifies each inspection result record. Key columns link the result to its governing quality plan (PLAN_ID) and specification (SPEC_ID). Crucially, the table integrates with multiple EBS functional areas through foreign keys, storing references to the inspected item (ITEM_ID, ORGANIZATION_ID), work order (WIP_ENTITY_ID, WORK_ORDER_ID), supplier (VENDOR_ID, PO_RELEASE_ID), customer (CUSTOMER_ID), and resource or department (RESOURCE_ID, DEPARTMENT_ID). It also records the inspector (QA_CREATED_BY) and supports parent-child relationships between results via the QA_PC_RESULTS_RELATIONSHIP table.

Common Use Cases and Queries

Primary use cases include generating quality performance reports, analyzing defect trends, and supporting traceability inquiries. A common query retrieves all rejection results for a specific item to identify chronic quality issues. For example:

• SELECT qr.collection_id, qr.item_id, qr.last_update_date FROM qa.qa_results qr WHERE qr.item_id = :p_item_id AND qr.organization_id = :p_org_id AND EXISTS (SELECT 1 FROM qa.qa_results_char qrc WHERE qrc.collection_id = qr.collection_id AND qrc.occurrence = qr.occurrence AND qrc.result_value = 'REJECT');

Another frequent pattern joins QA_RESULTS with QA_PLANS and MTL_SYSTEM_ITEMS_B to report on inspection results by collection plan name and item number, which is foundational for supplier or manufacturing process quality scorecards.

Related Objects

QA_RESULTS has extensive relationships with core EBS tables, as documented in its foreign keys. It is directly childed to QA_PLANS and QA_SPECS. Its integration with inventory is through MTL_SYSTEM_ITEMS_B, with manufacturing via WIP_ENTITIES and BOM_RESOURCES, and with supply chain through PO_VENDORS and PO_RELEASES_ALL. The QA_PC_RESULTS_RELATIONSHIP table defines hierarchical links between result records. For detailed characteristic (QA_RESULTS_CHAR) and variable (QA_RESULTS_NUM) data, results are further expanded into child tables. Key APIs for interacting with this data include the Quality Results API and the Quality Collection Plans API.