Fixed Assets - Columns: "Net Book Value" vs "NBV Before Impairment"

Chris Pfeifer

We are currently implementing Fixed Assets in Oracle Fusion ERP and would like assistance from FA SMEs as we have begun work on OTBI dashboards and reports:

The 23B Data Lineage spreadsheet for Financials indicates that Net Book Value should exist in Fixed Assets - Transactions Real Time > Impairment Details, but we do not see this column in the subject area in OTBI. Alternatively, the OTBI subject area shows a column called NBV Before Impairment that does not exist in the Data Lineage spreadsheet (see below link). Are these columns identical?

A Lotfy

Hello,

Yes.

RVohra

It is a while I worked on it but here are the few pointers that might help…

I am surprised you donot see this column in OTBI Metadata Dictionary.

Consult the 23C or 23D Data Lineage Update (Financials)
Oracle’s 24A/24B lineage spreadsheets confirm that “Net Book Value” was renamed to NBV Before Impairment for consistency with the FA_IMPAIRMENTS table.

Also run following Query:

SELECT asset_id, impairment_id, nbv_before_impairment, nbv_after_impairment
FROM fa_impairments;

Hope it helps!