Error with RTF template oracle.xdo.parser.v2.XPathException: Cannot convert 75,560.00 to number
I converted oracle report to print in pdf. i have rtf template in place. one of the column I get this error.
I converted oracle AR invoice report and one of the total column has issue.
Following is the error
Caused by: oracle.xdo.parser.v2.XPathException: Cannot convert 75,560.00 to number
here is the code from template.
<?xdoxslt:set_variable($_XDOCTX, 'RSubtotVar', number(xdoxslt:get_variable($_XDOCTX, 'RSubtotVar') + D_LINE_EXTENDED_AMOUNT))?>
i tried to_number as well both are erroring.
<?xdoxslt:set_variable($_XDOCTX, 'RSubtotVar', xdoxslt:get_variable($_XDOCTX, 'RSubtotVar') + <?xdofx:to_number(D_LINE_EXTENDED_AMOUNT)?>)?>
Any one has idea about this error.