R12 Depreciation Not Calculated When Amortized Asset Is Added With Deprn Method JP-STL

(Doc ID 1673960.1)

Last updated on JULY 18, 2016

Applies to:

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

Symptoms

On : 12.1.3 version, Depreciation, Rollback, Projection, What-If

Amortized asset is added with JP-STL and the depreciation cost isn't calculated due to INCORRECT 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;

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