AMRT2010 - Wrong Calculation Of The Depreciation Value Due To Rounding (Doc ID 1571676.1)

Last updated on APRIL 08, 2019

Applies to:

Symptoms

The standard report AMRT2010 report (RETIREMENT DETAIL BY IN SERVICE YEAR AND PERIOD), shows the rounding issue under LTD DEPR amount field.
The Depreciation shows a slight difference appear in the report, but after analysis, there is absolutely no difference with the real figures.

The difference is caused by a rounding error in the field period_depr in the view DEPR_ALL_PD2_VW.

The view DEPR_ALL_PD2_VW is created with the following SQL:

SELECT b.Business_Unit
, b.Asset_ID
, b.Book
, b.DtTm_Stamp
, B.CF_SEQNO
, a.Fiscal_Year
, a.Accounting_Period
, %subrec(cf14_An_sbr, b)
, B.PROJECT_ID
, B.DEPTID
, b.Category
, b.Cost_Type
, b.Trans_Type
, b.Trans_In_Out
, b.Trans_Code
, b.Trans_Dt
, b.Activity_Sw
, %Round(ÞcMult(ÞcMult(b.Depr, a.Pd_Alloc) , Þcdiv((1+0.0),a.Pd_Alloc_Total )) , 4)
, b.Cal_Depr_Pd
, b.Currency_Cd
, b.Manual_depr_type
 FROM ps_Depr_Alloc_Tbl a
 , ps_Depr_All_PD1_Vw b
WHERE a.SetID = b.Cal_SetID
  AND a.Calendar_ID = b.Cal_Depr_Pd
  AND a.Fiscal_Year = b.Fiscal_Year
  AND a.Start_Pd = b.Start_Pd
  AND a.End_Pd = b.End_Pd
  AND a.Pd_Alloc <> 0


The error is clearly caused by the following formula :
%Round(ÞcMult(ÞcMult(b.Depr, a.Pd_Alloc) , Þcdiv((1+0.0),a.Pd_Alloc_Total )) , 4)

Furthermore the value in the field DEPR in the view DEPR_ALL_PD1_VW is correct

SELECT a.Business_Unit
, a.Asset_ID
, a.Book
, a.DtTm_Stamp
, A.CF_SEQNO
, a.Fiscal_Year
, a.Start_Pd
, a.End_Pd
, %subrec(cf12_An_sbr, a)
, A.PROJECT_ID
, A.DEPTID
, a.Category
, a.Cost_Type
, a.Trans_Type
, a.Trans_In_Out
, a.Trans_Code
, a.Trans_Dt
, a.Activity_Sw
, a.Depr
, b.cal_depr_pd
, c.SetID
, a.Currency_Cd
, a.Manual_depr_type
 FROM ps_Depreciation a
 , ps_BU_AM_Book_Vw b
 , ps_Set_Cntrl_Rec c
WHERE a.Business_Unit = b.Business_Unit
  AND a.Book = b.Book
  AND c.SetCntrlValue = a.Business_Unit
  AND c.RecName='CAL_DEFN_TBL'

Cause

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