Revaluation in Oracle Fixed Assets

REVALUATION IN ORACLE FIXED ASSETS
The asset cost is $10,000, the life is 5 years, and using straight-line depreciation.
In Year 2, Quarter 1 you revalue the asset using a revaluation rate of 5%.
Then in Year 4, Quarter 1 you revalue the asset again using a revaluation rate of -10%
Period(Yr,Qtr)	Asset Cost	Depreciation Exp.	Acc. Depreciation Exp.	Revaluation Reserve
Yr1, Qtr1	10,000	500	500	0
Qtr2	10,000	500	1000	0
Qtr3	10,000	500	1500	0
Qtr4	10,000	500	2000	0
Sum		2000
Revaluation by 10%... => Cost * 10% = 500
Reval.1 => 5%	10,500	0.00	2100	400
Period(Yr,Qtr)	Asset Cost	Depreciation Exp.	Acc. Depreciation Exp.	Revaluation Reserve
Yr2, Qtr1	10,500	525	2625	400
Qtr2	10,500	525	3150	400
Qtr3	10,500	525	3675	400
Qtr4	10,500	525	4200	400
Sum		2100
Period(Yr,Qtr)	Asset Cost	Depreciation Exp.	Acc. Depreciation Exp.	Revaluation Reserve
Yr3, Qtr1	10,500	525	4725	400
Qtr2	10,500	525	5250	400
Qtr3	10,500	525	5775	400
Qtr4	10,500	525	6300	400
Sum		2100
Revaluation by -10%... => Cost * -10% = -1050
Reval.1 => 5%	9,450	0.00	5670	-20
Period(Yr,Qtr)	Asset Cost	Depreciation Exp.	Acc. Depreciation Exp.	Revaluation Reserve
Yr4, Qtr1	9,450	472.5	6142.5	-20
Qtr2	9,450	472.5	6615	-20
Qtr3	9,450	472.5	7087.5	-20
Qtr4	9,450	472.5	7560	-20
Sum		1890
Period(Yr,Qtr)	Asset Cost	Depreciation Exp.	Acc. Depreciation Exp.	Revaluation Reserve
Yr5, Qtr1	9,450	472.5	8032.5	-20
Qtr2	9,450	472.5	8505	-20
Qtr3	9,450	472.5	8977.5	-20
Qtr4	9,450	472.5	9450	-20
Sum		1890
Retirement
	0	0	0	-20
Oracle Assets Revaluation		Year2, Revaluation by 10%
			Dr	Cr
	Asset Cost		500
		Revaluation Reserve		400
		Acc.Depr.Expense		100
Oracle Assets Revaluation		Year4, Revaluation by -10%
			Dr	Cr
	Revaluation Reserve		420
	Acc.Depr.Expense		630
		Asset Cost		1050

Acc. Depre.Exp =  Existing Acc. Depre.Exp + [Existing Acc.Depr.Exp * (Revaluation Rate/100)]
Acc. Depre.Exp =  2000 + [2000 * (5/100)]

Revaluation Reserve = Existing Revaluation Reserve + (Change in Note Book Value)
Revaluation Reserve = 0 + (8400-8000)
Change in Note Book Value = [Reval1 => 10,500 - 2100] - [Asset Cost - Acc. Depre. Expense]
New Depre. Exp. = New Asset Cost[10,500]/20
[20= Total Life * Total Quarters in Single Year]

Oracle EBS- Assets

Net Book Value = Original Cost - Accumulated Depreciation

You cannot retire an asset if it is added in current period

You cannot transfer an asset to a future period.

Gain/Loss = Proceeds of Sale - Cost of Removal - NBV + Revaluation Reserved

Asset Addition through Oracle Payables (Procure to Pay)