Results for “gmd_spec_tests_b_pk”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

GMD_SPEC_TESTS_B is the base table that stores OPM specification tests within the Oracle E-Business Suite Process Manufacturing Product Development module (GMD). Each row defines a single quality test attached to a product specification, capturing the analytical method, target and limit values, units of measure, tolerances, and the actions to be taken when a result falls outside specification. The table sits at the heart of the specification-management model and is referenced during quality data collection, results entry, certificate of analysis printing, and out-of-specification handling.

The metadata classifies the object heuristically as standalone under the Data Vault model, meaning it does not participate in a shared hub/link/satellite pattern from the mined foreign-key structure. It functions as a hub-like or reference entity in its own right, with its business identity anchored on the specification-and-test combination rather than on transitive relationships.

Key Information Stored

The table contains 82 documented columns. Its primary key is GMD_SPEC_TESTS_B_PK, defined on the composite of SPEC_ID (the parent specification) and TEST_ID (the test instance within that specification). A unique index GMD_SPEC_TESTS_B_U1 on (SPEC_ID, SEQ) serves as a business-key candidate that governs the display order of tests within a specification. Although the primary key is composite, TEST_ID and SEQ act as the principal business identifiers from a user perspective.

• TEST_METHOD_ID — foreign key to GMD_TEST_METHODS_B, identifying the analytical method used.
• MIN_VALUE_NUM / TARGET_VALUE_NUM / MAX_VALUE_NUM — numeric specification limits and the target result.
• MIN_VALUE_CHAR / TARGET_VALUE_CHAR / MAX_VALUE_CHAR — character-based limits for qualitative or textual results.
• TEST_QTY / TEST_UOM — sample quantity and unit of measure consumed by the test.
• OUT_OF_SPEC_ACTION — the action triggered when a result falls outside limits.
• BELOW_SPEC_MIN / ABOVE_SPEC_MIN / BELOW_SPEC_MAX / ABOVE_SPEC_MAX — tolerance bands around specification limits.
• BELOW_MIN_ACTION_CODE / ABOVE_MIN_ACTION_CODE / BELOW_MAX_ACTION_CODE / ABOVE_MAX_ACTION_CODE — disposition codes for each out-of-range condition.
• PRINT_ON_COA_IND — controls whether the test appears on the certificate of analysis.
• USE_TO_CONTROL_STEP — indicates whether the test governs a downstream process step.
• OPTIONAL_IND / EXCLUDE_IND — flags governing whether the test is mandatory or suppressed.
• DAYS / HOURS / MINUTES / SECONDS / VIABILITY_DURATION — time-based stability or viability parameters.
• ATTRIBUTE1–30 — the standard EBS descriptive flexfield segment columns for site-defined extensions.
• CREATED_BY / CREATION_DATE / LAST_UPDATED_BY / LAST_UPDATE_DATE — standard audit columns.

Common Use Cases and Queries

The most common reporting need is retrieving all tests for a given specification in display order:

SELECT TEST_ID, TEST_METHOD_ID, SEQ, TARGET_VALUE_NUM, MIN_VALUE_NUM, MAX_VALUE_NUM
FROM GMD.GMD_SPEC_TESTS_B WHERE SPEC_ID = :spec_id ORDER BY SEQ;

Quality analysts frequently filter tests flagged for certificates of analysis (PRINT_ON_COA_IND = 'Y') or those with defined out-of-spec actions. Specification maintenance screens and the OPM Quality workbench both read and write this table, so extension via the ATTRIBUTE columns should be coordinated with the underlying form logic. Cross-module reporting may join to test methods to summarize which methods dominate a product portfolio.

Related Objects

• GMD_TEST_METHODS_B — joined on TEST_METHOD_ID; provides the method definition.
• GMD_SPECIFICATIONS_B — parent specification referenced via SPEC_ID.
• GMD_SPEC_VALID_VALUES / results tables — store the actual test results recorded against each specification test.
• GMD_SPEC_TESTS_TL — translation table providing language-specific test text.
• OPM Quality APIs — the specification and results APIs that insert, update, and validate rows in this table.