Search Results ar_arxrws_xmlp_pkg




Overview
Explore in AI Chat

Overview

AR_ARXRWS_XMLP_PKG is a PL/SQL package in the APPS schema that supports the Oracle Receivables XML Publisher (BI Publisher) concurrent program associated with the ARXRWS report — the Receivables "Invoice Print" / statement & dunning-style XML report generation. In Oracle E-Business Suite Release 12.1.1 and 12.2.2, Oracle Reports-based concurrent programs were "XML Publisher-ized," which generates a companion PL/SQL package alongside the report definition. This package acts as the report's data model wrapper: it holds the entry-point procedures invoked by the XML Publisher engine, exposes the report parameters, controls the SQL query driving the report data source, and executes before/after logic around the query.

The package is classified as an "OTHER" API in the ETRM metadata, signalling that it is an internal Oracle-owned implementation package rather than a public, supported integration API. It resides in the APPS schema with VALID status and is a standard component of a working Receivables XML report setup.

Key Procedures and Functions

The ETRM documentation lists two documented subprograms for AR_ARXRWS_XMLP_PKG: BEFOREREPORT and AFTERREPORT. These are the conventional XML Publisher "Before Report" and "After Report" trigger procedures present in nearly all Oracle-seeded _XMLP_PKG packages.

  • BEFOREREPORT — Executed by the XML Publisher/BI Publisher runtime before the report data query is launched. It typically initialises the report context, evaluates and resolves report parameters (for example, organisation-related values needed to constrain the query), and performs any set-up required prior to the data fetch.
  • AFTERREPORT — Executed after the data query completes. It handles post-processing or clean-up tasks associated with the report run. No parameter lists are documented; only the subprogram names and their intended timing are registered.

Both procedures follow Oracle's generated code pattern and should not be modified, as changes are overwritten during patching.

Tables Accessed

Per the documented metadata, AR_ARXRWS_XMLP_PKG references the table AR_SYSTEM_PARAMETERS via the APPS synonym. AR_SYSTEM_PARAMETERS is the single-row (per organisation) Receivables setup table storing system-level defaults — including transaction, numbering, and rounding options. Referencing this table lets the package derive report defaults, such as functional currency and number-formatting behaviour, so the XML output is rendered consistently with the operating unit's Receivables configuration. The metadata records no other table references, indicating the package keeps its own footprint light and delegates the bulk of data extraction to the underlying report query.

Usage Notes

AR_ARXRWS_XMLP_PKG is not intended to be called directly from custom code or forms. It is invoked automatically by the XML Publisher concurrent program infrastructure when the associated Receivables report is submitted, at which point the runtime calls BEFOREREPORT, executes the report SQL, and then calls AFTERREPORT. Typical invocation is therefore through the standard concurrent program submission path (SRS), with the template and data definition attached to the report.

Customisation should occur at the XML template level (RTF/XSL-FO) or through a copied data definition, never inside this package. Because the package is referenced only within APPS and no other packages depend on it, changes are isolated but still unsupported. Administrators troubleshooting report failures should confirm the package is VALID, inspect the concurrent request log for errors raised in BEFOREREPORT or AFTERREPORT, and verify that AR_SYSTEM_PARAMETERS is populated for the operating unit.