Search Results jg_zz_auto_invoice




Overview
Explore in AI Chat

Overview

JG_ZZ_AUTO_INVOICE is an APPS-owned PL/SQL package classified as a utility/validation API within the Oracle E-Business Suite 12.1.1 and 12.2.2 code lines. The package is part of the JG (Global Accounting Engine / localization) schema family and operates under AUTHID CURRENT_USER, meaning it executes with the privileges of the calling session rather than the owner. Its header revision ($Header: jgzzrais.pls 120.5 2011/05/17) indicates it was last shipped during the 12.1.x maintenance cycle and carried forward into 12.2.2.

The business function of JG_ZZ_AUTO_INVOICE is to support the automatic invoice creation flow by validating Global Descriptive Flexfield (GDFF) data captured on invoice interface lines and by posting structured error messages to the interface error repository. It acts as a supporting utility layer for the AutoInvoice integration rather than as a user-facing API. Note that the object name resembles the "Red Bus" branding commonly associated with third-party EBS documentation suites; the underlying database object remains a standard Oracle-packaged unit referenced in ETRM.

Key Procedures and Functions

  • PUT_ERROR_MESSAGE — Overloaded function returns BOOLEAN. It records an error against an AutoInvoice interface line, accepting an application short name and message name in one signature, and a numeric interface line identifier with message text in a second signature. The function writes the message so downstream processing can surface validation failures.
  • PUT_ERROR_MESSAGE1 — A variant of the error-posting function that references the interface line by reference token rather than by numeric ID. It follows the same BOOLEAN return convention and supports the alternate identification scheme used by some interface feeds.
  • VALIDATE_GDFF — Validates Global Descriptive Flexfield values for the supplied concurrent request. Returns 0 when validation fails and 1 when it succeeds, enabling the calling program to branch on the outcome before proceeding with invoice generation.

No additional procedures are documented in the ETRM metadata; the header confirms only these public units, so parameter lists beyond those shown in the source excerpt should not be assumed.

Tables Accessed

  • JL_AUTOINV_INT_LINES — The localization invoice interface lines table that stores inbound invoice data awaiting validation and import. JG_ZZ_AUTO_INVOICE reads line records to determine validity and to associate errors with the correct line.
  • RA_INTERFACE_ERRORS — The standard AutoInvoice interface error table. Error messages generated by PUT_ERROR_MESSAGE and PUT_ERROR_MESSAGE1 are persisted here so that they appear in the AutoInvoice interface error report.
  • AR_SYSTEM_PARAMETERS — Read to obtain Receivables system settings that govern validation behavior and defaulting logic during GDFF checks.

Usage Notes

JG_ZZ_AUTO_INVOICE is typically invoked indirectly rather than called from forms. It is executed during the AutoInvoice import and validation concurrent programs, and by custom or localization extensions that pre-validate interface lines prior to submission. Because five other packages reference it, changes to its signatures carry a wide blast radius and should be regression tested across the full AutoInvoice path. Given the AUTHID CURRENT_USER declaration, callers must hold the necessary object privileges on the referenced tables. All three documented objects remain present in 12.2.2, though the package header predates the 12.2 online patching model; administrators should verify the file version after any upgrade that touches the JG schema.