Search Results assay_value




Overview
Explore in AI Chat

Overview

The GMD_TEST_VALUES_B table is a core data object within the Process Manufacturing Product Development (GMD) module of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It functions as the master table for storing the discrete, pre-defined values associated with quality control tests. This table is essential for defining the valid, specific outcomes for a test, such as "Pass"/"Fail" for a qualitative test or a set of numeric ranges for a quantitative test. It provides the foundational data against which actual sample results are validated, ensuring consistency and adherence to defined quality specifications across the manufacturing process.

Key Information Stored

The table's primary purpose is to define allowable test values. Its key columns, as indicated by the primary and unique keys, are critical for this function. The primary identifier is QCASSY_VAL_ID. The unique key constraint highlights the combination of ORGN_CODE (organization), ASSAY_CODE (the test code), ASSAY_VALUE (the discrete value, e.g., 'PASS'), and VALUE_NUM_MIN (the minimum numeric bound for a range) as a unique entity. This structure allows for the definition of both discrete text values and numeric ranges. Foreign key relationships, such as QCASSY_TYP_ID linking to GMD_TESTS_B and TEXT_CODE linking to QC_TEXT_HDR, integrate these values with the master test definitions and descriptive text modules, respectively.

Common Use Cases and Queries

A primary use case is the setup and maintenance of quality specifications. Analysts populate this table to define the list of acceptable results for a given test. Common reporting and validation queries involve retrieving all valid values for a specific test to populate LOVs in transaction forms or to validate incoming results. A typical query pattern would be:

  • SELECT assay_value, value_num_min, value_num_max FROM gmd_test_values_b WHERE orgn_code = :p_org AND assay_code = :p_test_code ORDER BY value_num_min;

This data is also fundamental for queries that compare actual sample results from transaction tables against the master list of valid values to identify outliers or non-conformances.

Related Objects

GMD_TEST_VALUES_B sits at the center of a key data model for quality tests. Its most direct relationship is with the GMD_TESTS_B table, which holds the master definition of the test itself via the QCASSY_TYP_ID foreign key. The link to QC_TEXT_HDR via TEXT_CODE associates longer descriptive text with a test value. In practice, this base table is frequently accessed through higher-level application programming interfaces (APIs) and user interface forms within the Quality Management suite. Transaction tables that store actual results, such as those related to sampling and specifications, will reference the valid values defined here to enforce data integrity.