AMRT2010 - Wrong Calculation Of The Depreciation Value Due To Rounding
Last updated on JULY 12, 2017
Applies to:
PeopleSoft Enterprise FIN Asset Management - Version 9.1 to 9.2 [Release 9]Information in this document applies to any platform.
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(%DecMult(%DecMult(b.Depr, a.Pd_Alloc) , %decdiv((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(%DecMult(%DecMult(b.Depr, a.Pd_Alloc) , %decdiv((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
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