Results for “qa_criteria_headers”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

QA_CRITERIA_HEADERS is the header-level master table for quality criteria definitions in the Oracle Quality (QA) module of Oracle E-Business Suite 12.1.1 and 12.2.2. A row in this table defines a single named criterion — the specification against which collected quality results are evaluated within a quality plan. Because a criterion determines how result data is charted, aggregated, and compared to specification limits, this table sits at the center of the Quality module's analytical and reporting capabilities. It is owned by the QA schema and carries a VALID status in the ETRM repository.

Under a heuristic Data Vault classification derived from its foreign key structure, QA_CRITERIA_HEADERS is hub-leaning: it anchors a stable business key (the criterion identity), while downstream detail rows reference it. This should be treated as a modeling suggestion rather than a mandated design. The documented physical schema in 12.2.2 contains 24 columns.

Key Information Stored

The table's surrogate primary key is CRITERIA_ID, enforced by the index QA_CRITERIA_HEADERS_PK. Two unique indexes define business-key candidates: QA_CRITERIA_HEADERS_U1 on CRITERIA_ID alone, and QA_CRITERIA_HEADERS_U2 on the composite (ORGANIZATION_ID, NAME, OUTPUT_TYPE), which establishes that a criterion name must be unique per organization and output type.

The most significant columns are:

• CRITERIA_ID — surrogate primary key and the foreign key target for all dependent detail tables.
• NAME — the user-visible criterion name; part of the composite unique business key.
• ORGANIZATION_ID — the inventory organization that owns the criterion, providing multi-org partitioning.
• OUTPUT_TYPE — determines the output format of the criterion (for example chart or tabular output); also part of the unique business key.
• PLAN_ID — foreign key to QA_PLANS, associating the criterion with the quality plan under which it is collected.
• SPEC_ID — the specification referenced by the criterion, tying it to specification limits.
• TITLE and DESCRIPTION — descriptive text presented on reports and charts.
• CHART_TYPE, NUM_BARS, NUM_POINTS — chart rendering attributes for graphical output.
• X_AXIS_CHAR_ID, Y_AXIS_CHAR_ID, Y_AXIS_FXN — axis characteristic and function definitions used to plot collected results.
• X_AXIS_GROUP_BY_ID and TOP_N_GROUPS — grouping and ranking controls for aggregated displays.
• TARGET_VALUE_FLAG, SPEC_LIMIT_FLAG, USER_DEFINED_LIMIT_FLAG — flags controlling whether target values, specification limits, or user-defined limits are applied when evaluating results.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS audit columns.

Common Use Cases and Queries

Typical reporting scenarios include listing all criteria defined for a quality plan, auditing criteria ownership by organization, and reconciling chart configuration with actual collected results.

Criteria belonging to a plan:

• SELECT c.criteria_id, c.name, c.output_type, c.chart_type FROM qa_criteria_headers c WHERE c.plan_id = :plan_id;

Organization-scoped lookup using the business key:

• SELECT criteria_id, plan_id, spec_id FROM qa_criteria_headers WHERE organization_id = :org_id AND name = :name AND output_type = :output_type;

Joining header to control limits for specification reporting:

• SELECT h.name, l.* FROM qa_criteria_headers h, qa_control_limits l WHERE h.criteria_id = l.criteria_id AND h.organization_id = :org_id;

Related Objects

• QA_PLANS — referenced by QA_CRITERIA_HEADERS.PLAN_ID. A criterion cannot exist without an owning quality plan.
• QA_CONTROL_LIMITS — references QA_CRITERIA_HEADERS.CRITERIA_ID via QA_CONTROL_LIMITS.CRITERIA_ID, storing control limit values for the criterion.
• QA_CRITERIA — references QA_CRITERIA_HEADERS.CRITERIA_ID via QA_CRITERIA.CRITERIA_ID, carrying the per-criterion detail or collection records.
• QA_SPECIFICATIONS — referenced indirectly through SPEC_ID, supplying specification limits used when SPEC_LIMIT_FLAG is enabled.
• QA_RESULTS — stores collected quality results evaluated against the criterion; functionally dependent on the header through the QA_CRITERIA relationship.
• QA_CHARACTERISTICS — supplies the axis characteristics referenced by X_AXIS_CHAR_ID and Y_AXIS_CHAR_ID.

Because QA_CRITERIA, QA_CONTROL_LIMITS, and QA_RESULTS all depend on this header, deletes and updates to criteria must respect referential integrity to avoid orphaned quality data.