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

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