Search Results acc_no

Overview

JE_ZZ_AUDIT_AP_PKG is a custom Oracle Application Object Library PL/SQL package owned by APPS that supports the tax auditing and VAT reporting requirements of Oracle Payables. The header comment (jezzauditapb.pls 120.13, dated 2007/12/31) identifies the package as part of the JE_ZZ custom module, the standard naming prefix used for Oracle E-Business Tax and country-specific localizations related to VAT reporting entities and reporting status. The package is registered as an API classification of OTHER, indicating it is not a public, callable business API but rather a report-support and utility package.

The primary business function is to prepare and populate temporary staging tables used by an Oracle Reports-based audit report, and to expose a set of formula columns and helper functions that the report layout references at runtime. The BeforeReport function is the documented entry point, called by the Reports engine before the data template is processed; it initialises report variables and populates the required temporary data. A notable declaration in this function is l_acc_no VARCHAR2(25), which corresponds to the "acc_no" search term and is one of the variable identifiers used during report initialisation, most likely to carry an account or accounting-flexfield reference used to join or filter transaction data.

Key Procedures and Functions

The package exposes 23 documented procedures and functions, which fall into four functional groups.

• Initialisation: BEFOREREPORT is the report-level entry point that declares report variables, resolves the ledger, and populates the temporary tables before the data model executes.
• Formula columns: C_PAYMENT_AMTFORMULA, CF_REC_TAX_CALCFORMULA, CF_TAX_AMTFORMULA, CF_TXBL_DISCOUNT_AMTFORMULA, CF_ITEM_TAX_AMTFORMULA, CF_REAL_INV_AMTFORMULA, C_PRT_AMT_TXBLFORMULA, and C_PRT_INV_AMTFORMULA derive computed amounts — payment amounts, recoverable tax, taxable discounts, item-level tax, real invoice amounts, and printed invoice and taxable amounts — from the underlying invoice and distribution data.
• Group formulas: G_COMPANYGROUPFILTER filters report output by company grouping, while G_DATA_FOUND_FORMULA, G_CURR_NAME_FORMULA, G_COMPANY_TITLE_FORMULA, G_PRECISION_FORMULA, and G_LEDGER_CURR_FORMULA supply the report with the currency name, company title, numeric precision, and ledger currency for the active ledger context.
• Attribute and display helpers: GET_LOOKUP_MEANING resolves a lookup code to its displayed meaning; GET_BOILER_PLATES retrieves boilerplate reporting text; SET_DISPLAY_FOR_CORE and SET_DISPLAY_FOR_GOV toggle the report display between core (commercial) and government layouts; and GET_BALANCING_SEGMENT returns the balancing segment for the reporting context.

Tables Accessed

The package reads and writes both Oracle Payables base tables and Oracle Subledger Accounting tables through APPS synonyms.

• Payables transactional tables: AP_INVOICES, AP_INVOICE_DISTRIBUTIONS, and AP_INVOICE_LINES provide the invoice header, accounting distribution, and invoice line detail used to compute taxable and tax amounts. AP_CHECKS and AP_CHECKS_ALL supply payment information, and AP_INVOICE_PAYMENTS links invoices to their payments. AP_SYSTEM_PARAMETERS supplies operating unit-level defaults.
• Subledger Accounting tables: XLA_AE_HEADERS, XLA_AE_LINES, XLA_ACCT_CLASS_ASSGNS, XLA_ASSIGNMENT_DEFNS_B, and XLA_DISTRIBUTION_LINKS resolve the accounting entries, account class assignments, and distribution links required for tax audit and VAT reporting reconciliation.
• VAT reporting tables: JG_ZZ_VAT_REP_ENTITIES, JG_ZZ_VAT_REP_STATUS, and JG_ZZ_VAT_TRX_GT are the JG_ZZ localisation tables holding reporting entity definitions, reporting status, and the transaction global temporary table for VAT reporting.

Usage Notes

JE_ZZ_AUDIT_AP_PKG is invoked indirectly. Its BeforeReport function is the documented report trigger, meaning the package is called by the Oracle Reports runtime whenever the associated audit report is executed, whether submitted as a concurrent program or through a form-embedded report call. The formula functions are referenced from report formula columns and group filters rather than called directly by application code. The package is referenced by zero other PL/SQL packages, confirming it is a leaf-level report support package. The l_acc_no variable in BeforeReport indicates that account numbers are resolved and cached during report initialisation for use in the data model. The presence of both SET_DISPLAY_FOR_CORE and SET_DISPLAY_FOR_GOV indicates the same report supports commercial and government layouts. Purchasing authorities typically deploy it against Oracle EBS 12.1.1 and 12.2.2 through the APPS schema, with execution privileges granted via standard custom-report setup. Not used for any standard product integration.