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

Last updated on NOVEMBER 18, 2022

Applies to:

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_COUNTER	DEPRN_AMOUNT	YTD_DEPRN	DEPRN_RESERVE	ADJUSTED_COST	DEPRN 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

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