Search Results gmd_quality_config

Overview

GMD_QUALITY_CONFIG is a configuration table in the Oracle E-Business Suite Process Manufacturing Product Development (GMD) module. It stores organization-level quality management settings that govern how Oracle Process Manufacturing (OPM) Quality handles sampling, specifications, lot status transitions, and laboratory interactions. In Oracle EBS 12.1.1 and 12.2.2 it is classified as a standalone object in the GMD schema with a documented physical schema of 38 columns.

From a Data Vault modeling perspective, the metadata suggests this object behaves as a hub rather than a link or satellite. Its primary key GMD_QUALITY_CONFIG_PK is defined on ORGANIZATION_ID, and a unique index GMD_QUALITY_CONFIG_U1 is defined on ORGN_CODE, reinforcing that the table represents a single configuration record per organization rather than a transactional or relationship entity. The heuristic classification of "standalone" indicates there are no outbound foreign keys documented, so the table can be modeled independently.

Key Information Stored

The table centers on the ORGANIZATION_ID surrogate key (GMD_QUALITY_CONFIG_PK) and the ORGN_CODE business-key candidate (GMD_QUALITY_CONFIG_U1). The most operationally significant columns include:

IN_SPEC_LOT_STATUS / IN_SPEC_LOT_STATUS_ID and OUT_OF_SPEC_LOT_STATUS / OUT_OF_SPEC_LOT_STATUS_ID — define the default inventory lot statuses applied when quality results pass or fail specification.
CONTROL_BATCH_STEP_IND and CONTROL_LOT_ATTRIB_IND — control whether batch steps and lot attributes are subject to quality control.
AUTO_SAMPLE_IND, SAMPLE_ASSIGNMENT_TYPE, and SAMPLE_LAST_ASSIGNED — govern automatic sample creation, assignment method, and the last sample assignment counter.
SS_ASSIGNMENT_TYPE and SS_LAST_ASSIGNED — manage stability study sample assignment behavior.
CHOOSE_SPEC, EXACT_SPEC_MATCH_IND, SPEC_VERSION_CONTROL_IND, and DEFAULT_SPECIFICATION_STATUS — dictate specification selection, matching, versioning, and default status.
RESAMPLE_ACTION_CODE and RETEST_ACTION_CODE — specify the actions triggered by resample and retest events.
QUALITY_LAB_IND, SAMPLE_INV_TRANS_IND, and INV_TRANS_REASON_CODE — indicate laboratory integration and inventory transaction behavior for samples.
MANAGE_VALIDITY_RULES_IND, AUTO_COMPLETE_BATCH_STEP, and DELAYED_LOT_ENTRY — govern validity rule enforcement, batch-step auto-completion, and delayed lot entry.

Audit columns such as CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, and LAST_UPDATE_LOGIN follow standard EBS conventions. MIGRATED_IND identifies records originating from migration.

Common Use Cases and Queries

Typical reporting scenarios include verifying quality configuration consistency across organizations, troubleshooting why a lot received a particular status, and auditing specification control settings. A basic query retrieves settings for one organization:

SELECT ORGN_CODE, IN_SPEC_LOT_STATUS, OUT_OF_SPEC_LOT_STATUS, AUTO_SAMPLE_IND, CHOOSE_SPEC FROM GMD.GMD_QUALITY_CONFIG WHERE ORGN_CODE = :orgn_code;
Cross-organization comparison: join to ORG_ORGANIZATION_DEFINITIONS on ORGANIZATION_ID to map configuration to organization names.
Audit of changes: filter on LAST_UPDATE_DATE and LAST_UPDATED_BY to detect recent configuration modifications.
Migration validation: SELECT * FROM GMD_QUALITY_CONFIG WHERE MIGRATED_IND = 'Y';

Related Objects

Although the metadata classifies this table as standalone with no documented foreign keys, functional dependencies exist with the following objects:

ORG_ORGANIZATION_DEFINITIONS — joined on ORGANIZATION_ID to resolve organization context.
GMD_SPECIFICATIONS — depends on configuration for specification selection and version control.
GMD_SAMPLES — driven by SAMPLE_ASSIGNMENT_TYPE and AUTO_SAMPLE_IND settings.
GMD_QUALITY_RESULTS — lot status assignment relies on IN_SPEC and OUT_OF_SPEC status settings.
MTL_LOT_NUMBERS / MTL_ONHAND_QUANTITIES — inventory lot status updates follow configured statuses.
GMD_STABILITY_STUDIES — stability sample assignment uses SS_ASSIGNMENT_TYPE.
INV_TRANSACTION_REASONS — referenced via INV_TRANS_REASON_CODE and TRANSACTION_REASON_ID.

Consult the OPM Product Development documentation for the current column-level semantics in 12.2.2.

