Search Results deferred_deprn_reserve_acct




Overview
Explore in AI Chat

Overview

APPS.FABV_BOOKS is a reporting and integration view in Oracle E-Business Suite Release 12.1.1 and 12.2.2 that presents the full set of depreciation book control attributes defined in Oracle Assets. The view exposes one row per depreciation book, keyed by BOOK_TYPE_CODE, and consolidates the configuration flags, accounting flexfield references, journal entry (JE) category assignments, calendar references, and system control options that govern how a book behaves during depreciation, amortization, revaluation, retirement, transfer, and mass-copy processing.

The view is named "FABV" to denote an Assets (FA) Business View. Its primary role is to provide a stable, read-only interface for reports, concurrent programs, Flexfields, and third-party integrations that require book-level setup information without directly querying the transactional control table. Because the view selects from the FA_BOOK_CONTROLS synonym, it inherits the security and the setup data maintained through the Book Controls window in the Oracle Assets application. The presence of the JE_DEPRECIATION_CATEGORY column makes this view a frequent reference point for users researching how depreciation journal entries are categorized and posted to the General Ledger.

Underlying Base Objects

According to the documented ETRM metadata, FABV_BOOKS is defined exclusively over the synonym FA_BOOK_CONTROLS, which resolves to the APPS-owned base table FA_BOOK_CONTROLS in the Oracle Assets schema. The view performs a direct column projection with no joins, aggregations, or filters, so all rows in the base table are returned. This one-to-one relationship means the view is effectively a named, read-consistent presentation of the book controls record. Any update to book setup in FA_BOOK_CONTROLS is immediately reflected the next time the view is queried, subject to the usual transaction and commit semantics of the underlying session.

Key Columns

Common Use Cases and Queries

The view is typically queried to validate book setup, to diagnose journal entry generation problems, and to drive reporting that depends on category or account configuration. A common pattern is to confirm which JE category is assigned to depreciation for a given book:

  • SELECT book_type_code, book_type_name, je_depreciation_category, gl_je_source FROM apps.fabv_books WHERE book_type_code = :book;
  • SELECT book_type_code, je_depreciation_category, je_addition_category, je_retirement_category FROM apps.fabv_books WHERE set_of_books_id = :sob_id;
  • SELECT book_type_code, deprn_calendar, prorate_calendar, book_class FROM apps.fabv_books ORDER BY book_type_code;
  • SELECT book_type_code, allow_deprn_adjustments, allow_mass_changes FROM apps.fabv_books WHERE amortize_flag = 'Y';

Typical applications include reconciliation of assets journal entries against GL, preparation of depreciation run checklists, and integration extracts that feed downstream reporting warehouses. Because the view returns all configured books, queries should always be filtered by BOOK_TYPE_CODE or SET_OF_BOOKS_ID to limit the result set to the books relevant to the reporting context.