Search Results basic_rate




Overview
Explore in AI Chat

Overview

The FABV_ASSET_BKS view is a read-only reporting object in the Oracle E-Business Suite (EBS) Assets (OFA) module, owned by the APPS schema. It is documented in ETRM for both 12.1.1 and 12.2.2 with the description qualifier "Retrofitted," indicating that the object was carried forward into a later release line. The view presents a filtered projection of the FA_BOOKS table, exposing the depreciation and financial attributes associated with assets that have a pending, unprocessed transaction header and remain effective as of the current date. Specifically, it restricts output to rows where TRANSACTION_HEADER_ID_OUT IS NULL and DATE_INEFFECTIVE IS NULL.

The presence of the PERIOD_COUNTER_CAPITALIZED column in the projection makes the view directly relevant to the searched term. This column is part of the depreciation lifecycle "period counter" family (PERIOD_COUNTER_CAPITALIZED, PERIOD_COUNTER_FULLY_RESERVED, PERIOD_COUNTER_FULLY_RETIRED, and PERIOD_COUNTER_LIFE_COMPLETE) and allows reporting on assets that have been capitalized in a given period. The view serves as a convenient, security-consistent interface for ad hoc reporting, reconciliation, and downstream integration without requiring direct queries against the base table.

Underlying Base Objects

According to the documented ETRM metadata (12.2.2), the view is defined over a single referenced base object: FA_BOOKS, accessed through a SYNONYM in the APPS schema. FA_BOOKS stores asset book-level financial and depreciation information, with one row per asset per book. The view's defining query selects specific columns from FA_BOOKS and applies two mandatory filters:

  • TRANSACTION_HEADER_ID_OUT IS NULL — excludes rows that have been through the outbound transaction stage, isolating assets with a pending inbound header (TRANSACTION_HEADER_ID_IN).
  • DATE_INEFFECTIVE IS NULL — excludes rows that have been logically inactivated, ensuring only currently effective records are returned.

The WITH READ ONLY clause enforces that the view cannot be used for DML, making it suitable for query and reporting workloads only. Because it is a straightforward projection of FA_BOOKS with no joins, no aggregation, and no group-by, the view preserves the grain of the underlying table and remains inexpensive to query.

Key Columns

The view exposes a broad set of depreciation and accounting attributes. Notable columns include:

Common Use Cases and Queries

The view supports period closing, capitalization analysis, and reconciliation reporting. A typical query listing assets capitalized in a specific period is:

SELECT asset_id, book_type_code, period_counter_capitalized, cost, date_placed_in_service
FROM   apps.fabv_asset_bks
WHERE  period_counter_capitalized = :p_period_counter;

Because the view already filters on transaction and effective-date status, it is well suited to integration extracts that feed downstream subledgers or reporting databases. Analysts may combine it with FA_ADDITIONS or period-mapping views to translate the counter into a calendar period. Given the read-only definition and its dependence on FA_BOOKS filtering, performance is generally optimal when queries restrict on BOOK_TYPE_CODE or ASSET_ID to leverage the underlying table's indexing.