Search Results qa_sampling_plans_u1

Overview

QA.QA_SAMPLING_PLANS is a master (header) table in the Oracle E-Business Suite Quality Management schema. It defines the reusable sampling plans that drive inspection, acceptance, and quality-monitoring activities across the enterprise. Each row describes a named sampling plan, the inspection level, the sampling standard against which it is evaluated, and the associated Acceptable Quality Level (AQL). These plans are consumed by inspection specifications, monitoring specifications, sampling events, and specification versioning tables in both the QA and GMD (Process Manufacturing) product families.

From a Data Vault modeling perspective, the documented foreign-key profile classifies this object as hub-leaning. The table holds a stable, uniquely identified business concept — the sampling plan — referenced by numerous downstream satellites and transactional tables, which is characteristic of a hub entity. This classification is a heuristic suggestion derived from the FK structure rather than a mandated physical design.

Key Information Stored

The table is owner-qualified as QA and resides in the APPS_TS_TX_DATA tablespace with a PCT Free of 10. Its storage characteristics and column set are unchanged between EBS 12.1.1 and 12.2.2.

• SAMPLING_PLAN_ID — NUMBER, primary key. This is the surrogate identifier for the plan and is the column propagated to all dependent tables.
• SAMPLING_PLAN_CODE — VARCHAR2(30). The business-key candidate enforced by unique index QA_SAMPLING_PLANS_U2; user-facing identifier for the sampling plan.
• DESCRIPTION — VARCHAR2(240). Free-text description of the sampling plan.
• ORGANIZATION_ID — NUMBER. Organization (inventory/operating unit) context for the plan.
• INSP_LEVEL_CODE — VARCHAR2. The inspection level (e.g., tightened, normal, reduced) applied when the plan executes.
• SAMPLING_STD_CODE — NUMBER. The sampling standard referenced by the plan.
• AQL — NUMBER. The Acceptable Quality Level threshold used for acceptance decisions.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — the standard WHO audit columns tracking who created and last modified each row.

Two unique indexes are documented: QA_SAMPLING_PLANS_U1 on SAMPLING_PLAN_ID and QA_SAMPLING_PLANS_U2 on SAMPLING_PLAN_CODE, both stored in the APPS_TS_TX_IDX tablespace.

Common Use Cases and Queries

Sampling plans are typically queried during inspection setup, quality reporting, and specification maintenance. A common validation pattern is to resolve the plan code to its surrogate key:

• Listing active plans for an organization: SELECT SAMPLING_PLAN_CODE, DESCRIPTION, AQL, INSP_LEVEL_CODE FROM QA.QA_SAMPLING_PLANS WHERE ORGANIZATION_ID = :org_id;
• Looking up a plan by business key: SELECT SAMPLING_PLAN_ID, AQL FROM QA.QA_SAMPLING_PLANS WHERE SAMPLING_PLAN_CODE = :plan_code;
• Reporting on audit activity: SELECT SAMPLING_PLAN_CODE, LAST_UPDATED_BY, LAST_UPDATE_DATE FROM QA.QA_SAMPLING_PLANS ORDER BY LAST_UPDATE_DATE DESC;
• Joining to dependent specifications (e.g., GMD_INVENTORY_SPEC_VRS) on SAMPLING_PLAN_ID to report which inventory items are governed by a given AQL.

Related Objects

The table is referenced by numerous downstream objects; the most significant include:

• QA_SAMPLING_ASSOCIATION and QA_SAMPLING_CUSTOM_RULES — join on SAMPLING_PLAN_ID to link plans to associations and custom rules.
• GMD_MONITORING_SPEC_VRS, GMD_CUSTOMER_SPEC_VRS, GMD_SUPPLIER_SPEC_VRS, GMD_WIP_SPEC_VRS, GMD_INVENTORY_SPEC_VRS, and GMD_STABILITY_SPEC_VRS — specification version tables that reference the plan via SAMPLING_PLAN_ID.
• GMD_SAMPLING_EVENTS — transactional sampling events associated with the plan.
• GMD_SAMPLING_PLANS_B and GMD_SAMPLING_PLANS_TL — base and translation tables in the GMD schema.

QA_SAMPLING_PLANS does not reference any database object itself, confirming its role as a foundational hub table within the quality management data model.