Fixed Assets - EBS (MOSC)

MOSC Banner

What table to find the current YTD Depreciation amount for fully depreciated assets?

edited Jan 31, 2025 8:38AM in Fixed Assets - EBS (MOSC) 27 commentsAnswered
I am trying to develop a Discoverer report to show assets with the depreciation information.  However, I have found a situation where if an asset is fully depreciated in 2012, and I am running the report in 2013, I am still getting the YTD depreciation amount from 2012.  I am expecting the YTD Depreciation amount to be $0.00 in 2013 since it was fully depreciated in 2012.

I am using the FA_DEPRN_SUMMRY table to find the last record for that asset.  But I am getting the last depreciation record in 2012 as the last record in this table and the YTD_DEPRN column shows a value instead of 0.00 since it does not continue to create new records with 0.00 in the YTD_DEPRN column.  In the Financial Inquiry form FAXOLFIN, the YTD Depreciation shows 0.00.  I am wanting to get this value.  Where can I find this value in the tables or views?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center