Search Results qa_criteria




Overview
Explore in AI Chat

Overview

The QA_CRITERIA table is a core data object within the Oracle E-Business Suite Quality (QA) module. It functions as a repository for storing the specific "show results where" criteria definitions used by various Quality analysis and reporting tools. These criteria are the conditional rules applied to filter and evaluate quality data. The table's primary role is to support the Quality Dynamic Reportwriter and charting functionalities, enabling users to define and save complex, reusable sets of conditions for generating tailored quality reports and performance charts. It acts as a child table, storing the individual line-level conditions that collectively form a complete criteria set defined in the parent QA_CRITERIA_HEADERS table.

Key Information Stored

The table stores the building blocks of a quality data filter. Each row represents a single condition. While the full column list is not detailed in the provided metadata, the structure implies several critical fields. The CRITERIA_SEQUENCE column, part of the primary key, determines the order of evaluation for multiple conditions. The CRITERIA_ID is a foreign key linking the condition back to its parent header record in QA_CRITERIA_HEADERS. The CHAR_ID is a foreign key referencing the QA_CHARS table, which stores the definition of the specific quality characteristic (e.g., hardness, diameter, pass/fail) being evaluated. Other columns would typically store the operator (e.g., =, >, BETWEEN) and the target or comparison value for the condition against the selected characteristic.

Common Use Cases and Queries

The primary use case is the runtime execution of saved criteria sets for reporting. When a user runs a Dynamic Report or chart, the application queries this table to retrieve the list of conditions associated with the selected criteria set. A common reporting need is to audit or document configured criteria. A sample query to list all conditions for a specific criteria header would be:

  • SELECT qc.criteria_sequence, qch.name AS criteria_set, qc.char_id, qcharc.name AS characteristic_name FROM qa_criteria qc JOIN qa_criteria_headers qch ON qc.criteria_id = qch.criteria_id JOIN qa_chars qcharc ON qc.char_id = qcharc.char_id WHERE qch.name = '<CRITERIA_SET_NAME>' ORDER BY qc.criteria_sequence;

This is valuable for technical consultants validating configurations or troubleshooting report output. Developers may also query this table directly when building custom integrations or data extracts that must adhere to the same business logic as the standard Quality reports.

Related Objects

QA_CRITERIA has defined relationships with several key Quality module tables, as indicated by its foreign keys. The QA_CRITERIA_HEADERS table is its direct parent, storing the name and header-level information for each complete criteria set. The QA_CHARS table is essential, as it provides the metadata for the quality characteristic being tested in each condition row. Given its purpose, QA_CRITERIA is also fundamentally related to the core quality results tables, such as QA_RESULTS, as the criteria defined within it are applied against the data stored there. The table is central to the Quality Dynamic Reportwriter engine and charting utilities, which programmatically reference it to build dynamic SQL for data retrieval.