Search Results fa_xla_extract_util_pkg




Overview
Explore in AI Chat

Overview

FA_XLA_EXTRACT_UTIL_PKG is an Oracle EBS Fixed Assets utility package that bridges the subledger accounting (XLA) extract process and the Fixed Assets transaction data model. Its header declares AUTHID CURRENT_USER, confirming it executes under the privileges of the invoking session rather than its owner, which is essential when it is called from subscription routines, stub programs, and custom code running in the caller's schema context. The package is classified as OTHER in the ETRM metadata, indicating that it is not a public open interface, rather an internal engine invoked by the Fixed Assets accounting program and by the locking_status and preaccounting subscription routines.

Functionally, the package performs three broad duties: it manages the asset locking state used to protect books and ledgers during accounting extraction, it maintains non-accountable events that must be recorded without generating journal entries, and it invokes the main extract routine that converts Fixed Assets transactions into XLA events for accounting and transfer to the General Ledger. A set of package-level global booleans (G_trx_exists, G_inter_trx_exists, G_dep_exists, G_def_exists, G_fin_trx_exists, G_xfr_trx_exists, G_dist_trx_exists, G_ret_trx_exists, G_res_trx_exists, G_deprn_exists, and G_rollback_deprn_exists) tracks which transaction categories are present in the extract scope, while feature flags such as G_alc_enabled, G_group_enabled, G_sorp_enabled, and G_secondary_special expose whether Advanced Global Intercompany System (AGIS), grouping, and secondary ledger special behaviors apply.

Key Procedures and Functions

The package exposes four documented entry points:

  • LOCK_ASSETS — Acquires the accounting lock for a specified book type code and ledger identifier. It is invoked from the locking_status subscription routine to prevent asset changes while extraction is in progress.
  • UNLOCK_ASSETS — Releases the lock previously taken by LOCK_ASSETS, allowing normal asset maintenance to resume once extraction completes. It is the complementary stub called from the locking_status subscription routine.
  • UPDATE_NONACCOUNTABLE_EVENTS — Processes and records non-accountable FA events, preserving an audit trail for activity that does not generate journal entries. It is invoked from the preaccounting subscription routine.
  • EXTRACT — The central extract routine that reads Fixed Assets transactions and writes the corresponding XLA event records for downstream accounting creation.

Tables Accessed

The package reads and writes the following documented objects (through APPS synonyms):

Usage Notes

FA_XLA_EXTRACT_UTIL_PKG is invoked indirectly during the Fixed Assets accounting cycle — specifically when the Create Accounting process runs for the Fixed Assets application — and directly through the locking_status and preaccounting subscription routines registered with the XLA event model. It is referenced by four other packages, indicating its utility role as a shared helper for extraction, locking, and event staging. Because it is AUTHID CURRENT_USER and relies on global booleans for transaction-category detection, custom code should call it only after confirming that the target book and ledger are fully set up and that no concurrent extract is running. Debugging typically begins by inspecting the G_* globals returned after EXTRACT and by reviewing the XLA_EVENTS rows produced for the transaction entity in question.