BI Publisher (MOSC)

MOSC Banner

Error with RTF template oracle.xdo.parser.v2.XPathException: Cannot convert 75,560.00 to number

edited Jan 22, 2010 4:31PM in BI Publisher (MOSC) 2 commentsAnswered
 Hi

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center