Search Results gmd_formula_common_pub




Overview
Explore in AI Chat

Overview

GMD_FORMULA_PUB is the public application programming interface (API) package within the Oracle Process Manufacturing (OPM) product family, owned by the APPS schema. Its principal business function is to provide a controlled, programmatic entry point for creating and maintaining formula headers in OPM. A formula defines the ingredients, quantities, and process structure that a manufacturing plant uses to produce a finished good, and the header record captures the formula identity, status, version, and ownership metadata associated with that definition.

The package is classified as a public API and is documented in ETRM for both Oracle E-Business Suite 12.1.1 and 12.2.2. It sits above the lower-level GMD_FORMULA_COMMON_PUB package, which it calls to perform shared validation and data manipulation logic, and it relies on FND_API for the standard EBS API return-status conventions and messaging framework.

Key Procedures and Functions

Three documented routines are exposed by this package:

  • INSERT_FORMULA — Creates a new formula header record. It allocates and persists the identifying information for a formula so that detail lines, such as material requirements, can subsequently be attached.
  • UPDATE_FORMULAHEADER — Modifies attributes of an existing formula header, allowing changes such as status transitions, descriptive fields, or ownership data to be applied without disturbing the underlying detail structure.
  • DELETE_FORMULAHEADER — Removes a formula header, typically subject to the validation and referential checks enforced by the OPM data model and the GMD_STATUS lookup.

Parameter lists are not reproduced here; callers should consult the ETRM specification for the exact signature, mandatory arguments, and return values of each routine.

Tables Accessed

Through APPS synonyms, the package operates on the following base tables:

  • FM_FORM_MST — the primary formula master table holding header-level formula information.
  • FM_FORM_MST_B — the corresponding base table storing translated or base-language text attributes for formula headers.
  • FM_MATL_DTL — formula material detail, referencing ingredient lines associated with a formula.
  • GMD_STATUS — the status code lookup used to validate and assign formula lifecycle states such as new, approved, or obsolete.
  • IC_ITEM_MST — the item master, used to validate the product item for which the formula is defined.
  • FND_USER — supplies the identity of the user performing the operation for audit columns.
  • PLITBLM — an OPM support table used in the package's processing logic.

Usage Notes

GMD_FORMULA_PUB is referenced by three other packages: GMD_CREATE_FORMULA, GMD_EBI_RECIPE_PUB, and GMD_FORMULA_DESIGNER_PKG. This indicates that the package serves both as a callable API and as an internal service layer for OPM's formula creation, recipe interface, and formula designer functionality. Custom code, integration scripts, or concurrent programs that need to insert, maintain, or retire formula headers should invoke these public routines rather than writing directly to FM_FORM_MST. Direct DML bypasses the validation, status checks, and audit handling provided by the package and by GMD_FORMULA_COMMON_PUB beneath it. Callers should also respect the standard FND_API return-status and message conventions when interpreting results.