Oracle Transactional Business Intelligence

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Transactional Business Intelligence

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

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

Received Response
66
Views
2
Comments
Chris Pfeifer
Chris Pfeifer Rank 5 - Community Champion
in Oracle Transactional Business Intelligence

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?

Tagged:

Answers

  • A Lotfy
    A Lotfy Rank 1 - Community Starter

    Hello,

    Yes.

  • RVohra
    RVohra Rank 6 - Analytics Lead

    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!