Search Results gmi_valid_grp




Overview
Explore in AI Chat

Overview

GMI_VALID_GRP is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite releases 12.1.1 and 12.2.2. The object is classified in the ETRM repository as a "GRP" (group) API, denoting a utility library rather than an entity-level API. Its business function is to provide centralized validation logic for Oracle Process Manufacturing (OPM) inventory and item attributes. The naming convention (GMI prefix) places it within the OPM Inventory (GMI) module family, and the package is closely related to GMA_VALID_GRP, which it references as a dependency.

The package encapsulates the cross-field and cross-reference checks required before an item, lot, location, or warehouse record can be considered valid. By isolating these rules in a single package body, Oracle allows both the OPM application forms and customer extension code to apply identical validation semantics, reducing data integrity defects across the item master and inventory transaction tables.

Key Procedures and Functions

The ETRM metadata documents 47 procedures and functions in this package body. The documented subset includes the following public validators:

Per the ETRM repository, these procedures do not expose parameter lists in the documented metadata; consumers should inspect the package specification for the current signature in their specific release.

Tables Accessed

The package reads validation reference data from OPM and Oracle Inventory tables via APPS synonyms. Documented table references include IC_ITEM_MST and IC_ITEM_CNV/IC_ITEM_CPG for item master and conversion data; IC_LOCT_MST and IC_WHSE_MST for location and warehouse definitions; IC_LOTS_MST for lot attributes; PO_VEND_MST for supplier validation; CM_MTHD_MST for cost method checks; CR_SQDT_CLS for quality deviation class data; and the class tables IC_ALLC_CLS, IC_COMD_CDS, IC_COST_CLS, IC_CTMS_CLS, IC_FRGT_CLS, and IC_GLED_CLS, which back the GL, cost, commodity, customs, and freight class validators. GEM_LOOKUPS supplies lookup values, and GMA_VALID_GRP supplies shared validation routines.

Usage Notes

GMI_VALID_GRP is typically invoked from OPM item and inventory maintenance forms (such as the Item Master and Lot Maintenance windows) during field-level validation, and from batch or concurrent processing that stages item and lot data. The metadata states the package is not referenced by any database object but is referenced by four other packages, indicating that other OPM packages call these validators directly. Custom code extending OPM should call the same procedures to preserve validation consistency. The package status is VALID and no known invalid dependent objects are recorded.