Search Results setup_ledger_options

Overview

XLA_ACCT_SETUP_PKG is the Accounting Options Setup API within the Subledger Accounting (XLA) architecture of Oracle E-Business Suite. Its purpose is to establish and validate the accounting configuration that governs how a subledger ledger derives and stores accounting entries. The package provides the programmatic layer through which Accounting Methods, Application Accounting Definitions, and their associated event class setups are associated with a ledger, and through which those associations are removed when no longer applicable.

In Release 12, Subledger Accounting permits each ledger to be paired with an Accounting Method that determines which Application Accounting Definitions apply to each application and event class. The package encapsulates the validation and persistence logic for this configuration, replacing the legacy 11i subledger options. It is declared AUTHID CURRENT_USER, so all unqualified object references resolve against the calling schema's privileges, and it operates on the APPS synonyms listed below.

Because the Accounting Options determine which journal line types, account derivation rules, and journal entry categories the Create Accounting process will apply, incorrect setup produces missing or misclassified accounting entries rather than hard errors. The package is therefore a critical link between subledger configuration and downstream General Ledger postings.

Key Procedures and Functions

The package exposes six documented procedures. Parameter lists are not reproduced here; only purpose is described.

• SETUP_LEDGER_OPTIONS — Establishes the accounting options for a ledger across all applications, writing the ledger-level configuration consumed by the Subledger Accounting engine.
• CHECK_ACCTG_METHOD_FOR_LEDGER — The procedure most frequently sought by name. It validates whether the Accounting Method associated with a ledger (and its associated primary ledger) is legitimate for that ledger, raising an exception where the combination is invalid. This is the standard validation hook invoked before committing ledger options.
• PERFORM_EVENT_CLASS_SETUP — Creates or populates the event class setup for a given application and event class code, including the attributes and journal entry categories that drive accounting for that event class.
• DELETE_EVENT_CLASS_SETUP — Removes the event class setup for a given application and event class code.
• PERFORM_APPLICATION_SETUP_CP — The concurrent-program entry point for application setup; it wraps the setup logic so it can be launched as a batch job rather than interactively.
• UPGRADE_LEDGER_OPTIONS — Supports the Accounting (AX) upgrade path, migrating or rebuilding ledger options during release upgrade.

Tables Accessed

The package reads and writes configuration metadata through the following APPS synonyms:

• GL_LEDGERS — source of ledger and primary ledger identity and attributes.
• XLA_ACCTG_METHODS_B — the Accounting Method definition; read during method validation.
• XLA_LEDGER_OPTIONS — the ledger-to-accounting-method and application-level option records persisted by setup.
• XLA_EVENT_CLASSES_B and XLA_EVENT_CLASS_ATTRS — event class definitions and their attributes, maintained by the event class setup procedures.
• XLA_JE_CATEGORIES — journal entry categories associated with event class setups.
• XLA_SUBLEDGERS — identifies the applications participating in Subledger Accounting for the ledger.
• XLA_LAUNCH_OPTIONS — launch and processing options relevant to accounting program execution.

Usage Notes

XLA_ACCT_SETUP_PKG is normally invoked indirectly. The Accounting Setup Manager and related Subledger Accounting configuration forms call CHECK_ACCTG_METHOD_FOR_LEDGER to validate user selections and SETUP_LEDGER_OPTIONS to persist them. PERFORM_APPLICATION_SETUP_CP is designed for concurrent program invocation, and UPGRADE_LEDGER_OPTIONS runs as part of the upgrade driver. The package is referenced by three other packages, confirming it is a foundational API rather than a leaf utility.

Custom code should call the documented procedures only, and should invoke CHECK_ACCTG_METHOD_FOR_LEDGER before any options insert or update to avoid corrupt configuration. For the common search term check_acctg_method_for_ledger, note that this procedure performs validation only; it does not itself create or modify ledger options, so a successful call is a precondition rather than a setup step.