Depreciation Projection Report(FAPROJ) Is Showing Incorrect Amount for Asset with JP-200DB/JP-250DB

(Doc ID 2148923.1)

Last updated on JUNE 12, 2016

Applies to:

Oracle Assets - Version 11.5.10.2 and later
Information in this document applies to any platform.

Symptoms

Depreciation Projection Report(FAPROJ) is showing incorrect amount for Asset with JP-200DB/JP-250DB.  


Steps to Reproduce
1.  2016-04 *** Addition with JP-200DB 5

    Cost                       : 100000
    YTD depreciation           : 0
    Accumulated depreciation   : 0
    Date in Service            : 01-APR-2016
    Depreciation method        : JP-200DB 5
    Salvage value              : 0
    Depreciation limit amount  : 1


2.  2016-04 *** Run Projections

    (N)Depreciation > Projections
    ----------------------------------------------
    Projections Calendar : Monthly calendar
    Number of periods    : 60
    Starting period      : 2016-04
    Report Detail        : Asset
    ----------------------------------------------

    Depreciation Projection Report ****
                                     Book
    Period Name              XXXXXXXXXXXX
    ------------------ ------------------
    2016-04                     3,333   <---Correct
    2016-05                     3,333   <---Correct
    2016-06                     3,333   <---Correct
    2016-07                     3,333   <---Correct
    2016-08                     3,333   <---Correct
    2016-09                     3,333   <---Correct
    2016-10                     3,333   <---Correct
    2016-11                     3,333   <---Correct
    2016-12                     3,333   <---Correct
    2017-01                     3,333   <---Correct
    2017-02                     3,333   <---Correct
    2017-03                     3,337   <---Correct
                       ------------------
                               40,000   <---Correct


                                     Book
    Period Name              XXXXXXXXXXXX
    ------------------ ------------------
    2017-04                     2,000   <---Correct
    2017-05                     2,000   <---Correct
    2017-06                     2,000   <---Correct
    2017-07                     2,000   <---Correct
    2017-08                     2,000   <---Correct
    2017-09                     2,000   <---Correct
    2017-10                     2,000   <---Correct
    2017-11                     2,000   <---Correct
    2017-12                     2,000   <---Correct
    2018-01                     2,000   <---Correct
    2018-02                     2,000   <---Corrects
    2018-03                     2,000   <---Correct
                       ------------------
                               24,000   <---Correct


                                     Book
    Period Name              XXXXXXXXXXXX
    ------------------ ------------------
    2018-04                     2,000   <---Wrong. Should be 1,200
    2018-05                     2,000   <---Wrong. Should be 1,200
    2018-06                     2,000   <---Wrong. Should be 1,200
    2018-07                     2,000   <---Wrong. Should be 1,200
    2018-08                     2,000   <---Wrong. Should be 1,200
    2018-09                     2,000   <---Wrong. Should be 1,200
    2018-10                     2,000   <---Wrong. Should be 1,200
    2018-11                     2,000   <---Wrong. Should be 1,200
    2018-12                     2,000   <---Wrong. Should be 1,200
    2019-01                     2,000   <---Wrong. Should be 1,200
    2019-02                     2,000   <---Wrong. Should be 1,200
    2019-03                     2,000   <---Wrong. Should be 1,200
                       ------------------
                               24,000   <---Wrong. Should be 14400

                                     Book
    Period Name              XXXXXXXXXXXX
    ------------------ ------------------
    2019-04                     2,000   <---Wrong. Should be 900
    2019-05                     2,000   <---Wrong. Should be 900
    2019-06                     2,000   <---Wrong. Should be 900
    2019-07                     2,000   <---Wrong. Should be 900
    2019-08                     2,000   <---Wrong. Should be 900
    2019-09                     1,999   <---Wrong. Should be 900
    2019-10                         0   <---Wrong. Should be 900
    2019-11                         0   <---Wrong. Should be 900
    2019-12                         0   <---Wrong. Should be 900
    2020-01                         0   <---Wrong. Should be 900
    2020-02                         0   <---Wrong. Should be 900
    2020-03                         0   <---Wrong. Should be 900
                       ------------------                    
                               11,999   <---Wrong. Should be 10800



Workaround
What-If Depreciation Report(N:Depreciation > What-If Analysis) can be showing correct amount.

    What-If Depreciation Report ***

    Period   Fiscal                       New
    Name     Year    Depreciation Depreciation
    -------- ------- ------------ ------------
    2016-04  2016          3,333        3,333
    2016-05  2016          3,333        3,333
    2016-06  2016          3,333        3,333
    2016-07  2016          3,333        3,333
    2016-08  2016          3,333        3,333
    2016-09  2016          3,333        3,333
    2016-10  2016          3,333        3,333
    2016-11  2016          3,333        3,333
    2016-12  2016          3,333        3,333
    2017-01  2016          3,333        3,333
    2017-02  2016          3,333        3,333
    2017-03  2016          3,337        3,337
    -------- ------- ------------ ------------
    2017-04  2017          2,000        2,000
    2017-05  2017          2,000        2,000
    2017-06  2017          2,000        2,000
    2017-07  2017          2,000        2,000
    2017-08  2017          2,000        2,000
    2017-09  2017          2,000        2,000
    2017-10  2017          2,000        2,000
    2017-11  2017          2,000        2,000
    2017-12  2017          2,000        2,000
    2018-01  2017          2,000        2,000
    2018-02  2017          2,000        2,000
    2018-03  2017          2,000        2,000
    -------- ------- ------------ ------------
    2018-04  2018          1,200        1,200
    2018-05  2018          1,200        1,200
    2018-06  2018          1,200        1,200
    2018-07  2018          1,200        1,200
    2018-08  2018          1,200        1,200
    2018-09  2018          1,200        1,200
    2018-10  2018          1,200        1,200
    2018-11  2018          1,200        1,200
    2018-12  2018          1,200        1,200
    2019-01  2018          1,200        1,200
    2019-02  2018          1,200        1,200
    2019-03  2018          1,200        1,200
    -------- ------- ------------ ------------
    2019-04  2019            900          900
    2019-05  2019            900          900
    2019-06  2019            900          900
    2019-07  2019            900          900
    2019-08  2019            900          900
    2019-09  2019            900          900
    2019-10  2019            900          900
    2019-11  2019            900          900
    2019-12  2019            900          900
    2020-01  2019            900          900
    2020-02  2019            900          900
    2020-03  2019            900          900
    -------- ------- ------------ ------------
    2020-04  2020            900          900
    2020-05  2020            900          900
    2020-06  2020            900          900
    2020-07  2020            900          900
    2020-08  2020            900          900
    2020-09  2020            900          900
    2020-10  2020            900          900
    2020-11  2020            900          900
    2020-12  2020            900          900
    2021-01  2020            900          900
    2021-02  2020            900          900
    2021-03  2020            899          899
    -------- ------- ------------ ------------

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms