Search Results qa_criteria_headers




Overview
Explore in AI Chat

Overview

The QA_CRITERIA_HEADERS table is a core data object within the Oracle E-Business Suite Quality (QA) module, serving as the primary header or master table for quality criteria. In the context of Oracle EBS 12.1.1 and 12.2.2, it functions as the central repository for defining the high-level attributes and control parameters of a quality criteria set. A criteria set is a fundamental building block used to establish the standards, specifications, and acceptance rules for inspecting items, processes, or transactions. The table's role is to provide a unique identifier and administrative control for these criteria, which are then detailed in related child tables. It is integral to the configuration and execution of quality plans and collection plans, enabling systematic quality management across manufacturing, procurement, and other business operations.

Key Information Stored

While the provided ETRM excerpt does not list specific columns, the documented primary and foreign key relationships reveal the essential data stored. The primary key, CRITERIA_ID, is the unique identifier for each criteria header record. A critical foreign key is PLAN_ID, which links the criteria set to a specific quality plan defined in the QA_PLANS table, establishing the criteria's operational context. Other columns typically found in this table, based on standard EBS design patterns, would include creation and last update dates, the user who created the criteria, and potentially fields for the criteria name, description, status (e.g., Active, Inactive), and an effective date range. The table acts as an anchor, storing the minimal but critical header information needed to manage and reference a complete criteria definition.

Common Use Cases and Queries

This table is primarily accessed for setup, reporting, and integration purposes. A common administrative task is querying all criteria headers associated with a specific quality plan to review or audit inspection standards. For example: SELECT criteria_id FROM qa_criteria_headers WHERE plan_id = <plan_id>;. In reporting scenarios, analysts often join this table to QA_PLANS and transactional quality results tables to generate summaries of which criteria are applied across different plans or organizations. Another key use case is during the development of custom integrations or extensions, where the CRITERIA_ID from this table is required to uniquely identify a criteria set when posting inspection results from external systems via APIs or direct data loads. Queries against this table are foundational for any data extraction related to the definitional aspects of quality control.

Related Objects

The QA_CRITERIA_HEADERS table maintains documented foreign key relationships with several other core Quality tables, forming a critical part of the data model.

  • QA_PLANS: The table is linked to QA_PLANS via the QA_CRITERIA_HEADERS.PLAN_ID column. This relationship ties a criteria set to its parent quality plan.
  • QA_CRITERIA: The table has a one-to-many relationship with QA_CRITERIA, linked by QA_CRITERIA.CRITERIA_ID. This is the primary child table where the detailed specification lines for the criteria are stored.
  • QA_CONTROL_LIMITS: The table is referenced by QA_CONTROL_LIMITS via the QA_CONTROL_LIMITS.CRITERIA_ID column. This relationship associates statistical process control (SPC) limit definitions with a specific criteria header.

These relationships underscore that QA_CRITERIA_HEADERS is a master table, with its CRITERIA_ID column propagated to dependent tables to define detailed specifications and control limits.

  • Table: QA_CRITERIA_HEADERS 12.2.2

    owner:QA,  object_type:TABLE,  fnd_design_data:QA.QA_CRITERIA_HEADERS,  object_name:QA_CRITERIA_HEADERS,  status:VALID,  product: QA - Quality ,  description: Header table for Criterias ,  implementation_dba_data: QA.QA_CRITERIA_HEADERS , 

  • Table: QA_CRITERIA_HEADERS 12.1.1

    owner:QA,  object_type:TABLE,  fnd_design_data:QA.QA_CRITERIA_HEADERS,  object_name:QA_CRITERIA_HEADERS,  status:VALID,  product: QA - Quality ,  description: Header table for Criterias ,  implementation_dba_data: QA.QA_CRITERIA_HEADERS , 

  • Table: QA_CONTROL_LIMITS 12.1.1

    owner:QA,  object_type:TABLE,  fnd_design_data:QA.QA_CONTROL_LIMITS,  object_name:QA_CONTROL_LIMITS,  status:VALID,  product: QA - Quality ,  description: Stores control limits for charts ,  implementation_dba_data: QA.QA_CONTROL_LIMITS , 

  • Table: QA_CONTROL_LIMITS 12.2.2

    owner:QA,  object_type:TABLE,  fnd_design_data:QA.QA_CONTROL_LIMITS,  object_name:QA_CONTROL_LIMITS,  status:VALID,  product: QA - Quality ,  description: Stores control limits for charts ,  implementation_dba_data: QA.QA_CONTROL_LIMITS , 

  • Table: QA_CRITERIA 12.2.2

    owner:QA,  object_type:TABLE,  fnd_design_data:QA.QA_CRITERIA,  object_name:QA_CRITERIA,  status:VALID,  product: QA - Quality ,  description: Stores "show results where" criteria for chart, Quality Dynamic Reportwriter etc. ,  implementation_dba_data: QA.QA_CRITERIA , 

  • Table: QA_CRITERIA 12.1.1

    owner:QA,  object_type:TABLE,  fnd_design_data:QA.QA_CRITERIA,  object_name:QA_CRITERIA,  status:VALID,  product: QA - Quality ,  description: Stores "show results where" criteria for chart, Quality Dynamic Reportwriter etc. ,  implementation_dba_data: QA.QA_CRITERIA , 

  • Table: QA_PLANS 12.1.1

    owner:QA,  object_type:TABLE,  fnd_design_data:QA.QA_PLANS,  object_name:QA_PLANS,  status:VALID,  product: QA - Quality ,  description: Collection plan definitions ,  implementation_dba_data: QA.QA_PLANS , 

  • Table: QA_PLANS 12.2.2

    owner:QA,  object_type:TABLE,  fnd_design_data:QA.QA_PLANS,  object_name:QA_PLANS,  status:VALID,  product: QA - Quality ,  description: Collection plan definitions ,  implementation_dba_data: QA.QA_PLANS , 

  • View: QA_CRITERIA_HEADERS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:QA.QA_CRITERIA_HEADERS_V,  object_name:QA_CRITERIA_HEADERS_V,  status:VALID,  product: QA - Quality ,  description: Shows chart and Quality Dynamic Reportwriter settings ,  implementation_dba_data: APPS.QA_CRITERIA_HEADERS_V , 

  • View: QA_CRITERIA_HEADERS_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:QA.QA_CRITERIA_HEADERS_V,  object_name:QA_CRITERIA_HEADERS_V,  status:VALID,  product: QA - Quality ,  description: Shows chart and Quality Dynamic Reportwriter settings ,  implementation_dba_data: APPS.QA_CRITERIA_HEADERS_V ,