Search Results lm_form_dtl




Overview
Explore in AI Chat

Overview

The LM_FORM_DTL table is a legacy data object within Oracle E-Business Suite (EBS), specifically in the GMD (Process Manufacturing Product Development) module. Its core function was to store detailed line-level information for formulations or recipes. Each record in this table historically represented a component ingredient or processing step within a master formula. However, as explicitly stated in the official ETRM documentation, this table is OBSOLETE as of version 11.5.6 of the Oracle Process Manufacturing (OPM) product family, under the PF.G release. In contemporary deployments of EBS 12.1.1 and 12.2.2, this table should not be used for any new development, reporting, or integration. It is maintained purely for backward compatibility, potentially to support data migration or legacy customizations that were never updated.

Key Information Stored

Based on its primary and foreign key structure, the table was designed to hold detailed formulation data linked to several master entities. The primary key, FORMULALINE_ID, uniquely identified each component line. Critical foreign key columns illustrate the relationships that defined a formulation's structure: FORMULA_ID linked the detail line to its parent formula header in the LM_FORM_MST table. ITEM_ID connected the line to a specific inventory item (raw material, intermediate, or product) defined in IC_ITEM_MST. TPFORMULA_ID provided a link to another formula, potentially for sub-formulations or co-products. Additional columns like ITEM_UM (linked to SY_UOMS_MST for the unit of measure) and TEXT_CODE (linked to LM_TEXT_HDR for descriptive text) provided further specification for the formula component.

Common Use Cases and Queries

Given its obsolete status, direct operational or reporting use of LM_FORM_DTL in EBS 12.x is strongly discouraged. Any existing functionality would have been superseded by objects in the modern Process Execution (PE) or Process Planning (PP) product families. If required for historical data analysis or auditing of legacy data, queries would typically join to its related master tables. A sample pattern to retrieve obsolete formulation details would be:

  • SELECT d.FORMULALINE_ID, m.FORMULA_NO, i.ITEM_NO, d.ITEM_UM
  • FROM GMD.LM_FORM_DTL d,
  • GMD.LM_FORM_MST m,
  • IC_ITEM_MST i
  • WHERE d.FORMULA_ID = m.FORMULA_ID
  • AND d.ITEM_ID = i.ITEM_ID;

All new development must utilize the current, supported tables and APIs provided by Oracle.

Related Objects

The foreign key constraints explicitly define this table's relationships within the obsolete schema. LM_FORM_DTL is a child table of LM_FORM_MST (the formula header). It references IC_ITEM_MST for items, SY_UOMS_MST for units of measure, and LM_TEXT_HDR for descriptive text blocks. It is also a parent table to LM_FORM_DAT, which likely stored additional attribute data for each formula line. Crucially, in the modern EBS architecture for Process Manufacturing, these objects have been replaced. For formulation management, key tables now include GMD_FORMULA_HEADER, GMD_FORMULA_LINES, and related entities in the GMD and GME schemas, which support the enhanced functionality of the Process Manufacturing suite.