Search Results jg_zz_audit_ar_pkg




Overview
Explore in AI Chat

Overview

The APPS.JG_ZZ_AUDIT_AR_PKG package body is a Global Taxation (JG) component that supports the Annual VAT Audit Report within Oracle E-Business Suite. The package is written as the backend implementation for the AUDIT-AR report, whose specification was originally authored to generate audit reporting consistent with regional VAT (Value Added Tax) requirements. The header identifies the source script as jgzzauditarb.pls, and the revision history shows an initial draft in January 2005 by Murali V, with subsequent corrections driven by unit testing and bug fixes tracked under references such as Bug 5189166, Bug 5125654, Bug 5225958, and Bug 5194991. The latter revision, dated August 2005, incorporated reprint functionality into the report logic.

The package is classified in ETRM as an "OTHER" API type, indicating it is not a public interfaces API but rather an internal reporting support package. Its principal role is to supply the data preparation logic executed at report runtime, coordinating VAT transaction detail, party site, and receivables data into a form suitable for the audit output.

Key Procedures and Functions

The documented metadata lists a single procedure/function for this package: BEFOREREPORT. In Oracle Reports, the BeforeReport trigger fires once, prior to the execution of the report's data model queries, and is commonly used to initialize global variables, evaluate parameters, or invoke package logic. Here, BEFOREREPORT contains an embedded PL/SQL block, including the declaration of a local numeric variable l_precision and a cursor designated for the JEBEVA17 Annual VAT Audit Report. That cursor selects audit rows for VAT reporting. The revision history notes a specific change in which the cursor was modified to remove usage of hz_cust_account_sites by eliminating an outer join, and instead joining jg_zz_vat_trx_details.billing_tp_site_id directly to hps.party_site_id. This change is directly relevant to the term "hz_cust_account_sites" associated with this object. No parameter lists are documented for this procedure, and none should be assumed beyond what the metadata confirms.

Tables Accessed

The package reads from a broad set of APPS synonyms supporting receivables, trading partners, and VAT reporting:

Usage Notes

The package is invoked in the context of the Annual VAT Audit Report, typically as the report-level BeforeReport logic within an Oracle Reports executable. It is registered under the APPS schema and is not referenced by any other packaged APIs, confirming its role as a report-specific utility rather than a shared library. Because it contains a reprint capability, organizations may run the report in both original and reprint modes for the same reporting period. Support and customization efforts should account for the historical fix to remove the hz_cust_account_sites outer join, ensuring any custom copies of the report logic use the party site join path described in version 120.3 of the source. The package remains relevant in EBS 12.1.1 and 12.2.2 environments where VAT audit reporting obligations apply.