R12.1 to R12.2: FAXWHTIF: What-If Analysis Program Is Showing Incorrect Depreciation Amount At The End Of The Year
(Doc ID 1930156.1)
Last updated on OCTOBER 02, 2020
Applies to:
Oracle Assets - Version 12.1 and laterInformation in this document applies to any platform.
FAXWHTIF - What-If Analysis Program
Consolidate Duplicate Doc 2026977.1 into
Symptoms
What-If Analysis Program (FAXWHTIF) is showing incorrect depreciation amount at the end of the year when FA_BOOKS.EOFY_RESERVE is null.
&
is showing incorrect depreciation amount for the last period of the first year.
Steps to Reproduce
[Ex1]
1. 2014-05 *** [Tax Book]Add an asset
Cost : 135500
YTD depreciation : 0
Accumulated depreciation : 0
Date in Service : 15-MAY-2014
Depreciation method : JP-STL 5YR
Salvage value : 0
Depreciation limit amount : 1
*Daily Prorate
*Beginning of Jan
*Deprn allocation code is "Daily" in Book Control
2. 2014-05 *** [Tax Book]Adjustment Salvage value via Tax Upload
(1) Insert fa_tax_interface
insert into fa_tax_interface(
asset_number
,book_type_code
,salvage_value
,posting_status
)values(
&asset_number --asset_number
,&book_type_code --book_type_code
,1 --salvage_value
,'POST' --posting_status
);
(2) Run Upload Tax Book Interface
(3) Check FA_BOOKS
FA_BOOKS ***
COST SALVAGE_VALUE EOFY_RESERVE
------ ------------- ------------
135500 0 0
135500 1 <--NULL
3. 2014-05 *** [Tax Book]Run What-If Analysis Program
What-If Depreciation Report
===========================================
Period Fiscal
Name Year Cost Depreciation
-------- ------- ------------- ------------
2014-06 2014 135,500 2,227
2014-07 2014 135,500 2,302
2014-08 2014 135,500 2,302
2014-09 2014 135,500 2,227
2014-10 2014 135,500 2,302
2014-11 2014 135,500 2,227
2014-12 2014 135,500 2,301 <---Correct Value
2015-01 2015 135,500 2,302
2015-02 2015 135,500 2,079
2015-03 2015 135,500 2,302
It's ONLY showing correct value before closing the period which is period of addition
4. 2014-05 *** [Tax Book]Run Depreciation with period closing
5. 2014-06 *** [Tax Book]Run What-If Analysis Program
Current Behavior *** What-If Depreciation Report
===================================================
Period Fiscal
Name Year Cost Depreciation
-------- ------- ------------- ------------
2014-06 2014 135,500 2,227
2014-07 2014 135,500 2,302
2014-08 2014 135,500 2,302
2014-09 2014 135,500 2,227
2014-10 2014 135,500 2,302
2014-11 2014 135,500 2,227
2014-12 2014 135,500 3,563 <---Wrong Value
2015-01 2015 135,500 2,302
2015-02 2015 135,500 2,079
2015-03 2015 135,500 2,302
Depreciation amount of 2014-12 should be 2,301, instead of 3,563.
[Ex2]
Supplement : This case is NOT reproduced when performing What-If Analysis on the first period of the year
1. 2015-03 *** Addition
Cost : 633235044
YTD depreciation : 20374343
Accumulated depreciation : 257728871
Date in Service : 01-APR-2003
Depreciation method : JP-STL 26YR
Salvage value : 10% *63323505
Depreciation limit amount : 95%
2. 2015-03 *** Run Depreciation with period close and go to the next year.
3. 2015-04 *** Run What-If Analysis
(N)Depreciation > What-If Analysis
What-If Depreciation Report
Period Fiscal
Name Year Depreciation
-------- ------- ------------
2015-05 2015 1,852,213+
2015-06 2015 1,852,213+
2015-07 2015 1,852,213+
2015-08 2015 1,852,213+
2015-09 2015 1,852,213+
2015-10 2015 1,852,213+
2015-11 2015 1,852,213+
2015-12 2015 1,852,213+
2016-01 2015 1,852,213+
2016-02 2015 1,852,213+
2016-03 2015 1,852,207+ <-- Correct when performing on the first period of the year
2016-04 2016 1,852,213+
2016-05 2016 1,852,213+
2016-06 2016 1,852,213+
2016-07 2016 1,852,213+
2016-08 2016 1,852,213+
2016-09 2016 1,852,213+
2016-10 2016 1,852,213+
2016-11 2016 1,852,213+
2016-12 2016 1,852,213+
2017-01 2016 1,852,213+
2017-02 2016 1,852,213+
2017-03 2016 1,852,207+ <-- Correct
4. 2015-05 *** Run What-If Analysis
(N)Depreciation > What-If Analysis
What-If Depreciation Report
Period Fiscal
Name Year Depreciation
-------- ------- ------------
2015-05 2015 1,852,213+
2015-06 2015 1,852,213+
2015-07 2015 1,852,213+
2015-08 2015 1,852,213+
2015-09 2015 1,852,213+
2015-10 2015 1,852,213+
2015-11 2015 1,852,213+
2015-12 2015 1,852,213+
2016-01 2015 1,852,213+
2016-02 2015 1,852,213+
2016-03 2015 261433285+ <-- Wrong. It is the last period of the first year.
2016-04 2016 1,852,213+
2016-05 2016 1,852,213+
2016-06 2016 1,852,213+
2016-07 2016 1,852,213+
2016-08 2016 1,852,213+
2016-09 2016 1,852,213+
2016-10 2016 1,852,213+
2016-11 2016 1,852,213+
2016-12 2016 1,852,213+
2017-01 2016 1,852,213+
2017-02 2016 1,852,213+
2017-03 2016 1,852,207+ <-- Correct
[Expected Behaivor]
In 2016-03, depreciation amount should be 1,852,207, instead of 261433285.
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Fixed Files |
| Solution |
| Still Have Questions? |
| References |