Search Results fa_cache_pkg




Overview
Explore in AI Chat

Overview

APPS.FA_CACHE_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 (FA) product family and serves as a centralized in-memory cache manager for the setup and control data that the Oracle Assets depreciation and asset maintenance engines require repeatedly during processing. Rather than re-querying slow-moving configuration tables such as books, calendars, categories, methods, and conventions for every asset processed, the package loads this reference data into PL/SQL memory structures and exposes it through a set of accessor routines.

The object is classified as an OTHER API within the ETRM repository and holds a VALID status. Its dependency footprint is broad: it references 171 other packages, and it is itself referenced by 171 packages, making it one of the most heavily consumed internal utilities in the Oracle Assets code base. The package works closely with the FA_CACHE_PKG specification, the FA_API_TYPES package for shared record and table type definitions, and the FND_LOG and FND_PROFILE utilities for debugging and environment resolution.

Key Procedures and Functions

The documented interface exposes 23 procedures and functions. Their naming convention uses the FAZ prefix, typical of internal Oracle Assets cache helpers. The principal routines include:

  • FAZCBC — caches book control information, providing fast lookup of book-level accounting and depreciation rules.
  • FAZCBCS — a companion routine operating on book controls, likely returning a cached set or summarized form used by callers iterating across books.
  • FAZCBC_CLR — clears the cached book control entries, forcing a refresh on the next request.
  • FAZCCMT — caches calendar type definitions.
  • FAZCCP — caches calendar period information used to resolve accounting and depreciation periods.
  • FAZCAT — caches asset category definitions.
  • FAZCCB — caches category-to-book assignment data.
  • FAZCCBD — caches category book default values.
  • FAZCCT — caches convention type data controlling prorated depreciation.
  • FAZCFF — caches depreciation formulas.
  • FAZCCL — caches ceilings used by depreciation methods.
  • FAZCBR — caches bonus rate definitions.
  • FAZCSOB — caches set of books information, including MRC-related book controls.
  • FAZSYS — caches system control options governing Oracle Assets behavior.
  • FAZCTBK — caches tax book information.
  • FAZCRSOB — caches reporting set of books data.
  • FAZCCVT — caches convention values.
  • FAZCFY — caches fiscal year definitions.
  • FAZCDP — caches depreciation period information.
  • FAZCDP_CLR — clears the cached depreciation period data.

The _CLR variants are significant: they signal that cached values may become stale after maintenance operations and must be explicitly invalidated.

Tables Accessed

The package reads from a defined family of Oracle Assets setup tables, accessed through APPS synonyms. These include FA_BOOK_CONTROLS and the MRC view FA_BOOK_CONTROLS_MRC_V; FA_CALENDAR_TYPES and FA_CALENDAR_PERIODS; FA_CATEGORIES, FA_CATEGORY_BOOKS, and FA_CATEGORY_BOOK_DEFAULTS; FA_CONVENTION_TYPES; FA_DEPRN_BASIS_RULES, FA_DEPRN_RULE_DETAILS, and FA_DEPRN_PERIODS; FA_FISCAL_YEAR; FA_FORMULAS; FA_METHODS; FA_CEILINGS; FA_BONUS_RATES; FA_SUPER_GROUP_RULES; FA_SYSTEM_CONTROLS; FA_MC_BOOK_CONTROLS; and GL_SETS_OF_BOOKS for ledger identification. The package is primarily a reader of these tables; its caching model assumes they change infrequently and that cached copies remain valid until explicitly cleared. It also touches the FA_CACHE_PKG specification itself, the PLITBLM PL/SQL table utility, and FA_SRVR_MSG.

Usage Notes

FA_CACHE_PKG is an internal utility rather than a public API. It is invoked transparently by Oracle Assets forms, concurrent programs such as depreciation and period close processing, and the many packages that depend on it. Custom code should not call it directly or depend on its interface, since the cache contract is undocumented and the procedure signatures are not published. Developers debugging Oracle Assets performance or behavior should be aware that a stale cache may explain unexpected values; in such cases the appropriate resolution is to re-invoke the relevant FAZC*_CLR clearing routine or restart the session. Because the package is referenced by 171 objects Compile failures in FA_CACHE_PKG can cascade across much of the Oracle Assets module, making it a critical object during patching and upgrades.