Search Results gmd_spec_tests_b

Overview

The GMD_SPEC_TESTS_B table is a core data object within the Oracle Process Manufacturing (OPM) product development module (GMD) of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. It serves as the primary transactional table for storing the individual test criteria that constitute a product or process specification. A specification in OPM defines the quality standards and analytical requirements for raw materials, intermediates, and finished goods. This table is fundamental to the quality management lifecycle, linking specific test methods, target values, and tolerances to a master specification document, thereby enabling systematic quality control and compliance.

Key Information Stored

The table's structure is designed to capture the essential attributes of each test within a specification. The documented primary key consists of TEST_ID and SPEC_ID, indicating a composite key that uniquely identifies a test record within the context of its parent specification. While the full column list is not detailed in the provided metadata, standard columns in such a table typically include fields for the test sequence or order, the test code or method (often linked to a master test table), target value, upper and lower specification limits (USL/LSL), units of measure, and criticality indicators. The SPEC_ID column is the foreign key linking back to the parent specification header table.

Common Use Cases and Queries

This table is central to quality-related operations and reporting. Common use cases include the generation of Certificate of Analysis (COA) documents, the configuration of quality test plans for batches, and compliance reporting. Application users typically interact with this data through the Oracle Forms interface for defining and maintaining specifications. For technical analysis, common SQL queries involve joining this table to the specification header and test master tables to list all tests for a given product or material. A fundamental reporting query pattern is:

• SELECT s.spec_name, t.test_code, st.target_value, st.lower_spec_limit, st.upper_spec_limit FROM gmd_spec_tests_b st, gmd_specifications_b s, gmd_tests_b t WHERE st.spec_id = s.spec_id AND st.test_id = t.test_id AND s.spec_name = '<SPEC_NAME>' ORDER BY st.test_sequence;

This retrieves the complete test profile for a specified quality standard.

Related Objects

As indicated by its primary key and description, GMD_SPEC_TESTS_B is a child table with critical relationships to other GMD entities. The SPEC_ID column is a foreign key to the specification header table, GMD_SPECIFICATIONS_B. The TEST_ID column is a foreign key to the master test definition table, GMD_TESTS_B. The primary key constraint GMD_SPEC_TESTS_B_PK enforces the uniqueness of the TEST_ID and SPEC_ID combination. This table is also referenced by various views and likely has child tables itself (such as those storing test results or historical data) that link via the SPEC_ID and TEST_ID columns to uniquely identify the test criterion for which results are being recorded.