Search Results fa_xla_extract_trx_pkg




Overview
Explore in AI Chat

Overview

FA_XLA_EXTRACT_TRX_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports the integration between Oracle Assets (FA) and the Subledger Accounting (XLA) architecture. Its name follows the standard XLA extract naming convention, where the FA_XLA_ prefix identifies it as a component used to extract and stage Oracle Assets transaction data for consumption by the Subledger Accounting engine. In EBS 12.1.1 and 12.2.2, Subledger Accounting creates the accounting entries for asset additions, adjustments, retirements, transfers, and depreciation, and it requires source transaction data to be extracted from the operational asset tables into XLA staging structures.

The package header comment states that it is generated from FA AAD setups and carries a generation timestamp of 13-08-2013. This indicates that the package body contains logic that is automatically regenerated when the Asset Accounting Distributions (AAD) configuration is compiled, rather than being hand-maintained. It is classified as API classification OTHER in the ETRM metadata, meaning it is an internal support package rather than a public, customer-facing API.

The term "xamtra license" sometimes associated with this object relates to external or third-party licensing references and has no functional bearing on the package itself; the package is an Oracle-delivered, Oracle-proprietary component and is not separately licensed.

Key Procedures and Functions

The documented interface of FA_XLA_EXTRACT_TRX_PKG is deliberately minimal. Exactly one procedure is exposed in the package specification:

  • LOAD_DATA — the single entry point that drives the extraction of Oracle Assets transaction data for Subledger Accounting processing. When invoked, it reads the relevant FA source tables and loads the extracted transactions into the XLA staging/interface structures used by the accounting generation program. The metadata documents no parameters, so it should be treated as a parameterless driver procedure.

No additional functions or helper procedures are documented in the specification; any further logic resides in the generated package body and is not part of the declared interface.

Tables Accessed

The package reads from a broad set of Oracle Assets base and multi-currency tables, referenced through APPS synonyms. These include the core asset tables FA_ADDITIONS_B, FA_ADJUSTMENTS, FA_ASSET_HISTORY, FA_ASSET_INVOICES, and FA_DEPRN_PERIODS; the book-control and accounting-setup tables FA_BOOK_CONTROLS, FA_CATEGORY_BOOKS, and FA_DISTRIBUTION_ACCOUNTS; the historical and location tables FA_DISTRIBUTION_HISTORY and FA_LOCATIONS; reference lookups in FA_LOOKUPS; and the multi-currency (MC) variants FA_MC_ADJUSTMENTS, FA_MC_ASSET_INVOICES, FA_MC_BOOK_CONTROLS, and FA_MC_RETIREMENTS. Together these tables supply the transaction amounts, account distributions, book and period context, and reporting-currency balances that Subledger Accounting requires to build journal entries for asset events.

Usage Notes

FA_XLA_EXTRACT_TRX_PKG is an internal component that is normally invoked by the Subledger Accounting extraction programs rather than being called directly by end users. In practice it is executed in the context of the Create Accounting process for Oracle Assets, where the XLA extraction framework calls the package to populate staging data before accounting is generated. The ETRM metadata records that it is referenced by zero other packages, confirming that it is a leaf-level driver rather than a shared library.

Because it is generated from FA AAD setups, the package body may be regenerated during AAD configuration changes; customizations should therefore not be applied directly to the generated body. Any custom code that needs to trigger asset accounting extraction should call supported concurrent programs instead of invoking LOAD_DATA directly.