nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

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

AnandGN

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

Find more posts tagged with

Accepted answers

All comments

YGUTTIKONDA

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

is the group .. good luck

AnandGN

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

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

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

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

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