Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Computing the Net Book Value for a fixed asset: Querying a Table column or creating external calcula

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
-
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.
0 -
-
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
0 -
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
0 -
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.
0 -
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
0 -
were you able to find the group and post your question ?
0