Search Results xla_reverse_events_pvt_pkg




Overview
Explore in AI Chat

Overview

XLA_REVERSE_EVENTS_PVT_PKG is a private PL/SQL package owned by the APPS schema within the Oracle E-Business Suite Subledger Accounting (XLA) architecture. Its purpose is to support the reversal of accounting events and their associated accounting entries in the subledger. When a source transaction that has already been accounted must be reversed — for example through a credit memo, a cancellation, or a manual reversal request — the subledger requires a controlled mechanism to generate the corresponding reversal accounting, to propagate that accounting to the General Ledger, and to clean up any incomplete reversal records left behind by failed processing. This package encapsulates that private logic and is not intended for direct invocation by external callers. It is classified as a private (PVT) package, meaning it exposes an internal implementation layer that is consumed by the public API package XLA_REVERSE_EVENTS_PUB_PKG. The ETRM metadata confirms the object is VALID in the shipped APPS schema and that it is referenced only by XLA_REVERSE_EVENTS_PUB_PKG and by itself.

Key Procedures and Functions

The documented package exposes two procedures or functions:

  • CREATE_REVERSAL_ACCOUNTING — Creates the reversal accounting for events that are being reversed. This routine drives the creation of reversal accounting entries in the subledger, producing the accounting event records and the resulting journal entry headers and lines that offset the original accounting.
  • DELETE_INCOMPLETE_REVERSAL — Removes reversal records that were left in an incomplete or partially processed state, allowing the reversal to be reattempted cleanly without leaving orphaned accounting artifacts.

No parameter lists are documented in the ETRM metadata, and none are asserted here. These procedures are invoked internally by the public reversal API rather than being called directly.

Tables Accessed

The package reads and writes a significant set of XLA and GL tables, consistent with its role in reversal accounting processing:

Usage Notes

As a private package, XLA_REVERSE_EVENTS_PVT_PKG is not invoked directly by end users or by most custom code. It is called by its public counterpart, XLA_REVERSE_EVENTS_PUB_PKG, which provides the supported entry points for reversal processing. In practice, this logic is triggered through the Subledger Accounting reversal functionality exposed on subledger transaction forms, through concurrent programs such as Create Accounting when reversal processing is required, and through the standard SLA reversal workflow. The ETRM metadata lists only two references: XLA_REVERSE_EVENTS_PUB_PKG and the package itself, confirming its private, internal role. Because of the direct manipulation of XLA_AE_HEADERS, XLA_AE_LINES, and related accounting tables, custom code should avoid calling these procedures directly and instead use the public API. This guidance applies to both Oracle EBS 12.1.1 and 12.2.2, since the object is documented as VALID in the APPS schema for these releases.