What-If Is Showing Wrong Amount for Asset Which Impairment Is Posted in Current Year When Temporary Close in Last Period of Year
(Doc ID 2125169.1)
Last updated on MARCH 16, 2023
Applies to:
Oracle Assets - Version 12.1.3 and laterInformation in this document applies to any platform.
Symptoms
What-If Report is showing wrong amount for asset which Impairment is posted in the current year when temporary close in the last period of the year.
Condition
- Depreciation method is JP-DB XXYR
- Impairment is posted in the current year
- Temporary close in the last period of the year
- After applying 22885112:R12.FA.B including FAWDPRB.pls 120.21.12010000.26 in R12.1
Steps to Reproduce
1. 2020-03 *** Addition
Cost : 395400
YTD depreciation : 5962
Accumulated depreciation : 344345
Date in Service : 01-APR-2003
Depreciation method : JP-DB 19YR
Salvage value : 10%
Depreciation limit amount : 95%
2. 2020-06 *** Impairment
Impairment amount : 100
3. 2021-03 *** What-If Analysis
----------------------------------------------
Start Period : 2021-03
Analyze Fully Reserved Assets : Yes
Calculate Extended Depreciation : Yes
----------------------------------------------
What-If Depreciation Report ***
Period Fiscal New
Name Year Depreciation
-------- ------- ------------
2021-03 2020 468 <-- Correct
2021-04 2021 426
2021-05 2021 426
2021-06 2021 426
2021-07 2021 426
2021-08 2021 426
2021-09 2021 426
2021-10 2021 426
2021-11 2021 426
2021-12 2021 426
2022-01 2021 426
2022-02 2021 426
2022-03 2021 420
2022-04 2022 377
2022-05 2022 377
FA_BOOKS ***
COST ADJUSTED_COST DEPRN_METHOD EOFY_RESERVE EOFY_ADJ_COST
------ ------------- ------------ ------------ -------------
395400 10978 JP-DB 19YR 344882 17477
395400 9438 JP-DB 19YR 344882
FA_DEPRN_SUMMARY ***
PERIOD COUNTER DEPRN_AMOUNT DEPRN_RESERVE ADJUSTED_COST
------- ------- ------------ ------------- -------------
2020-02 24239 0 344345 17477
2020-03 24240 537 344882 17477
2020-04 24241 480 345362 10978
2020-05 24242 480 345842 10978
2020-06 24243 480 346322 10978
2020-07 24244 465 346787 9438
2020-08 24245 465 347252 9438
2020-09 24246 465 347717 9438
2020-10 24247 465 348182 9438
2020-11 24248 465 348647 9438
2020-12 24249 465 349112 9438
2021-01 24250 465 349577 9438
2021-02 24251 465 350042 9438
4. Run Depreciation WITHOUT closing the period (=Temporary close)
5. 2021-03 *** What-If Analysis
----------------------------------------------
Start Period : 2021-03
Analyze Fully Reserved Assets : Yes
Calculate Extended Depreciation : Yes
----------------------------------------------
What-If Depreciation Report ***
Period Fiscal New
Name Year Depreciation
-------- ------- ------------
2021-03 2020 478 <--Wrong. It should be 468
2021-04 2021 425 <--Wrong. It should be 426
2021-05 2021 425 <--Wrong. It should be 426
2021-06 2021 425 <--Wrong. It should be 426
2021-07 2021 425 <--Wrong. It should be 426
2021-08 2021 425 <--Wrong. It should be 426
2021-09 2021 425 <--Wrong. It should be 426
2021-10 2021 425 <--Wrong. It should be 426
2021-11 2021 425 <--Wrong. It should be 426
2021-12 2021 425 <--Wrong. It should be 426
2022-01 2021 425 <--Wrong. It should be 426
2022-02 2021 425 <--Wrong. It should be 426
2022-03 2021 429 <--Wrong. It should be 420
2022-04 2022 377
2022-05 2022 377
FA_BOOKS ***
COST ADJUSTED_COST DEPRN_METHOD EOFY_RESERVE EOFY_ADJ_COST
------ ------------- ------------ ------------ -------------
395400 10978 JP-DB 19YR 344882 17477
395400 5250 JP-DB 19YR 350510 9438
FA_DEPRN_SUMMARY ***
PERIOD COUNTER DEPRN_AMOUNT DEPRN_RESERVE ADJUSTED_COST
------- ------- ------------ ------------- -------------
2020-02 24239 0 344345 17477
2020-03 24240 537 344882 17477
2020-04 24241 480 345362 10978
2020-05 24242 480 345842 10978
2020-06 24243 480 346322 10978
2020-07 24244 465 346787 9438
2020-08 24245 465 347252 9438
2020-09 24246 465 347717 9438
2020-10 24247 465 348182 9438
2020-11 24248 465 348647 9438
2020-12 24249 465 349112 9438
2021-01 24250 465 349577 9438
2021-02 24251 465 350042 9438
2021-03 24252 468 350510 9438 <-- Actual value
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 |
Solution |
References |