My Oracle Support Banner

What-if Depreciation Analysis Report Shows Incorrect Amount in JP-STL-EXTND Assets (Doc ID 2711298.1)

Last updated on SEPTEMBER 16, 2020

Applies to:

Oracle Fusion Assets Cloud Service - Version 11.13.20.04.0 and later
Information in this document applies to any platform.

Symptoms

What-if Depreciation Analysis Report shows incorrect amount in JP-STL-EXTND Assets.
The difference amount is 1 JPY.

Reproduced Steps:

  1. Addition ***** 2020-03(MAR-19)

     Cost                             :  2029840
     YTD depreciation amount          :    20298
     Accumulated depreciation amount  :  1948646
     DPIS                             :  04/01/1997
     Depren method                    :  JP-STL-EXTND
     Salvage value                    :  0  
     Depreciation limit amount        :  1  JPY

     First Period of Extend Depreciation     : 2019-04(APR-19)
     Earlier Limit Amount                    : 101491


  2. Override **

    PERIOD_NAME         :   2020-03(MAR-19)
    USED_BY             :   DEPRECIATION
    STATUS              :   POST
    DEPRN_AMOUNT        :   0



  3. Run What-if Analysis ***** 2020-07(JUL-20)

    Currency                        : JPY           
    Star Period                     : JUL-20      
    Number of Period                : 12            
    Fully reserved                  : Yes          

    <What-if Depreciation Analysis Report>
    Depreciation = 1692
    New Depreciation = 1692

Calculation

    (1) Adjusted_cost
            = Prior_deprn_limit_amount - 1
            = 101492 - 1
            
            
    (2) Theoretical Ytd Deprn
            = trunc(Adjusted_cost * 12 / 60)
            = trunc(101491 * 12 / 60)
            = 20298
            
    (3) Deprn_amount
            = round(Theoretical Ytd Deprn * (1/12))
            = round(20298 * (1/12))
            = 1691

    (4) Deprn_amount in Year-End
            = Theoretical Ytd Deprn - Deprn_amount * 11
            = 20298 - 1691 * 11
            = 1697

-> Depreciation should be 1691.

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.