I am currently working for a client that has required us to work on a check voucher.
There is an issue with the amount ROUNDING UP decimals when it is supposed to not be rounded up.
I have already checked the metalink, https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&doctype=TROUBLESHOOTING&id=404928.1 oracle documents and Google in relation to this and I have not found a single solution for avoiding the round up.
As an example: amount is supposedly 11,060,689.89 but when application generates the RTF file, it becomes 11,060,689.90.
There is a report that is produced parallel to the check voucher and it displays the correct amount : 11,060,689.89 and the codes are essentially the same, so I can only narrow it down to the RTF template.
Any kind of help would be crucial to this project.
There is formatting applied to the amount field in the RTF template, but prior to that (via the RDF/report file) there is none.
I have already tried removing the formatting, reuploading the report files, XML datafile and the template but the result is still the same.
I already contacted Oracle support regarding this and upon checking the XML file (after generating the report via concurrent request) the amount is already rounded up.
However, when I generate XML in report builder, using the same parameters and retrieving data from the same instance, the values are correct.
Any insights regarding this would be greatly appreciated.
I have managed to narrow down the issue, and it seems that it was caused by the length of the amounts in question in the RDF file.
In the RDF file, the amount width was only defined up to 10 characters but there are times when the amount that should be printed exceeds 10 characters, thus the rounding up.