Search Results gmd_test_classes_b_pk




Overview
Explore in AI Chat

Overview

GMD_TEST_CLASSES_B is the foundational base table in the Oracle Process Manufacturing (OPM) Product Development module that stores Quality Test Classes. In the Oracle E-Business Suite 12.1.1 and 12.2.2 environments, this table belongs to the GMD schema and functions as the master repository for classifying quality tests used in laboratory and manufacturing quality control processes. Test classes provide the highest-level grouping for quality tests, allowing organizations to logically organize analytical procedures, physical tests, and specification criteria into meaningful categories such as raw material tests, finished goods tests, or in-process checks.

From a Data Vault modeling perspective, the heuristic classification derived from the foreign key structure identifies this object as a standalone table. This suggests it operates as an independent reference entity or hub-like structure with no direct parent dependency in the mined FK relationships, containing descriptive attributes that could alternatively be modeled as a satellite of the test class business key.

Key Information Stored

The table is physically documented with 40 columns in ETRM 12.2.2, of which the following are most operationally significant:

  • TEST_CLASS — The surrogate primary key (GMD_TEST_CLASSES_B_PK) and the unique business-key candidate. This column uniquely identifies each quality test class.
  • TEXT_CODE — A short textual code used for display or translation lookups, typically joined to the FND_LOOKUPS or translation tables.
  • TEST_GROUP_ENABLED — A flag indicating whether test groups are permitted under this class, controlling hierarchical test organization.
  • DELETE_MARK — The soft-delete indicator (0 = active, 1 = logically deleted) used throughout OPM tables to preserve referential integrity.
  • ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE30 — The descriptive flexfield (DFF) columns enabling customer-specific extensions without schema modification.
  • CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard WHO audit columns tracking record provenance and modification history.

The single unique index, GMD_TEST_CLASSES_B_PK on TEST_CLASS, confirms that no natural business key beyond TEST_CLASS itself is enforced at the database level.

Common Use Cases and Queries

Typical scenarios include reporting active test classes for laboratory configuration, populating LOVs in OPM Quality forms, and joining test classes to their associated test definitions.

  • Active test class listing: SELECT TEST_CLASS, TEXT_CODE FROM GMD_TEST_CLASSES_B WHERE DELETE_MARK = 0;
  • Test group eligibility reporting: SELECT TEST_CLASS FROM GMD_TEST_CLASSES_B WHERE TEST_GROUP_ENABLED = 1 AND DELETE_MARK = 0;
  • Audit and change tracking: query on LAST_UPDATE_DATE for records modified within a period, joined to FND_USER on LAST_UPDATED_BY.
  • Concurrent program validation or data conversion scripts that import test class masters from legacy LIMS systems.

Related Objects

The most significant dependent and referencing objects include:

  • GMD_TEST_CLASSES_TL — Translation table joined on TEST_CLASS for multilingual descriptions.
  • GMD_TESTS_B — Parent of individual quality test definitions, joined via TEST_CLASS.
  • GMD_TEST_GROUPS_B — Test group headers linked through the enabled TEST_GROUP_ENABLED relationship.
  • GMD_SPEC_TESTS_B — Specification test lines referencing the test class.
  • GMD_QC_TESTS_B — Quality control test definitions associated with the class.
  • FND_LOOKUPS — Joined on TEXT_CODE for display value retrieval.
  • FND_USER — Audit joins on CREATED_BY, LAST_UPDATED_BY.
  • GMD_TEST_CLASSES_B_PK — The unique index enforcing the primary key.