Search Results qa_sampling_association




Overview
Explore in AI Chat

Overview

The QA.QA_SAMPLING_ASSOCIATION table is an Oracle E-Business Suite Quality (QA) module object that stores the association between skip lot/sampling criteria and the sampling plans applied to them. In Oracle EBS 12.1.1 and 12.2.2, this table acts as the configuration link that determines which sampling plan is used when a given sampling or skip-lot criterion is evaluated during inspection, receiving, or collection processing. Its status is VALID in the QA schema and it is documented as containing 11 columns in the 12.2.2 physical schema.

From a data-modeling perspective, ETRM metadata classifies this object heuristically as a link (Data Vault classification). This is a modeling suggestion rather than a physical implementation: the table resolves a many-to-many-style relationship between criteria, sampling plans, and collection (test) plans, and it is therefore best understood as an intersection or association entity rather than a transactional fact or a standalone hub.

Key Information Stored

The table holds the configuration records that bind criteria to plans, along with effectivity and audit columns. The most important columns are:

No separate surrogate primary key column is documented in the ETRM excerpt; the combination of the foreign keys (notably CRITERIA_ID with SAMPLING_PLAN_ID and effectivity dates) functions as the business-key candidate identifying a unique association record. The three FK columns — CRITERIA_ID, SAMPLING_PLAN_ID, and COLLECTION_PLAN_ID — are the principal join keys to related tables.

Common Use Cases and Queries

Typical usage centers on resolving which sampling plan applies to a given criterion, validating effective-dated configuration, and auditing plan usage.

  • Resolving the sampling plan for a criterion: 
    SELECT a.criteria_id, a.sampling_plan_id, a.collection_plan_id, a.effective_from, a.effective_to
FROM   qa.qa_sampling_association a
WHERE  a.criteria_id = :criteria_id
AND    SYSDATE BETWEEN a.effective_from AND NVL(a.effective_to, SYSDATE);
  • Joining to the sampling plan definition: 
    SELECT a.criteria_id, p.*
FROM   qa.qa_sampling_association a, qa.qa_sampling_plans p
WHERE  a.sampling_plan_id = p.sampling_plan_id;
  • Reporting active associations by effectivity window and workflow role for configuration audits.

Related Objects

  • QA_SL_SP_RCV_CRITERIA — joined on CRITERIA_ID; source of the skip lot/sampling/receiving criteria.
  • QA_SAMPLING_PLANS — joined on SAMPLING_PLAN_ID; the sampling plan definition.
  • QA_PLANS — joined on COLLECTION_PLAN_ID; the collection/test plan definition.
  • Additional QA inspection and receiving plan tables that consume sampling criteria during inspection creation.
  • QA workflow/notification components that reference WF_ROLE_NAME.