Search Results xla_acct_setup_pub_pkg




Overview
Explore in AI Chat

Overview

XLA_ACCT_SETUP_PUB_PKG is a public PL/SQL package owned by the APPS schema in Oracle E-Business Suite Releases 12.1.1 and 12.2.2. It belongs to the Subledger Accounting (XLA) application and forms part of the Accounting Setup infrastructure that governs how subledger transactions are transformed into accounting entries. In EBS, the Accounting Setup Manager within the General Ledger responsibility defines accounting configurations, ledger options, and subledger accounting methods. The XLA_ACCT_SETUP_PUB_PKG package exposes this configuration programmatically so that other EBS modules can query and validate accounting setup data without directly accessing the underlying XLA entities. Its classification in the ETRM repository is "OTHER," indicating it is a published utility package rather than a fully documented open interface or validation API. The package is recorded with a VALID status, confirming it compiles successfully in the shipped 12.2.2 file system, and it is referenced by at least one other package, most notably GL_LEDGERS_PKG.

Key Procedures and Functions

The ETRM metadata documents two public subprograms for this package:

  • SETUP_LEDGER_OPTIONS — Handles the establishment or maintenance of ledger-related accounting options used by Subledger Accounting. Its purpose is to persist or confirm the accounting options associated with a ledger so that subledger transactions can be processed consistently with the configured accounting method, currency, and period conventions.
  • CHECK_ACCTG_METHOD_FOR_LEDGER — A validation routine that verifies whether an accounting method is properly assigned and applicable to a given ledger. This supports integrity checks during accounting setup and prevents invalid method-to-ledger combinations from proceeding into subledger processing.

No parameter lists or return signatures are published in the ETRM documentation; callers should treat these as internal-facing public APIs and avoid hard-coding assumptions about their signatures across releases.

Tables Accessed

The ETRM record for XLA_ACCT_SETUP_PUB_PKG does not enumerate specific base tables accessed through APPS synonyms. Its dependency listing shows only SYS.STANDARD at the schema level, and the package is referenced by GL_LEDGERS_PKG and by its own body. Functionally, a package of this name in Subledger Accounting operates against the XLA accounting setup entities — ledgers, ledger options, and subledger accounting methods — as reflected by the two documented routines, which deal explicitly with ledger options and accounting method validation.

Usage Notes

XLA_ACCT_SETUP_PUB_PKG is not intended for direct end-user invocation. It is typically invoked indirectly from Oracle General Ledger setup forms and concurrent processes, and from peer packages such as GL_LEDGERS_PKG, which depend on it for ledger-level accounting option handling. Because it is classified as a public package (PUB) in the APPS schema, it is a candidate for reuse by custom Subledger Accounting extensions, but such use should be restricted to verified signatures and should be regression-tested during upgrades between 12.1.1 and 12.2.2, where XLA and GL object definitions can differ. Developers should not modify the package; customizations should wrap or call it, relying on documented behavior only where ETRM confirms it.