Search Results copy_gdff

Overview

APPS.JG_ZZ_OM_COMMON_PKG is a globalization (JG) utility package body delivered as part of the Oracle E-Business Suite country-specific localization layer. Its principal business function is to manage the transfer of Global Descriptive Flexfield (GDFF) attribute values between the Order Management (OM) invoicing data structures and the interface tables used by the OM Invoicing concurrent process. In releases 12.1.1 and 12.2.2, the package is owned by APPS and is classified as an "OTHER" API, meaning it is a supporting internal routine rather than a public, externally supported interface. The package ensures that the country-specific global attribute segments captured on an order line are correctly propagated to the interface record so that downstream tax, legal, and reporting requirements tied to the JG localization are satisfied. The header comment indicating a last revision of version 120.13 (2005) confirms that the logic is long-standing and stable across both release levels.

Key Procedures and Functions

The documented package exposes four procedures:

• COPY_GDFF — Copies the required global attribute (GDFF) columns from a source interface line record into a target interface line record. The procedure accepts an input interface line record and returns an output interface line record, together with a return code (0 for success, 2 for failure) and an error buffer. It derives the country code from the line's global attribute category rather than from the profile option, reflecting a change introduced by bug 2133665.
• DEFAULT_GDFF — Applies default values to the global descriptive flexfield attributes, ensuring that lines lacking explicit country-specific values still receive the appropriate defaults before processing.
• COPY_GDF — Performs an equivalent copy operation for the standard (non-global) descriptive flexfield attributes, providing parallel handling for DFF segments.
• DEFAULT_GDF — Applies default values to the standard descriptive flexfield attributes, complementing DEFAULT_GDFF.

Together these four routines handle both the global (GDFF) and standard (GDF) descriptive flexfields, covering the copy and default paths required during OM invoicing.

Tables Accessed

The ETRM metadata for this object does not enumerate specific tables accessed via APPS synonyms. Based on the documented parameter types, the package operates primarily on the interface line record type declared in OEXPINVS.pls and defined in OE_Invoice_PUB.OE_GDF_Rec_Type. The COPY_GDFF routine writes the copied global attribute columns into the OM Invoicing interface table structure, ensuring each row created in the current submission carries the correct global attribute values. The package is referenced by four other packages, indicating it functions as a shared utility within the OM invoicing and localization processing chain rather than as a standalone table-driven process.

Usage Notes

JG_ZZ_OM_COMMON_PKG is invoked internally during the OM Invoicing process, specifically when processing interface line records for localized (JG) implementations. It is not typically called directly from a form or from custom code; instead it is referenced by the four dependent packages that orchestrate the invoicing submission. Because it is classified as an "OTHER" API, Oracle does not guarantee its signature across upgrades, so customizations should avoid direct invocation. The package includes debug instrumentation via OE_DEBUG_PUB.ADD, and its behavior regarding the country code source (line category versus profile option) is a known and intentional design decision documented through bug 2133665. Administrators troubleshooting missing or incorrect global attribute values on invoiced lines should examine this package as the point where GDFF and GDF values are copied and defaulted.