Search Results xla_debug_trace

Overview

APPS.XLA_ACCT_SETUP_PUB_PKG is the public setup API for the Subledger Accounting (XLA) engine in Oracle E-Business Suite 12.1.1 and 12.2.2. Subledger Accounting requires that accounting options be established for each combination of subledger application and ledger before journal entries can be generated, transferred to General Ledger, and reported against. This package provides the supported programmatic entry point for creating and validating that configuration, insulating callers from the internal tables and validation logic owned by the XLA schema.

The package body carries a header dated 2003 with an original author entry of Dimple Shah, confirming that the API has been part of the XLA foundation layer since the initial 11i/R12 subledger architecture and has remained stable across the 12.1.1 and 12.2.2 releases. It is owned by APPS, and the metadata classifies it as OTHER rather than as a general-purpose open interface, reflecting its role as an internal setup utility exposed for controlled reuse.

Key Procedures and Functions

The documented interface consists of two callable units:

• SETUP_LEDGER_OPTIONS — Establishes accounting options for all subledger applications associated with a given ledger. The procedure accepts a primary ledger identifier and a ledger identifier as its inputs, both NUMBER, and performs the setup in a single call rather than requiring the caller to loop over applications. This is the procedure most relevant to the search term p_ledger_id, since the parameter appears directly in its signature and is echoed to the trace output at level 20.
• CHECK_ACCTG_METHOD_FOR_LEDGER — Validates the accounting method configuration for a ledger, allowing callers to confirm that a ledger is correctly set up before subledger transactions are processed against it.

The body also contains a private trace helper that writes to XLA_UTILITY_PKG.TRACE when the profile option XLA_DEBUG_TRACE is set to Y, and that converts unexpected errors into messages raised through XLA_EXCEPTIONS_PKG.

Tables Accessed

The ETRM metadata for this object does not enumerate referenced tables, and none are listed via APPS synonyms. In practice the package reads and writes the XLA accounting options tables — principally XLA_LEDGER_OPTIONS and its associated application and method configuration tables — and consults ledger and accounting method definitions to determine what setup rows are required. Because the object is documented as a public API rather than a reporting view, direct table access should be treated as an implementation detail that Oracle may change without notice.

Usage Notes

The procedure is invoked during implementation and maintenance of Subledger Accounting, typically after a ledger has been defined and before subledger transactions are accounted. In standard EBS, the equivalent configuration is performed through the Accounting Options setup pages in the Subledger Accounting responsibility; the API exists so that the same setup can be scripted, replicated across environments, or embedded in custom onboarding routines.

Custom code should call the package through the APPS schema and pass the ledger identifiers explicitly, as demonstrated by the trace statements referencing p_ledger_id and p_primary_ledger_id. Callers should expect the API to raise XLA_EXCEPTIONS_PKG messages on validation failure and should not bypass the procedure to insert setup rows directly. Because only one package is documented as referencing this API, its use is narrowly scoped, and any custom invocation should be tested carefully against the target release.