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

Last updated on JULY 25, 2017

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 FA_BOOKS
    Book Class CORPORATE
    Asset Number FA_BOOKS-01
    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 STORM DAM
    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 Check
    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

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