Search Results gmd_formula_pub




Overview
Explore in AI Chat

Overview

APPS.GMD_FORMULA_COMMON_PUB is a public PL/SQL package within the Oracle E-Business Suite Process Manufacturing (OPM) module. It serves as a shared utility layer for formula management functionality, providing common services consumed by higher-level formula APIs, validation routines, and the Formula Designer user interface. In EBS releases 12.1.1 and 12.2.2, this package occupies an important position in the dependency hierarchy of the GMD (Process Manufacturing Product Development) schema objects: it depends only on the SYS.STANDARD package, while it is referenced by six other packages — GMDFMVAL_PUB, GMD_CREATE_FORMULA, GMD_FORMULA_DESIGNER_PKG, GMD_FORMULA_DETAIL_PUB, and GMD_FORMULA_PUB (appearing twice in the dependency list). The package is validated (Status: VALID) in the APPS schema and is classified as a PUB (public) API, indicating it is intended for supported, external invocation rather than being a private implementation detail.

Key Procedures and Functions

The ETRM metadata for this object documents zero individual procedures or functions. While the package body clearly exists and is compiled (it references SYS.STANDARD and is referenced by multiple dependent packages), the repository does not expose a public procedure list. No procedure names, parameter lists, or signatures should be assumed. What can be stated from the documented dependency data is that the package exposes a set of common routines consumed by sibling and downstream packages. Given that GMDFMVAL_PUB handles formula validation and GMD_FORMULA_PUB, GMD_FORMULA_DETAIL_PUB, and GMD_CREATE_FORMULA handle formula-level and detail-level creation, the routines in GMD_FORMULA_COMMON_PUB are best understood as shared internal services — likely centering on common attribute derivation, cross-package data lookups, or helper logic reused across formula create, detail, and validation flows. The absence of a documented procedure list means integrators should inspect the compiled package specification in the target instance or the ETRM report output for the complete public interface before coding against it.

Tables Accessed

The metadata lists one table referenced via an APPS synonym: LM_FORM_MST. This is a master table associated with Oracle Quality / Process Manufacturing form definitions. The package reads this table to resolve form metadata used during formula processing — for example, to determine form-level configuration or attributes applicable when creating or validating formula records. No other base tables are documented as direct references. Developers should be aware that additional DML may occur through the dependent packages; however, based solely on the documented metadata, LM_FORM_MST is the only table attributed to GMD_FORMULA_COMMON_PUB itself.

Usage Notes

Because the package is classified as PUB, it is a supported entry point for customizations and extensions. However, the more common invocation paths are indirect. The package is referenced by GMDFMVAL_PUB and GMD_CREATE_FORMULA, indicating it is called during formula validation workflows and formula creation processes initiated from the Oracle Process Manufacturing Formula Designer (GMD_FORMULA_DESIGNER_PKG). Additional callers include GMD_FORMULA_PUB and GMD_FORMULA_DETAIL_PUB, which are the standard public APIs for formula and formula-detail operations. Custom code that manipulates formulas should generally target those higher-level public APIs (GMD_FORMULA_PUB, GMD_FORMULA_DETAIL_PUB) rather than GMD_FORMULA_COMMON_PUB directly, since the common package provides shared services and not the primary transactional interface. When diagnosing formula creation or validation errors in 12.1.1 or 12.2.2, the dependency chain originating at GMD_FORMULA_COMMON_PUB is a useful starting point, as faults in its common routines propagate to all six dependent packages. The package must be compiled in the APPS schema, and it carries no dependencies beyond SYS.STANDARD, minimizing recompilation risk after patching.