Search Results gmd_results_pk

Overview

The GMD_RESULTS table is a core data repository within the Oracle Process Manufacturing (OPM) Product Development module (GMD) of Oracle E-Business Suite (EBS). It serves as the primary transactional table for storing detailed quality results generated from laboratory tests and analyses. This table is fundamental to the quality management lifecycle, capturing the empirical data that validates whether materials, intermediates, or finished goods meet predefined specifications. Its role is critical for ensuring product quality, regulatory compliance, and traceability throughout the manufacturing process.

Key Information Stored

The table's primary key, RESULT_ID, uniquely identifies each individual result record. While the full column list is not detailed in the provided metadata, based on its function, the table typically stores data points such as the actual numeric or textual value obtained from a test, the associated unit of measure, and the specific test detail or characteristic being measured. It links to sampling events and specifications through foreign keys, storing references to the sample (SAMPLE_ID), the tested specimen (SPECIMEN_ID), and the particular test requirement (TEST_ID or SPEC_DISP_ID). Additional columns commonly track the result's status, the date and time of recording, and the identity of the analyst or instrument that produced it.

Common Use Cases and Queries

The primary use case is querying and reporting on quality results for analysis and release decisions. Common queries involve retrieving all results for a specific production batch to assess overall quality, or finding results that fall outside acceptable limits (out-of-specification). A typical reporting pattern joins GMD_RESULTS to sampling and specification tables to present a complete quality record.

• Sample SQL for Batch Results: SELECT r.result_val, r.result_date FROM gmd_results r, gmd_samples s WHERE r.sample_id = s.sample_id AND s.batch_id = <batch_number>;
• Data Integration: Results are frequently extracted to data warehouses for historical quality trend analysis and statistical process control (SPC).
• Transaction Processing: The table is the target for inserts and updates from the Quality module's user interfaces and from integrated laboratory instruments via APIs.

Related Objects

The GMD_RESULTS table is central to the OPM Quality schema, with documented relationships to other key tables via its primary and foreign keys.

• Primary Key Constraint: GMD_RESULTS_PK on RESULT_ID.
• Foreign Key Relationships: The table is linked to sampling and specification entities. Common joins include:
  • GMD_SAMPLES on SAMPLE_ID to trace results back to the original sample collected.
  • GMD_SPECIFICATIONS_DISP or GMD_TEST_SPEC_DISP on a detail ID (e.g., SPEC_DISP_ID) to link the result to the specific test requirement from a quality specification.
  • GMD_SPECIMENS on SPECIMEN_ID, if the tested specimen is tracked separately from the sample.
• Dependent Objects: Various quality reports, forms (e.g., Enter Test Results), and public APIs (such as GMD_RESULTS_PUB) will query and manipulate data in this table.