R12 Depreciation Not Calculated When Amortized Asset Is Added With Deprn Method JP-STL (Doc ID 1673960.1)

Last updated on JANUARY 23, 2023

Applies to:

Symptoms

Amortized asset is added with JP-STL and the depreciation cost isn't calculated due toINCORRECT adjusted amount.

EXPECTED BEHAVIOR
-----------------------
Depreciation cost is calculated based on CORRECT adjusted amount.

STEPS
-----------------------
1. Create an asset as below and save it:

  2014-02 *** Add Asset

  COST                    : 1000000
  YTD_DEPRN            : 0
  DEPRN_RESERVE     : 0
  DPIS                     : 31-DEC-2013
  METHOD_CODE       : JP-STL 15YR
  SALVAGE VALUE      : 0
  ALLOWED_DEPRN_LIMIT    : 0
  Amortize Adjustment        : YES
  Amortization Start Date     : 28-FEB-2014
  Bonus Rule                     : Dummy 0%

2. FA_BOOKS.ADJUSTED_COST = 0 instead of 1000000.

  TH_ID_IN                   : 3945555
  COST                        : 1000000
  ADJUSTED_COST        : 0   <---------***
  DEPRN_METHOD         : JP-STL 15YR
  RATE                        : 0.067
  SALVAGE_VALUE         : 0
  ALLOWED_DEPRN_LIMIT_AMOUNT  : 0
  EOFY_RESERVE                : 0

* You can use the following query to check these value above:

[SQL]
select fb.transaction_header_id_in as th_id_in
    , fb.cost
    , fb.adjusted_cost
    , deprn_method_code as deprn_method
    , case
           when fb.adjusted_rate is not null then fb.adjusted_rate
           when fb.rate_in_use is not null then fb.rate_in_use
           else fb.life_in_months
      end as rate
    , fb.salvage_value
    , fb.allowed_deprn_limit_amount
    , fb.eofy_reserve
 from fa_books fb
     ,fa_additions_b fab
where fb.asset_id = fab.asset_id
  and fab.asset_number  = '<asset number>'
order by fb.transaction_header_id_in;

Changes

Cause

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