Search Results gmd_tech_parameters_b

Overview

The GMD_TECH_PARAMETERS_B table is a core data object within the Oracle E-Business Suite Process Manufacturing (GMD) module, specifically for Product Development. It functions as the header base table for defining technical parameters. These parameters are critical master data elements used to specify the quality, process, and testing criteria for materials, formulas, and routings throughout the manufacturing lifecycle. The table serves as the central repository for the definition and identification of each unique technical parameter set, enabling standardized control and specification across the product development and manufacturing processes.

Key Information Stored

The table stores the fundamental attributes that define a technical parameter header. Its primary key is the system-generated TECH_PARM_ID, which uniquely identifies each parameter set. A unique key constraint also exists on the combination of ORGN_CODE (organization code) and TECH_PARM_NAME, enforcing uniqueness of parameter names within a specific business unit or plant. Other significant columns include QCASSY_TYP_ID, which links to a quality assembly type in the QC_ASSY_TYP table, and TEXT_CODE, which references descriptive text stored in the LM_TEXT_HDR table. This structure allows the parameter header to be associated with specific quality test assemblies and to hold detailed descriptive notes.

Common Use Cases and Queries

This table is primarily accessed during the setup and maintenance of product specifications and quality test plans. A common operational query involves retrieving all technical parameters defined for a specific organization to support a specification creation user interface. For reporting and data validation, a frequent pattern is to join the header to its corresponding detail lines (typically in a table like GMD_TECH_PARAMETERS_TL for translatable descriptions or a child details table) to generate a complete list of parameter definitions. Sample SQL to fetch active parameter headers for an organization might resemble:

• SELECT tech_parm_id, tech_parm_name, qcassy_typ_id FROM gmd_tech_parameters_b WHERE orgn_code = :p_org_code;

Another critical use case is during batch disposition or quality review, where the system references the technical parameter definitions to validate test results against established specifications.

Related Objects

GMD_TECH_PARAMETERS_B is centrally connected to several key tables via foreign key relationships, as documented in the ETRM metadata. The primary relationships are:

• Self-Reference (GMD_TECH_PARAMETERS_B.QCASSY_TYP_ID): The metadata indicates a foreign key where the table references itself on the QCASSY_TYP_ID column, suggesting a potential hierarchical or categorical structure for parameter types.
• LM_TEXT_HDR (GMD_TECH_PARAMETERS_B.TEXT_CODE → LM_TEXT_HDR): This relationship attaches descriptive long text to the technical parameter header.
• QC_ASSY_TYP (GMD_TECH_PARAMETERS_B.QCASSY_TYP_ID → QC_ASSY_TYP): This crucial link associates the technical parameter with a specific Quality Control Assembly Type, defining the framework of quality tests and specifications it belongs to.

In a full implementation, this base table would also have corresponding translatable columns in a companion table like GMD_TECH_PARAMETERS_TL and be the parent to detail tables storing specific parameter values and tolerances.