Search Results xla_aad_install_pvt




Overview
Explore in AI Chat

Overview

XLA_AAD_INSTALL_PVT is an internal private (PVT) PL/SQL package in the APPS schema that supports the installation, import, and export of Application Accounting Definitions (AADs) within the Oracle Subledger Accounting (XLA) architecture. An Application Accounting Definition is the central configuration object that binds accounting methods, product rules, and journal line definitions to a specific subledger application. Because these definitions are frequently transported between environments — for example, from a development instance to test or production — the package provides the lifecycle hooks required to load and unload AAD metadata through the standard XLA loader infrastructure.

The package is classified as private, meaning it is not a public supported API and is intended strictly for internal use by the XLA configuration migration framework. Its status is VALID in both Oracle EBS 12.1.1 and 12.2.2, where the Subledger Accounting setup and migration tools rely on it to orchestrate pre- and post-processing around bulk AAD transfers.

Key Procedures and Functions

  • PRE_IMPORT — Executed before an AAD import operation begins. It prepares the target environment by validating prerequisites and staging the inbound definition data so that downstream loader logic can process the records correctly.
  • POST_IMPORT — Executed after the import completes. It performs the follow-up processing necessary to reconcile the newly loaded AADs, including any post-load validation or state adjustment required before the definitions become usable.
  • PRE_EXPORT — Executed before an AAD export operation. It readies the source definition data for extraction, ensuring the AAD structure and its associated rules are in a consistent state for transport to a target environment.

These three procedures form a pre/post processing wrapper around the core XLA AAD loader, which handles the actual movement of definition rows. No public parameters are documented; the procedures are invoked by the XLA migration framework rather than directly by end users.

Tables Accessed

  • XLA_AAD_LOADER_DEFNS_T — The AAD loader definitions staging table that holds the definition header information being imported or exported.
  • XLA_AADS_GT — A global temporary table used to stage Application Accounting Definition rows during processing.
  • XLA_ACCTG_METHOD_RULES — Stores the accounting method rules associated with the AAD, read to assemble or validate the definition being moved.
  • XLA_PRODUCT_RULES_B — The base table for product rules that are part of the AAD structure.
  • GL_LEDGERS — The General Ledger ledgers table, consulted to resolve the ledger context for the accounting definitions.
  • FND_APPLICATION — The application registry, used to identify and validate the subledger application that owns the AAD.

Usage Notes

XLA_AAD_INSTALL_PVT is not invoked by end users or standard Oracle Forms. It is called internally by the XLA Application Accounting Definition migration and installation utilities, which are driven from Subledger Accounting setup responsibilities. In practice, administrators trigger AAD transfer through the concurrent programs and setup user interfaces that underpin Subledger Accounting configuration movement; those tools in turn invoke PRE_IMPORT, POST_IMPORT, and PRE_EXPORT as part of their processing flow. Custom code should not call this private package directly, as its interface is unsupported and subject to change between releases. It is referenced only within the APPS schema and depends on standard PL/SQL package STANDARD; the ETRM metadata records no other packages referencing it, confirming its role as a leaf-level internal component of the XLA installation framework.