Computing the Net Book Value for a fixed asset: Querying a Table column or creating external calcula — Oracle Analytics

Oracle Analytics Cloud and Server

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

Computing the Net Book Value for a fixed asset: Querying a Table column or creating external calcula

Received Response
825
Views
7
Comments

Summary

Computing the Net Book Value for a fixed asset: Querying a Table column or creating external calculation -BI Publisher

Content

Hi,

I am trying to use the "FA_" tables for fixed assets to create some information at the "date of run" that goes like

Asset ID, Asset_Orginal_Cost  Asset_Useful_Life, Asset_remaining_life, Accumalated_deprn, Net_Book_Value

I was able to find the following

Asset ID, Asset_Original_Cost,Asset_Accumalated_Deprn ( FA_DEPRN_SUMMARY)

Asset_Useful_life using STL (FA_METHODS)

Question: How can I get the Current Book Value( Orginal Cost-Accum Deprn) and Remaining life (Date Acquired-date of run) ?

Are there table columns that can give me this ( latest or former periods-date tracked) or are these to be calculated externally in BI Publisher using the Formulae I put in the brackets next to the needed values?

I am thinking there should be a way to query these from FA_tables? Kindly help me with which are the relevant tables needed here.

I am using Oracle Cloud , R12 and using BI Publisher to form the report.

Thanks & Regards,

Anand

Answers

  • YGUTTIKONDA
    YGUTTIKONDA Rank 6 - Analytics Lead

    Anand - you can do calculation in BI Publisher if its based on the values already in the data set , but if you are looking for help on how to formulate query on the application side please post it in the right group.

  • YGUTTIKONDA
    YGUTTIKONDA Rank 6 - Analytics Lead

      is the group .. good luck

  • AnandGN
    AnandGN Rank 2 - Community Beginner

    HI ,

    Yes. I am trying to seek which would the relevant fixed asset tables that will contain these values ( Depreciated Book Value, Remaining life)  so that I can complete my BI Publisher query. Would you be able to guide me on which would be the correct group to query this question?

    Thanks,

    Anand

  • AnandGN
    AnandGN Rank 2 - Community Beginner

    I had already come across this in my research and it does not look at NBV. But I think its a on-the fly calc too. Thanks anyways.

    Thread is closed.

    Regards,

    Anand

  • YGUTTIKONDA
    YGUTTIKONDA Rank 6 - Analytics Lead

    Anand - Check the below for some info

    https://www.linkedin.com/pulse/20140822115435-19818376-key-tables-fa

    My assumption is this may be a on the fly calculation, may be check with your functional team for more info ..

    Since this is not the right group i would suggest to mark it and close.

  • AnandGN
    AnandGN Rank 2 - Community Beginner

    HI,

    I did post it in EBS group and Oracle Fusion Financials. Not sure if there are other groups that are more relevant.

    I have not yet received any hits on the question. Seems like there is no FA apps table that lists Book Value of an asset by year.

    Thanks,

    Anand

  • YGUTTIKONDA
    YGUTTIKONDA Rank 6 - Analytics Lead

    were you able to find the group and post your question ?