Table: GMD_QUALITY_CONFIG 12.2.2
owner:GMD, object_type:TABLE, fnd_design_data:GMD.GMD_QUALITY_CONFIG, object_name:GMD_QUALITY_CONFIG, status:VALID, product: GMD - Process Manufacturing Product Development , description: OPM Quality Configuration , implementation_dba_data: GMD.GMD_QUALITY_CONFIG ,
Table: GMD_QUALITY_CONFIG 12.1.1
owner:GMD, object_type:TABLE, fnd_design_data:GMD.GMD_QUALITY_CONFIG, object_name:GMD_QUALITY_CONFIG, status:VALID, product: GMD - Process Manufacturing Product Development , description: OPM Quality Configuration , implementation_dba_data: GMD.GMD_QUALITY_CONFIG ,
APPS.GMD_QUALITY_PARAMETERS_GRP SQL Statements 12.2.2
APPS.GMD_QUALITY_PARAMETERS_GRP SQL Statements 12.1.1
PACKAGE BODY: APPS.GMD_QUALITY_PARAMETERS_GRP 12.2.2
PACKAGE BODY: APPS.GMD_QUALITY_PARAMETERS_GRP 12.1.1
VIEW: GMD.GMD_QUALITY_CONFIG# 12.2.2
owner:GMD, object_type:VIEW, object_name:GMD_QUALITY_CONFIG#, status:VALID,
SYNONYM: APPS.GMD_QUALITY_CONFIG 12.1.1
owner:APPS, object_type:SYNONYM, object_name:GMD_QUALITY_CONFIG, status:VALID,
SYNONYM: APPS.GMD_QUALITY_CONFIG 12.2.2
owner:APPS, object_type:SYNONYM, object_name:GMD_QUALITY_CONFIG, status:VALID,
VIEW: GMD.GMD_QUALITY_CONFIG# 12.2.2
PACKAGE BODY: APPS.GMD_QUALITY_PARAMETERS_GRP 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:GMD_QUALITY_PARAMETERS_GRP, status:VALID,
PACKAGE BODY: APPS.GMD_QUALITY_PARAMETERS_GRP 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:GMD_QUALITY_PARAMETERS_GRP, status:VALID,
PACKAGE: APPS.GMD_QUALITY_PARAMETERS_GRP 12.1.1
owner:APPS, object_type:PACKAGE, object_name:GMD_QUALITY_PARAMETERS_GRP, status:VALID,
PACKAGE: APPS.GMD_QUALITY_PARAMETERS_GRP 12.2.2
owner:APPS, object_type:PACKAGE, object_name:GMD_QUALITY_PARAMETERS_GRP, status:VALID,
APPS.GMD_QC_MIG12 SQL Statements 12.1.1
PACKAGE BODY: APPS.GMD_RESULTS_PUB 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:GMD_RESULTS_PUB, status:VALID,
PACKAGE BODY: APPS.GMD_STABILITY_STUDIES_GRP 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:GMD_STABILITY_STUDIES_GRP, status:VALID,
APPS.GMD_QC_MIG12 SQL Statements 12.2.2
PACKAGE BODY: APPS.GMD_STABILITY_STUDIES_GRP 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:GMD_STABILITY_STUDIES_GRP, status:VALID,
PACKAGE BODY: APPS.GMD_DISP_PUB 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:GMD_DISP_PUB, status:VALID,
PACKAGE BODY: APPS.GMD_QC_MIG12 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:GMD_QC_MIG12, status:VALID,
TABLE: GMD.GMD_QUALITY_CONFIG 12.1.1
owner:GMD, object_type:TABLE, fnd_design_data:GMD.GMD_QUALITY_CONFIG, object_name:GMD_QUALITY_CONFIG, status:VALID,
PACKAGE BODY: APPS.GMD_QC_MIG12 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:GMD_QC_MIG12, status:VALID,
PACKAGE BODY: APPS.GMD_RESULT_TRANSFER_GRP 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:GMD_RESULT_TRANSFER_GRP, status:VALID,
PACKAGE: APPS.GMD_QUALITY_PARAMETERS_GRP 12.1.1
PACKAGE BODY: APPS.GMD_QM_CONC_REPLACE_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:GMD_QM_CONC_REPLACE_PKG, status:VALID,
PACKAGE BODY: APPS.GMD_RESULT_TRANSFER_GRP 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:GMD_RESULT_TRANSFER_GRP, status:VALID,
PACKAGE BODY: APPS.GMD_QM_CONC_REPLACE_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:GMD_QM_CONC_REPLACE_PKG, status:VALID,
PACKAGE BODY: APPS.GMD_SAMPLES_PUB 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:GMD_SAMPLES_PUB, status:VALID,
12.2.2 DBA Data 12.2.2
12.1.1 DBA Data 12.1.1
PACKAGE BODY: APPS.GMD_QMSMC 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:GMD_QMSMC, status:VALID,
PACKAGE BODY: APPS.GMD_QMSMC 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:GMD_QMSMC, status:VALID,
TABLE: GMD.GMD_QUALITY_CONFIG 12.2.2
owner:GMD, object_type:TABLE, fnd_design_data:GMD.GMD_QUALITY_CONFIG, object_name:GMD_QUALITY_CONFIG, status:VALID,
PACKAGE BODY: APPS.GMD_SAMPLES_PUB 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:GMD_SAMPLES_PUB, status:VALID,
PACKAGE: APPS.GMD_QUALITY_PARAMETERS_GRP 12.2.2
12.2.2 DBA Data 12.2.2
PACKAGE BODY: APPS.GMD_RESULTS_GRP 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:GMD_RESULTS_GRP, status:VALID,
12.2.2 DBA Data 12.2.2
PACKAGE BODY: APPS.GMD_RESULTS_GRP 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:GMD_RESULTS_GRP, status:VALID,
PACKAGE BODY: APPS.GMD_SAMPLES_GRP 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:GMD_SAMPLES_GRP, status:VALID,
PACKAGE BODY: APPS.GMD_SAMPLES_GRP 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:GMD_SAMPLES_GRP, status:VALID,
12.2.2 DBA Data 12.2.2
12.1.1 DBA Data 12.1.1
12.1.1 FND Design Data 12.1.1
12.2.2 FND Design Data 12.2.2
12.1.1 DBA Data 12.1.1
12.2.2 DBA Data 12.2.2
APPS.GMD_RESULTS_GRP SQL Statements 12.2.2
APPS.GMD_SAMPLES_PUB SQL Statements 12.1.1