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:
Oracle Assets - Version 12.1.3 and laterInformation in this document applies to any platform.
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
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 |
Changes |
Cause |
Solution |
Still Have Questions? |
References |