Search Results gmd_substitution_pub




Overview
Explore in AI Chat

Overview

GMD_SUBSTITUTION_PUB is the public PL/SQL API package in the Oracle EBS Process Manufacturing (OPM) product family, owned by the APPS schema and classified as a PUB (public) interface. Its business purpose is to manage item substitution definitions and the association of substitutions with formulas in the Oracle Process Manufacturing environment. Item substitution allows a manufacturer to designate an alternate item that may be used in place of a primary item during production, typically to accommodate material shortages, formulary flexibility, or cost-driven sourcing decisions. The package exposes a controlled, supported interface for creating and maintaining substitution headers, substitution details, and the formula-level associations that determine where a given substitution is valid. Because it is a public API rather than an internal (private) package, it is the recommended entry point for external or custom code that must insert, update, or delete substitution data without directly manipulating the underlying OPM tables. A companion private package, GMD_SUBSTITUTION_PVT, contains the implementation logic and calls the public procedures, ensuring all writes pass through the same validation and business rules.

Key Procedures and Functions

The package documents five procedures and functions, each addressing a distinct step in the substitution lifecycle:

  • CREATE_SUBSTITUTION — Creates a substitution definition, establishing the header and detail records that link a primary item to one or more substitute items within an organization. It is the primary entry point for introducing a new substitution into the system.
  • CREATE_FORMULA_ASSOCIATION — Establishes the relationship between an existing substitution and a formula, scoping the substitution so that it is applicable only within the context of the specified formula.
  • UPDATE_SUBSTITUTION_HEADER — Modifies header-level attributes of an existing substitution record, such as status, effective dating, or descriptive fields, without altering its detail lines.
  • UPDATE_SUBSTITUTION_DETAIL — Modifies detail-level information for an existing substitution, allowing individual substitute item assignments or related attributes to be changed.
  • DELETE_FORMULA_ASSOCIATION — Removes the link between a substitution and a formula, effectively disabling the substitution for that formula while leaving the substitution definition itself intact.

Parameter lists are not reproduced here; developers should reference the ETRM or the package specification for exact argument signatures.

Tables Accessed

The package reads and writes the core OPM substitution tables. GMD_ITEM_SUBSTITUTION_HDR_B and its translation table GMD_ITEM_SUBSTITUTION_HDR_TL hold substitution header data, while GMD_ITEM_SUBSTITUTION_DTL stores detail lines and GMD_ITEM_SUBSTITUTION_DTL_S provides the corresponding sequence. Formula-level linkage is maintained in GMD_FORMULA_SUBSTITUTION, with FM_FORM_MST_B supplying the formula master definition. Item validation and display use MTL_SYSTEM_ITEMS_B, MTL_SYSTEM_ITEMS_KFV, and FM_MATL_DTL. GMD_STATUS supplies valid status codes, and DUAL and PLITBLM are used for utility and PL/SQL table operations. Views GMD_ITEM_SUBSTITUTION_HDR and GMD_ITEM_SUBSTITUTION_HDR_S are referenced for header and sequence access.

Usage Notes

GMD_SUBSTITUTION_PUB is typically invoked from OPM substitution maintenance forms, from concurrent programs that mass-load substitutions, and from custom PL/SQL integrations requiring programmatic control over substitution data. It is also called by GMD_SUBSTITUTION_PVT, confirming that it serves as the sanctioned wrapper around private implementation logic. Customizations should call the public procedures rather than writing directly to the GMD tables, so that validation, sequence generation, and status rules are consistently applied. Given its dependency footprint and its role in production material planning, changes should be tested carefully in a non-production environment.