Search Results fa_load_tbl_pkg




Overview
Explore in AI Chat

Overview

FA_LOAD_TBL_PKG is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It belongs to the Oracle Assets (Fixed Assets, FA) product family and is classified in the ETRM repository as an "OTHER" API component, meaning it is an internal server-side utility rather than a published, externally supported interface.

The package's primary responsibility is to stage and cache data into transient global temporary table structures used by the Oracle Assets depreciation and distribution engines. It moves asset distribution lines, invoice lines, and depreciation rule definitions into working storage, and it supplies lookup logic that resolves the correct depreciation rule for a given asset category, book, and asset positioning. The presence of dedicated counter-reset routines indicates the package manages in-memory or session-level counters that track how many rows have been loaded, so the calling program can iterate through the staged set deterministically.

The dependency list confirms the package is a self-contained helper: it references only FA_API_TYPES, FA_BOOK_CONTROLS, FA_CATEGORY_BOOKS, FA_CATEGORY_BOOK_DEFAULTS, FA_SRVR_MSG, FND_LOG, and the standard PLITBLM package. The ETRM metadata records that FA_LOAD_TBL_PKG is not referenced by any other database object directly, though it is invoked by eight other packages. Its status is VALID.

Key Procedures and Functions

  • LOAD_DIST_TABLE — Populates the distribution staging table. It reads asset distribution rows and writes them into a temporary structure for downstream processing by capitalization, transfer, or retirement logic.
  • LOAD_INV_TABLE — Populates the invoice staging table, moving source invoice lines into working storage so that the asset creation and cost adjustment routines can process them in bulk.
  • RESET_G_DIST_COUNT — Resets the package-level global counter associated with the distribution staging table, allowing a subsequent LOAD_DIST_TABLE invocation to start from a clean index.
  • RESET_G_INV_COUNT — Resets the package-level global counter for the invoice staging table, mirroring the distribution counter behavior.
  • LOAD_DEPRN_RULES_TBL — Loads depreciation rule definitions into the depreciation rules staging table for a given category/book context.
  • GET_DEPRN_RULES — Returns the depreciation rules associated with the current staging context, exposing the loaded rule set to the caller.
  • FIND_POSITION_DEPRN_RULES — Resolves the depreciation rule applicable to a specific asset position, using the category-book and category-book-default mappings to locate the correct rule.

Tables Accessed

  • FA_BOOK_CONTROLS — Provides book-level setup data, including the depreciation calendar and book type, needed to select the correct depreciation rules.
  • FA_CATEGORY_BOOKS — Supplies the association between an asset category and an asset book, which drives rule resolution in FIND_POSITION_DEPRN_RULES.
  • FA_CATEGORY_BOOK_DEFAULTS — Holds the default depreciation rule assignments used when no explicit position-level rule exists.
  • PLITBLM — The standard Oracle-supplied temporary table used by FA_LOAD_TBL_PKG as its primary staging surface for distribution and invoice line data.

Usage Notes

FA_LOAD_TBL_PKG is not an end-user-facing API. It is invoked internally by Oracle Assets server-side programs — most notably the depreciation, capitalization, and mass additions processes — and by the eight dependent packages recorded in the ETRM repository. Typical call sequences begin with a RESET_G_*_COUNT call, followed by the corresponding LOAD_* routine, then iteration against the staged rows. Errors are surfaced through FA_SRVR_MSG and diagnostic output is written via FND_LOG.

Because the package depends on session-level globals and the PLITBLM temporary table, callers must execute the reset and load routines within the same database session to maintain counter integrity. Customizations should avoid direct invocation; the supported extension points remain the public FA APIs. Any modification to this package body risks invalidating the eight dependent packages and should be treated as an unsupported customization.