Search Results upgrade_ledger_options

Overview

APPS.XLA_ACCT_SETUP_PKG is the Subledger Accounting (XLA) Accounting Options Setup package in Oracle E-Business Suite. Its stated purpose, per the embedded header comment ("XLA Accounting Options Setup"), is to default values for the accounting setup options that govern how Subledger Accounting processes and creates journal entries. The package body, stored under the file name xlasuaoi.pkb, supports the setup of ledger-level accounting options, accounting methods, journal entry categories, launch options, and event class configuration that the Create Accounting engine relies upon.

In EBS 12.1.1 and 12.2.2, XLA is the common accounting engine that receives subledger transactions and produces final accounting entries. Before that engine can generate entries for a ledger, its accounting options must exist and be consistent. XLA_ACCT_SETUP_PKG exists to seed and validate those options, ensuring that every applicable ledger and application has a complete, correctly defaulted set of accounting options rows. The package is classified in ETRM as OTHER, indicating it is an internal setup API rather than a published user-facing API, and it is referenced by three other packages.

Key Procedures and Functions

• SETUP_LEDGER_OPTIONS — Performs the ledger-level accounting option setup, populating the option rows required for a given ledger.
• CHECK_ACCTG_METHOD_FOR_LEDGER — Validates that an accounting method is available or correctly assigned for the ledger being configured.
• PERFORM_EVENT_CLASS_SETUP — Establishes event class setup data. This API was added in the 28-Sep-03 enhancement (bug 3151792) to extend the package into event class configuration.
• DELETE_EVENT_CLASS_SETUP — Removes event class setup data previously created, providing the inverse of the perform routine.
• PERFORM_APPLICATION_SETUP_CP — The concurrent-program entry point for application setup, added 10-Dec-03 (bug 3229146). It drives accounting option setup across applications.
• UPGRADE_LEDGER_OPTIONS — The upgrade routine users most commonly search for. It migrates or re-defaults existing ledger options to the currently required set, typically invoked during patch application or release upgrade so that pre-existing ledgers conform to the current XLA setup model.

Tables Accessed

The package reads and writes the core XLA and GL setup tables through APPS synonyms:

• GL_LEDGERS — Source of ledger identity and configuration for which options are created.
• XLA_LEDGER_OPTIONS — The primary target of ledger option setup and upgrade.
• XLA_ACCTG_METHODS_B — Accounting method definitions used by CHECK_ACCTG_METHOD_FOR_LEDGER.
• XLA_EVENT_CLASSES_B and XLA_EVENT_CLASS_ATTRS — Event class and event class attribute definitions for event class setup.
• XLA_JE_CATEGORIES — Journal entry category setup.
• XLA_LAUNCH_OPTIONS — Launch options controlling how accounting programs are submitted.
• XLA_SUBLEDGERS — Subledger application definitions that must be associated with the accounting setup.

Usage Notes

XLA_ACCT_SETUP_PKG is invoked indirectly. Users do not run it directly; it is called from the Accounting Setup Manager / Subledger Accounting setup forms when accounting options are created or updated for a ledger. PERFORM_APPLICATION_SETUP_CP is designed to be run as a concurrent program, making it the batch path for applying setup across applications. UPGRADE_LEDGER_OPTIONS is executed during upgrade or patching as part of the standard code that brings existing ledger options forward. Custom code should generally avoid direct calls, since the responsibility for consistent setup rests with the standard setup flows.