Search Results xla_create_acct_rpt_pvt




Overview
Explore in AI Chat

Overview

The APPS.XLA_CREATE_ACCT_RPT_PVT package body is a private (PVT-classified) PL/SQL construct within the Oracle E-Business Suite Subledger Accounting (XLA) module. Its principal business function is to support the generation of accounting reports and concurrent report programs within the Subledger Accounting architecture. The suffix PVT indicates that the package is intended strictly for internal use by Oracle's own Subledger Accounting code base rather than as a public integration interface. It coordinates access to foundational XLA services — accounting event processing, journal entry creation, transfer to General Ledger, and reporting utilities — to produce accounting-related output for concurrent report requests. Because it is a package body without a matching documented public specification, its routines are invoked indirectly by the XLA reporting framework and the concurrent manager rather than by external applications.

Key Procedures and Functions

The ETRM metadata documents two procedures within this package body:

  • BEFOREREPORT — A report initialization routine executed before report output is produced. In the Oracle Reports/XLA reporting pattern, this hook performs preparatory tasks such as setting up report parameters, retrieving profile option values through FND_PROFILE, initializing session context via FND_GLOBAL, and establishing temporary working structures required by the accounting report. It ensures the environment is correctly configured before data is fetched.
  • AFTERREPORT — A report finalization routine executed after report output generation completes. It typically handles post-processing activities such as flushing or cleaning up temporary data, closing resources, logging completion status through FND_LOG, and releasing any session-level state established during the before-report phase.

Because the object is a package body with only these two documented procedures, its role is deliberately narrow — it acts as a lifecycle wrapper around the report execution process rather than the engine that performs the substantive accounting logic. That logic resides in the packages it depends upon.

Tables Accessed

The documented table references for this package are limited to DUAL and PLITBLM, accessed via APPS synonyms. DUAL is the standard single-row Oracle utility table, commonly used within the procedures for simple value computation, sequence-like assignments, or conditional expressions. PLITBLM is a system table used by the PL/SQL interpreter and typically appears as an incidental dependency rather than as an application data source. Notably, the package does not directly read or write the core Subledger Accounting transaction tables; instead, it delegates all data access to its dependent packages, including XLA_ACCOUNTING_PKG, XLA_ACCOUNTING_PUB_PKG, XLA_AE_JOURNAL_ENTRY_PKG, XLA_EVENTS_PUB_PKG, XLA_EXCEPTIONS_PKG, XLA_REPORT_UTILITY_PKG, and XLA_TRANSFER_PKG. This delegation pattern keeps the report-control package lightweight and decoupled from the underlying XLA schema.

Usage Notes

APPS.XLA_CREATE_ACCT_RPT_PVT is invoked as part of Subledger Accounting concurrent report processing. It is not exposed as a public API and carries no documented public callable interface, so it should not be called directly from custom code or forms. Its procedures execute within the context of an Oracle Reports or concurrent program execution, where BEFOREREPORT runs at report startup and AFTERREPORT runs at report completion. Supporting dependencies such as FND_CONCURRENT, FND_FILE, and FND_LOG confirm its integration with the concurrent manager, file output, and diagnostic logging infrastructure. The metadata states the package is referenced by one other database object, indicating a single internal caller relationship. In both EBS 12.1.1 and 12.2.2, the package status is VALID and its dependencies align with the standard XLA reporting stack. Customization should never target this private object; extensions should instead use the documented public XLA APIs.