Search Results oe_invoice_pub




Overview
Explore in AI Chat

Overview

APPS.JG_ZZ_OM_COMMON_PKG is a shared utility package in the Oracle E-Business Suite Order Management schema. It sits within the JG (Globalization / localizations) namespace and provides common helper logic that supports Order Management processing, particularly around descriptive flexfield (DFF) handling for order and invoice structures. The package is documented as VALID in release 12.2.2 and is classified as an OTHER API rather than a public business API, which indicates it is intended for internal consumption by other Order Management packages rather than for direct customer invocation.

The package exists to centralize repetitive flexfield operations — copying and defaulting attribute values between source and target records — so that Order Management utilities do not each re-implement that logic. Its placement in the JG_ZZ family suggests it originated to satisfy localization or country-specific (ZZ) requirements while remaining broadly reusable across the Order Management stack.

Key Procedures and Functions

The documented package exposes four procedures. The metadata confirms their names but not their parameter lists, so only their evident purpose is described here:

  • COPY_GDFF — Copies descriptive flexfield (global descriptive flexfield) attribute values, typically from a source record to a destination record during order or invoice cloning, copying, or conversion operations.
  • DEFAULT_GDFF — Applies default values to global descriptive flexfield segments, populating context and attribute columns when a record is created without explicit flexfield input.
  • COPY_GDF — Performs the equivalent copy operation for non-global descriptive flexfield structures, transferring flexfield segment values between records.
  • DEFAULT_GDF — Applies defaults to standard descriptive flexfield segments, ensuring that newly created records carry the expected default attribute values.

Together these four routines provide symmetric, paired behavior: a COPY routine for transferring existing values and a DEFAULT routine for initializing values where none are supplied. This pattern is characteristic of shared Order Management utilities invoked at multiple points in the order lifecycle.

Tables Accessed

The ETRM metadata for this package does not enumerate referenced tables through APPS synonyms. Based on the dependency list, the package instead relies on other PL/SQL packages rather than direct table access. Its documented dependencies include APPS.OE_INVOICE_PUB and APPS.OE_ORDER_PUB, both of which are Order Management public APIs that encapsulate their own table access against the OE_ORDER_HEADERS_ALL, OE_ORDER_LINES_ALL, and related invoice interface structures. The SYS.STANDARD dependency reflects use of standard PL/SQL language facilities. Any persistent flexfield values handled by COPY_GDFF, DEFAULT_GDFF, COPY_GDF, and DEFAULT_GDF are therefore written through those packages or through the calling context rather than through tables declared in this package's own metadata.

Usage Notes

JG_ZZ_OM_COMMON_PKG is an internal utility. The dependency metadata shows it is referenced by four Order Management packages — OE_CONFIG_PVT, OE_CONFIG_UTIL, OE_INVOICE_PUB, and OE_LINE_UTIL — and by itself. This confirms it is invoked from configuration validation, invoice processing, and line-level processing utilities, most commonly during order entry, order copy, and invoice generation when flexfield attributes must be preserved or defaulted.

Because the package is classified as OTHER and is referenced through the OE internals, customers and integrators should not call it directly. The user search term "oe_invoice_pub" is significant: OE_INVOICE_PUB is both a dependency of this package and one of its callers, meaning invoice-related flexfield defaulting and copying for orders flows through this utility. Customizations that need flexfield behavior equivalent to standard Order Management processing should invoke OE_INVOICE_PUB, OE_ORDER_PUB, or the relevant OE line utilities rather than JG_ZZ_OM_COMMON_PKG, allowing Oracle to manage the internal contract across 12.1.1 and 12.2.2 upgrades.