Search Results migrate_formula_detail

Overview

GMD_FORM_MIGRATION is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the ETRM documentation as an OTHER API (as opposed to a public or private interface). Its functional name indicates a migration utility operating over the Process Manufacturing (GMD/OPM) formula and form data model. Specifically, the package exists to move, synchronize, or convert formula and formulation-related records between the base and translation tables and their associated material detail and status structures. In the EBS 12.1.1 and 12.2.2 code lines this package appears as a VALID database object with no forward references to other database objects in the documented metadata; it is a leaf-level utility rather than a shared framework package. Its role is best understood as an internal data-migration and status-update routine supporting formula setup, rather than a business-facing API exposed for general customer extension.

Key Procedures and Functions

The documented metadata exposes two procedures:

• INSERT_FORM_STATUS — Inserts status information associated with a formula or formula form record. This routine is the mechanism by which the migration process establishes or records the lifecycle or workflow status of a migrated formula, writing the relevant status code into the appropriate GMD status structure.
• MIGRATE_FORMULA_DETAIL — Performs the substantive migration of formula detail rows. It is the core worker of the package, responsible for transferring or generating the detailed formula line and material composition data required for a formula to be complete and usable in the Process Manufacturing application.

No parameter lists are documented in the ETRM metadata, and they are deliberately not inferred here. The two procedures are complementary: MIGRATE_FORMULA_DETAIL moves the formula's physical detail, and INSERT_FORM_STATUS records the resulting status, so a successful migration produces both a populated formula definition and a coherent status record.

Tables Accessed

The package operates against the following tables via APPS synonyms, which identify the data domains it touches:

• FM_FORM_MST, FM_FORM_MST_B, FM_FORM_MST_TL — the formula master tables (base, base-language, and translation). These hold the header-level formula definition and multilingual descriptions into which migrated formulas are written.
• FM_MATL_DTL — the formula material detail table, holding the ingredient/component lines that constitute the formula's composition; this is the primary target of MIGRATE_FORMULA_DETAIL.
• GMD_STATUS — the Process Manufacturing status table, populated by INSERT_FORM_STATUS to assign the formula's lifecycle or validity status.
• IC_ITEM_MST — the inventory item master, consulted to validate or resolve the items referenced by the migrated formula details.

Collectively these tables confirm that the package is scoped to formula header, detail, status, and item validation data.

Usage Notes

GMD_FORM_MIGRATION is an internal migration utility rather than a callable public API. It is referenced by no other packages in the documented ETRM metadata, which indicates a narrow, self-contained call surface. In practice such packages are invoked by migration or setup routines — often from concurrent program logic or upgrade scripts — during the movement of legacy or external formula data into the Process Manufacturing schema, or when a formula form requires its status and detail records to be synchronized after conversion. Because it writes directly to base formula and item tables, it should not be invoked ad hoc from custom code without a clear migration context. Customers and integrators coordinating formula data loads in 12.1.1 or 12.2.2 should treat this package as a supporting technology component and rely on Oracle's supported formula import and setup interfaces for routine, production data entry, reserving GMD_FORM_MIGRATION for the migration scenarios for which it was designed.