Search Results gem5_formula_id_s




Overview
Explore in AI Chat

Overview

GMD_LAB_MIGRATION is an Oracle EBS Process Manufacturing (OPM) package body owned by the APPS schema. Its stated purpose is to migrate laboratory formula data from legacy laboratory management structures into the Oracle Formula Management tables used by the core OPM product. In the context of Oracle EBS 12.1.1 and 12.2.2 this object belongs to the discrete set of one-time conversion utilities shipped for OPM implementations, sitting alongside the GMD_MIGRATION package that orchestrates the broader migration of process manufacturing data.

The package is documented in ETRM as status VALID, classified as OTHER in the API taxonomy, which indicates it is an internal migration utility rather than a published, supported PL/SQL API. Its dependency list is entirely OPM and Oracle Forms infrastructure: FM_FORM_MST and its _B and _TL variants, FM_MATL_DTL, LM_FORM_MST and LM_FORM_DTL, GMD_LAB_FORMULA_ASSOC, and FND_LANGUAGES / FND_PROFILE. Because it is not referenced by any other database object, it is a top-level driver rather than a shared library.

Key Procedures and Functions

The ETRM metadata documents a single public program unit within the package body:

  • INSERT_LAB_FORMULA — the sole documented procedure. Its name and the package dependency graph indicate that it inserts laboratory formula rows, transferring records from the legacy LM_FORM_MST / LM_FORM_DTL laboratory structures into the corresponding Oracle Formula Management records and populating the GMD_LAB_FORMULA_ASSOC association table in the process.

No parameter lists are published in the ETRM metadata, and none should be assumed. The procedure relies on sequence objects GEM5_FORMULA_ID_S, GEM5_FORMULALINE_ID_S, and GMD_REQUEST_ID_S to generate primary keys for migrated formula headers, formula lines, and migration request identifiers respectively.

Tables Accessed

The package touches the following documented objects via APPS synonyms:

  • FM_FORM_MST, FM_FORM_MST_B, FM_FORM_MST_TL — the Oracle Formula Management master tables, including the base and translation tables. These are the migration targets for formula headers, with the _TL access reflecting multi-language text for the FND_LANGUAGES join.
  • FM_MATL_DTL — formula material detail; target for migrated formula line and ingredient rows.
  • LM_FORM_MST, LM_FORM_DTL — the legacy laboratory formula master and detail tables acting as migration sources.
  • GMD_LAB_FORMULA_ASSOC — the association table linking laboratory formulas to their migrated Formula Management equivalents, written during the insert operation.
  • GEM5_FORMULA_ID_S, GEM5_FORMULALINE_ID_S, GMD_REQUEST_ID_S — sequence sources for surrogate keys and request identifiers.
  • GMD_MIGRATION — the parent migration control structure, used to coordinate the conversion run.
  • FND_LANGUAGES, FND_PROFILE — standard Oracle Application Object Library lookups, used to resolve the session language and environment context for the migrated data.

Usage Notes

GMD_LAB_MIGRATION is an internal conversion utility and is not intended for ongoing transactional or integration use. It is typically invoked once during an OPM implementation, either from Oracle Forms migration screens in the Laboratory Management module or from a concurrent program wrapping the migration routine, at the point where laboratory formula definitions are consolidated into Formula Management. Because the package is classified as OTHER and is not referenced by any other database object, customers and integrators should treat it as unsupported for direct calls. Any custom code should invoke the supported Formula Management APIs instead, reserving GMD_LAB_MIGRATION for its designed one-time data conversion role in 12.1.1 and 12.2.2 environments.