Search Results lm_sprd_prm




Overview
Explore in AI Chat

Overview

The LM_SPRD_PRM table is a core data object within the Oracle E-Business Suite (EBS) Process Manufacturing Product Development module (GMD). It functions as a repository for technical parameter definitions that are associated with a spreadsheet. In the context of Oracle Process Manufacturing (OPM), spreadsheets are used to define and manage complex product formulas, specifications, and laboratory test data. This table establishes the critical link between a defined spreadsheet structure and the specific technical parameters—such as assay names, quality control tests, or other lab-defined properties—that are to be captured and calculated within it. Its role is to ensure data integrity and consistency by formally defining which measurable parameters belong to a given spreadsheet template.

Key Information Stored

The table's structure centers on a composite primary key that uniquely identifies each parameter definition within a spreadsheet context. The key columns are SPRD_ID, which links to the parent spreadsheet definition in the LM_SPRD_FLS table; LAB_TYPE, which categorizes the laboratory or technical domain; and TECH_PARM_NAME, which specifies the exact technical parameter being referenced. Additional important columns facilitate integration with the Quality Management module, including QC_ORGN_CODE (Quality organization code) and QC_ASSAY_NAME, which together form a foreign key to the QC_ASSY_TYP table, linking the spreadsheet parameter to a formal, predefined quality assay.

Common Use Cases and Queries

A primary use case involves validating or reporting on the complete set of technical parameters configured for a specific spreadsheet template, which is essential for formula development and quality specification management. Database administrators or developers may query this table to audit configuration or resolve data issues. A typical query would join to the related spreadsheet header table:

  • SELECT s.spreadsheet_name, p.lab_type, p.tech_parm_name, p.qc_assay_name FROM gmd.lm_sprd_prm p, gmd.lm_sprd_fls s WHERE p.sprd_id = s.sprd_id AND s.spreadsheet_name = '<SPREADSHEET_NAME>';

Another common scenario is identifying all spreadsheets that utilize a particular quality assay, supporting impact analysis for changes to master quality data:

  • SELECT s.spreadsheet_name FROM gmd.lm_sprd_prm p, gmd.lm_sprd_fls s WHERE p.sprd_id = s.sprd_id AND p.qc_orgn_code = '<ORG_CODE>' AND p.qc_assay_name = '<ASSAY_NAME>';

Related Objects

The LM_SPRD_PRM table is centrally connected to several key objects via foreign key constraints, as documented in the ETRM. The LM_SPRD_FLS table is its direct parent, containing the master definition of the spreadsheet itself. It references the LM_TECH_HDR table through the LAB_TYPE and TECH_PARM_NAME columns to validate the technical parameter master data. For quality-related parameters, it has a critical relationship with the QC_ASSY_TYP table in the Quality Management schema, linking spreadsheet parameters to standardized assay definitions. These relationships ensure that data entered into spreadsheets is governed by established master data in both the Process Manufacturing and Quality Management modules.