My Oracle Support Banner

R12: Unplanned Depreciation Amount is Added to Current Adjustment Amount (Doc ID 1901687.1)

Last updated on AUGUST 25, 2020

Applies to:

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

Symptoms

Wrong catch-up calculated when an amortized adjustment overlapping an unplanned transaction and EXPENSED adjustment is done.
Unplanned depreciation amount is added to current adjustment amount.


Steps/Example:

  1. Addition ***** 2014-04(APR-14)

    Book Type BOOK_TYPE_CODE
    Book Class CORPORATE
    Asset Number ABCDEF
    Cost 10000
    YTD depreciation amount 0
    Accumulated depreciation amount 0
    DPIS 30-APR-2014
    Deprn method JP-200DB 17
    Salvage value 0  JPY
    Depreciation limit amount 1  JPY

     

  2. Unplanned Depreciation ***** 2014-04(APR-14)
     
    Type UNPLANNED_TYPE
    Amount 3000
    Expense Account 10.100.10.E1000.0000
    Amortize From Current Period Not Checked
  3. Adjustment **** 2014-04(APR-14)
     
    Depreciation limit amount 1  JPY => 0 JPY
    Amortize Adjustment Not Checked
    Amortization Start Date  

    => 2. Unplanned Depreciation is reversed.

  4. Adjustment **** 2014-05(MAY-14)

     
    Cost 10000  => 9000
    Amortize Adjustment Checked
    Amortization Start Date 30-APR-2014

     

  5. Run Depreciation without closing period

    FA_ADJUSTMENTS
     
    TRANSACTION
    HEADER_ID
    SOURCE_TYPE
    CODE
    ADJUSTMENT
    TYPE
    DEBIT_CREDIT
    FLAG
    ADJUSTMENT
    AMOUNT
    326412 DEPRECIATION EXPENSE DR * 3000
    326413 DEPRECIATION EXPENSE DR -3000
    326426 ADJUSTMENT COST CR 1000
    326426 ADJUSTMENT COST CLEARING DR 1000
    326426 DEPRECIATION EXPENSE DR ** 2990


    FA_DEPRN_SUMMARY

    PERIOD_COUNTERDEPRN_AMOUNTYTD_DEPRNDEPRN_RESERVEADJUSTED_COSTDEPRN
    ADJUSTMENT
    AMOUNT
    24168 0 0 0 10000  
    24169 98 98 98 10000 0
    24170 *  3078 3176 3176 9000 **2990

     

    EXPENSE is added with Unplanned Depreciation amount.

    EXPENSE = -10 + 3000
                  = 2990

    Should be
    ---------
      EXPENSE = -10

 

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
Cause
Solution
 Still Have Questions?
References


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