Search Results lm_form_dat




Overview
Explore in AI Chat

Overview

The LM_FORM_DAT table is a legacy data object within the Oracle E-Business Suite (EBS) Process Manufacturing (GMD) module, specifically under the Product Development sub-module. Its core purpose was to store detailed parameter data associated with formula lines during laboratory management and development processes. However, as explicitly stated in the official ETRM documentation, this table is designated as OBSOLETE as of version 11.5.6, under the OPM Process Formulation (OPM PF.G) release. In the context of EBS 12.1.1 and 12.2.2, this table exists primarily for backward compatibility and data reference. Its active functional role has been superseded by newer application logic and data structures, and it should not be used for any new custom development or reporting.

Key Information Stored

Based on its primary and foreign key structure, the table was designed to hold technical parameter values for specific formula lines. Key columns include FORMULALINE_ID, which links to a specific line in a formula (LM_FORM_DTL), and the combination of LAB_TYPE and TECH_PARM_NAME, which links to the laboratory technique parameter definition (LM_TECH_HDR). The table also references a TEXT_CODE, likely for descriptive text, linking to LM_TEXT_HDR. The primary key (LM_FORM_DAT_PK) on LAB_TYPE, FORMULALINE_ID, and TECH_PARM_NAME enforced uniqueness for parameter data per formula line and laboratory type.

Common Use Cases and Queries

Given its obsolete status, direct operational or transactional use cases are non-existent in modern implementations. The primary contemporary use is for historical data analysis or migration validation. Any queries should be for diagnostic or audit purposes only. A sample query to retrieve obsolete parameter data for a specific formula line would leverage its foreign key relationships:

  • SELECT d.FORMULALINE_ID, d.LAB_TYPE, d.TECH_PARM_NAME, h.PARAMETER_DESC FROM GMD.LM_FORM_DAT d, GMD.LM_TECH_HDR h WHERE d.LAB_TYPE = h.LAB_TYPE AND d.TECH_PARM_NAME = h.TECH_PARM_NAME AND d.FORMULALINE_ID = :form_line_id;

It is critical to note that any new reporting requirements should be fulfilled using the current, supported tables and views provided by the Oracle Process Manufacturing application.

Related Objects

The ETRM metadata specifies three direct foreign key relationships, indicating this table's former position in the laboratory management data model. The related objects are:

  • LM_FORM_DTL: The formula details table, linked via FORMULALINE_ID. This was the parent entity for the parameter data.
  • LM_TECH_HDR: The technique header table, linked via LAB_TYPE and TECH_PARM_NAME. This provided the definition and metadata for the parameter being stored.
  • LM_TEXT_HDR: The text header table, linked via TEXT_CODE, likely used for storing descriptive notes associated with the parameter value.

These relationships confirm that LM_FORM_DAT served as a child table, storing instance-specific values for parameters defined in LM_TECH_HDR, for lines defined in LM_FORM_DTL.