Search Results annual_deprn_rounding_flag




Overview
Explore in AI Chat

Overview

APPS.FA_SXL_BOOKS_V is a filtered view over the Oracle Assets depreciation books table, FA_BOOKS. In Oracle E-Business Suite 12.1.1 and 12.2.2, it is used by the Asset Revaluation and Rate Adjustment processing logic. The view isolates asset book records that satisfy a specific set of conditions indicating that a rate adjustment or related revaluation processing condition applies. Rather than presenting every depreciation book row, FA_SXL_BOOKS_V surfaces only the subset of records that meet its filtering predicate, which is significant for users investigating the salvage_value column, since the view explicitly requires SALVAGE_VALUE to be non-zero.

The view is owned by the APPS schema and is exposed through a synonym over the base FA_BOOKS table. It is not intended as a general-purpose reporting view; instead it supports the internal rate adjustment / salvage value recalculation path within Oracle Assets.

Underlying Base Objects

The only documented base object referenced by this view is FA_BOOKS, accessed through a synonym. FA_BOOKS stores one row per asset per depreciation book, holding cost, salvage value, depreciation method, life, and adjustment tracking columns. FA_SXL_BOOKS_V selects a defined column subset from FA_BOOKS and applies a restrictive WHERE clause that leaves only records satisfying all of the following:

Because the view projects ROWID as ROW_ID and does not join to other tables, it is a single-table filtered projection rather than a join view.

Key Columns

The columns exposed by FA_SXL_BOOKS_V correspond directly to FA_BOOKS attributes:

  • ROW_ID — the ROWID of the underlying FA_BOOKS row.
  • BOOK_TYPE_CODE — the depreciation book identifier.
  • ASSET_ID — the unique asset identifier.
  • SALVAGE_VALUE — the asset's salvage value; the view requires this to be non-zero.
  • ADJUSTED_RATE — the adjusted depreciation rate applied to the asset.
  • ADJUSTED_COST — the adjusted cost basis.
  • LIFE_IN_MONTHS — the asset life expressed in months.
  • DATE_INEFFECTIVE — the date the book record became ineffective; always NULL within this view.
  • RATE_ADJUSTMENT_FACTOR — the factor governing rate adjustment; constrained to values less than or equal to one.
  • LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — audit columns.
  • PERIOD_COUNTER_FULLY_RESERVED and PERIOD_COUNTER_LIFE_COMPLETE — period counters tracking full reservation and life completion.
  • ANNUAL_DEPRN_ROUNDING_FLAG — controls annual depreciation rounding behavior.

Common Use Cases and Queries

A typical application of this view is diagnosing assets with salvage values that participated in rate adjustment calculations. A representative query lists the assets in a given book with a non-zero salvage value whose life is complete:

  • SELECT asset_id, book_type_code, salvage_value, adjusted_rate, adjusted_cost, rate_adjustment_factor FROM apps.fa_sxl_books_v WHERE book_type_code = :book AND asset_id = :asset_id;
  • SELECT book_type_code, COUNT(*) FROM apps.fa_sxl_books_v GROUP BY book_type_code;

These queries help validate that the view is returning only the records that meet the documented filter conditions. Because the view restricts SALVAGE_VALUE to non-zero values, it is particularly useful when investigating salvage value adjustments and their interaction with rate adjustment factors.