Search Results test_group_enabled

Overview

GMD_TEST_CLASSES_VL is a seeded, VALID view owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It belongs to the GMD product family, Process Manufacturing Product Development, and exposes OPM Quality Test Classes. The object name carries the _VL suffix, which in Oracle Application Object Library conventions denotes a "validated language" or translation-aware view. Such views join a base (non-translated) table to its translation table and filter the translation rows by the session language, so that callers see a single row per business key with the description text appropriate to their locale.

In that role, GMD_TEST_CLASSES_VL is the primary lookup surface for quality test class definitions. Quality test classes are the configurable groupings used to organize the individual tests that make up an OPM quality specification. Rather than querying the base and translation tables separately, application forms, concurrent programs, reports, and integration interfaces can select from this view to obtain the test class code and its translated description in one pass. This makes it the standard read interface for the test_class_desc value that users search for when building queries or reports around quality specifications.

Underlying Base Objects

The view is documented as being defined over two synonyms: GMD_TEST_CLASSES_B, the base table holding the language-independent definition of each test class, and GMD_TEST_CLASSES_TL, the translation table holding language-specific descriptive text. The view text confirms this structure. The SELECT list draws business columns — TEST_CLASS, DELETE_MARK, TEXT_CODE, the standard WHO audit columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN) and ATTRIBUTE_CATEGORY plus ATTRIBUTE1 through ATTRIBUTE30 — from the B (base) alias, while TEST_CLASS_DESC is taken from the T (translation) alias. A ROW_ID column is also exposed, derived as B.ROWID, giving consumers a pseudo-row identifier.

The join predicate is B.TEST_CLASS = T.TEST_CLASS combined with T.LANGUAGE = USERENV('LANG'). The language filter is the defining characteristic of the _VL pattern: it constrains the translation table to the language of the current database session, so the view presents exactly one descriptive row per test class. Because the view is a join, it is not directly updatable; insert, update, and delete operations against test class definitions must target the underlying B and TL tables through the supported forms or APIs.

Key Columns

• TEST_CLASS — The unique, language-independent code identifying a quality test class. This is the primary business key and the column joined between the two base objects.
• TEST_CLASS_DESC — The translated description of the test class. This is the column most commonly referenced by user queries and the object of the documented search term "test_class_desc".
• TEST_GROUP_ENABLED — A flag indicating whether the test class is enabled for grouping, which governs how tests assigned to the class are treated within a specification.
• DELETE_MARK — The standard Oracle soft-delete indicator; rows where this value is set represent logically removed records and should normally be excluded.
• TEXT_CODE — The text code associated with the test class record.
• ROW_ID — The ROWID of the underlying base table row, supplied as a unique identifier for the view row.
• WHO and DFF columns — CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, ATTRIBUTE_CATEGORY, and ATTRIBUTE1–30 expose the standard audit trail and descriptive flexfield context for the definition.

Common Use Cases and Queries

Typical uses include populating LOVs and parameter lists in custom reports, validating test class codes during data migration or interface loads, and joining test class descriptions to quality test and specification data. A basic lookup query is:

• SELECT test_class, test_class_desc FROM apps.gmd_test_classes_vl WHERE delete_mark = 0 ORDER BY test_class_desc;
• SELECT test_class, test_class_desc, test_group_enabled FROM apps.gmd_test_classes_vl WHERE delete_mark = 0 AND test_class = :p_test_class;
• SELECT t.test_class, c.test_class_desc FROM apps.gmd_tests_b t, apps.gmd_test_classes_vl c WHERE t.test_class = c.test_class AND c.delete_mark = 0;

Because the view applies the USERENV('LANG') filter, reports intended for a specific locale should be executed in a session whose language is set accordingly, ensuring that TEST_CLASS_DESC returns the expected translated value.