Search Results xla_reverse_events_pub_pkg

Overview

XLA_REVERSE_EVENTS_PUB_PKG is a public PL/SQL package owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It belongs to the Subledger Accounting (XLA) product family, which is the architectural foundation for generating accounting entries from transactions originating in subledgers such as Payables, Receivables, Assets, and Cost Management. The package's name indicates its role in the reversal of subledger events: it exposes public application programming interfaces that allow a caller to create reversal accounting for previously accounted events and to remove incomplete reversal attempts. In ETRM, the package is classified with an API type of OTHER, distinguishing it from standard open interfaces. Its status is VALID across the documented releases, confirming that the compiled package and package body are present and usable in the APPS schema.

Key Procedures and Functions

The ETRM metadata documents two public procedures within this package. No parameter lists are published in the reference metadata, and none should be inferred; callers must consult the package specification for the current signature.

• CREATE_REVERSAL_ACCOUNTING — This procedure performs the core business function of the package: it generates reversal accounting entries for a subledger event. In practice, this supports corrections and cancellations where the original accounting must be undone and a mirrored set of accounting lines created, consistent with the XLA accounting model and the Create Accounting engine's reversal conventions.
• DELETE_INCOMPLETE_REVERSAL — This procedure removes reversal records that were started but never completed, cleaning up partial state so that the event can be reprocessed or reversed again without duplication or integrity errors.

Tables Accessed

The ETRM documentation for this object does not enumerate specific base tables; the "tables referenced" section is empty in the supplied metadata. Functionally, a package of this nature operates on the XLA repository, which includes the accounting headers and lines, event and event-class entities, and journal entry line structures that store the reversal relationship between an original accounting entry and its counterpart. Because the package is a PUBLIC API, its writes are expected to flow through the standard XLA data model rather than through direct DML against application tables from external code. The dependency list confirms that the package references only SYS.STANDARD, indicating that its object-level dependencies are resolved at runtime through the XLA metadata and PL/SQL infrastructure.

Usage Notes

XLA_REVERSE_EVENTS_PUB_PKG is intended to be invoked programmatically rather than through a user-facing form. Typical callers include XLA internal processing logic, concurrent programs that drive Create Accounting and its reversal variants, and custom extensions that must reverse accounting for a known event identifier. The ETRM metadata records that the package is referenced by zero other documented packages, meaning it is not currently called by another catalogued package in the reference set; it may still be invoked by forms, concurrent program definitions, or bespoke code that falls outside the documented dependency graph. Because CREATE_REVERSAL_ACCOUNTING and DELETE_INCOMPLETE_REVERSAL are public entry points, custom code should invoke them within the same transaction and error-handling conventions used by XLA, and should validate the event's account status before requesting a reversal. Support and patching considerations are the same as for any APPS-owned XLA package: it is delivered and maintained by Oracle, and customization should be limited to calling the documented APIs.