Search Results fazcbr_type

Overview

FA_CACHE_PKG is a core caching and utility package within the Oracle E-Business Suite Fixed Assets (FA) module. Its principal business function is to centralize the retrieval and in-memory caching of frequently referenced Fixed Assets configuration data — depreciation methods, calendars, ceilings, bonus rates, category book defaults, and set-of-books metadata — so that depreciation, asset book, and period-close processing avoid repeated, high-cost queries against the FA transactional tables.

The package defines an extensive set of PL/SQL record types (for example FAZCCP_TYPE for calendar periods, FAZCCL_TYPE for ceilings, FAZCBR_TYPE for bonus rules, FAZCDP_REC_TYPE for depreciation periods, and FAZCSOB_TYPE for set-of-books/MRC data) and exposes them through lightweight getter routines that populate global caches. A declared maximum array size of 200 bounds the batch size of cached rows. The package is unusually central: ETRM documentation records that it is referenced by 171 other packages, making it a foundational dependency for the majority of FA batch and online logic.

Key Procedures and Functions

ETRM documents 23 public objects. The procedures and functions are named using the FAZC prefix followed by a two- to four-character mnemonic indicating the data domain being cached:

• FAZCBC — accesses and caches book controls information, returning corporate/tax book mapping and control flags used to govern asset transfers between books.
• FAZCBCS — retrieves book controls in a summarized/set-based form for downstream processing.
• FAZCBC_CLR — the clear routine paired with FAZCBC; it resets the cached book-controls globals so subsequent calls repopulate fresh values. This is the object matching the search term fazcbc_clr.
• FAZCCP and FAZCCP_CLR — cache and clear calendar period data, including calendar name, fiscal year, date, and period counters.
• FAZCCL — caches ceiling records (ceiling name, date, year, and ceiling amount) used in tax depreciation computations.
• FAZCBR — caches bonus rule and bonus rate data, including primary and alternate depreciation factors.
• FAZCFF — caches depreciation method setup and flat-rate adjustment data spanning fiscal year and date ranges.
• FAZCSOB — caches set-of-books and MRC (Multiple Reporting Currency) set-of-books type codes.
• FAZCCT — caches calendar type configuration.
• FAZCCMT — caches depreciation method and method-level configuration data.
• FAZCCB — caches category book association data.
• FAZCCBD — caches category book default values.
• FAZCAT — caches asset category definitions.
• FAZSYS — caches system control options and global FA profile settings.
• FAZCTBK — caches corporate-to-tax book transfer rules, including CIP and immediate-copy flags.
• FAZCRSOB — caches the book-to-set-of-books mapping.
• FAZCCVT — caches depreciation convention type definitions.
• FAZCFY — caches fiscal year definitions.
• FAZCDP and FAZCDP_CLR — cache and clear depreciation period records, including period open/close dates, period counter, and the depreciation run indicator.

Tables Accessed

The package reads configuration and control tables through APPS synonyms. FA_BOOK_CONTROLS, FA_CATEGORY_BOOKS, and FA_CATEGORY_BOOK_DEFAULTS supply book and category book setup and defaults. FA_CALENDAR_TYPES, FA_CALENDAR_PERIODS, and FA_FISCAL_YEAR supply calendar and period definitions. FA_METHODS, FA_FORMULAS, FA_DEPRN_BASIS_RULES, and FA_DEPRN_RULE_DETAILS provide depreciation method, formula, and basis detail. FA_CEILINGS, FA_BONUS_RATES, and FA_CONVENTION_TYPES supply ceiling, bonus, and convention configuration. FA_CATEGORIES defines asset categories, and FA_SYSTEM_CONTROLS provides system-wide options. Reads dominate; the package caches rather than mutates, so direct writes are not expected.

Usage Notes

FA_CACHE_PKG is invoked internally by FA depreciation, asset book transfer, period-close, and reporting programs rather than being called directly from a form's UI logic. Concurrent programs such as depreciation and bonus processing, asset transfers, and period close rely on its getters to obtain configuration without re-querying the base tables for every asset row. Custom extensions that call FA public APIs benefit indirectly because those APIs route through the cache. The FAZCBC_CLR, FAZCCP_CLR, and FAZCDP_CLR clear procedures must be invoked whenever underlying setup changes during a session so that stale cached globals do not produce incorrect depreciation results.