Issue while doing SUM in ETEXT Template
Hi All,
We have an eText Template for Oracle Payments, where in footer record we are doing some of Values in XML file using below functions
INTEGER_PART(SUM(OutboundPayment/PaymentAmount/Value))|| ‘.’||RPAD(SUBSTR(DECIMAL_PART(SUM(OutboundPayment/PaymentAmount/Value)),1,2),2,’0’).
I have below values coming in the file in Value Tag,
40000
2727
5487.57
508557.5
1548
546846.1
50960
765.21
31.06
43.99
5845851
86.13
3444
1000001
229.31
2.96
50
100
6584.54
When I do there sum in SQL using below select , I am getting o/p as 8013315.37, however using function I gave first which is there in XML, we are getting value as 8013315.36, so there is difference of .01 coming while doing Sum in eText Template.
select (40000+6584.54+5487.57+508557.5+1548+546846.1+50960+765.21+31.06+43.99+5845851+86.13+3444+1000001+229.31+2.96+50+100+2727)
from dual
/
Please suggest.