Search Results fabv_books

Overview

FABV_BOOKS is a public view owned by the APPS schema within the Oracle Assets (OFA) module of Oracle E-Business Suite. In both Release 12.1.1 and 12.2.2, the view presents a denormalized, read-oriented image of the depreciation book controls defined for the installation. Each row returned by FABV_BOOKS corresponds to one depreciation book, identified by its book type code, and exposes the configuration flags, calendars, journal entry categories, account derivation sources, and intercompany settings that govern how that book is processed. The view is classified as VALID and is reported in the ETRM documentation as a query surface over a single synonym, which makes it a lightweight and stable access point for both reporting and integration.

The naming convention follows the FA module convention, where the "FABV" prefix distinguishes a view over the underlying book controls table. Its role is primarily that of a reporting and reference view: it allows concurrent programs, forms, and external integrations to read book configuration without directly querying the base table or replicating the column list of the physical entity. Because depreciation book configuration changes rarely but is referenced frequently, a view of this kind reduces coupling between dependent code and the underlying physical model.

Underlying Base Objects

According to the documented ETRM metadata, FABV_BOOKS is defined over the synonym FA_BOOK_CONTROLS, which resolves to the APPS-owned base table that stores depreciation book control information. The view text is a direct, unpivoted selection from that table; every column projected by the view maps one-to-one to a column in FA_BOOK_CONTROLS. No joins, unions, or aggregations appear in the view definition, so a query against FABV_BOOKS incurs the same access path cost as the equivalent query against the base table, with the additional benefit of a curated and stable column list.

Because the underlying object is referenced through a synonym rather than a fully qualified table name in the documented metadata, the view remains portable across environments where the APPS synonym is maintained by the standard installation and upgrade utilities. Both 12.1.1 and 12.2.2 preserve the same structure, and the view carries no editioning or cross-edition complications beyond the standard APPS schema conventions introduced in 12.2.

Key Columns

• BOOK_TYPE_CODE — The primary identifier of the depreciation book. This is the value most consumers filter on.
• BOOK_TYPE_NAME — The user-friendly name of the book, exposed as BOOK_NAME in the documented column list.
• BOOK_CLASS — Classifies the book, for example as a corporate or tax book, and is the column matched by the user search term "book_class". It drives downstream behavior such as tax-specific processing.
• DEPRN_CALENDAR and PRORATE_CALENDAR — The depreciation and prorate calendars assigned to the book.
• INITIAL_DATE and LAST_DEPRN_RUN_DATE — The book's start date and the most recent depreciation run date.
• GL_POSTING_ALLOWED_FLAG — Indicates whether journal entries may be posted to the General Ledger for this book.
• SET_OF_BOOKS_ID — The ledger to which the book is associated, providing the link into GL.
• ALLOW_MASS_CHANGES, ALLOW_DEPRN_ADJUSTMENTS, ALLOW_MASS_COPY, ALLOW_PURGE_FLAG, ALLOW_REVAL_FLAG — Operational control flags governing permitted actions.
• JE_*_CATEGORY columns — Journal entry categories for additions, adjustments, transfers, retirements, reclassifications, revaluations, and CIP events.
• DISTRIBUTION_SOURCE_BOOK, MASS_COPY_SOURCE_BOOK, MC_SOURCE_FLAG — Source book references used by mass copy and distribution processes.
• Accounting columns such as PROCEEDS_OF_SALE_*, NBV_RETIRED_*, COST_OF_REMOVAL_*, and REVAL_RSV_RETIRED_* — Gain, loss, and clearing accounts used by retirement and revaluation flows.

Common Use Cases and Queries

The most frequent use of FABV_BOOKS is configuration lookup: determining which books are corporate books, which are tax books, and which calendars or ledgers they use. A typical query filtering on the book class is:

• SELECT book_type_code, book_type_name, book_class, deprn_calendar FROM fabv_books WHERE book_class = 'CORPORATE';
• SELECT book_type_code, last_deprn_run_date FROM fabv_books ORDER BY last_deprn_run_date DESC;
• SELECT book_type_code, set_of_books_id FROM fabv_books WHERE gl_posting_allowed_flag = 'Y';

Other scenarios include validating that a book permits depreciation adjustments before running automated mass adjustments, identifying source books for mass copy or distribution, and reporting the journal entry categories in use. Because the view is a thin projection of FA_BOOK_CONTROLS, it is appropriate for both ad hoc query and embedded use in custom concurrent programs.