Thursday, 1 October 2020

XML Publisher Reports End With Warnings - oracle.xdo.parser.v2.XPathException: Cannot convert to number

XML Publisher Reports End With Warnings -(Doc ID 1505402.1)

APPLIES TO:

BI Publisher (formerly XML Publisher) - Version 10.1.3.2.0 to 11.1.1.7.0 [Release 10.1 to 11.1]
Information in this document applies to any platform.

SYMPTOMS

On Oracle Applications 12.1.3 version, Reports for Applications Technology

When attempting to run some XML reports the following error occurs:

java.lang.reflect.InvocationTargetException at sun.reflect.GeneratedMethodAccessor46.invoke

Caused by: oracle.xdo.parser.v2.XPathException: Cannot convert to number.

The issue can be reproduced at will with the following steps:
1. Run XML reports.

The issue has the following business impact:
Due to this issue, users cannot run XML reports

CAUSE

The cause was from the template design or the data.

SOLUTION

The above error suggests there is a problem with either the template design or the data.
Somewhere there is text data that the code in the layout expects to be numerical.
Correct the template or fix the program that generates the XML data to make sure the data is always numeric.

 

No comments:

Post a Comment