1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

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

Discussion in 'Oracle Apps Technical' started by jagadekara, Jan 23, 2014.

  1. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Hi All,
    In Xml publisher i am getting this error. In rtf I took variable and assigning value as

    <?xdoxslt:set_variable($_XDOCTX, 'x', xdoxslt:get_variable($_XDOCTX, 'x')+DR_MINUS_CR)?><?xdoxslt:get_variable($_XDOCTX, 'x')?>

    so it is giving error. If I use +1 instaed of +DR_MINUS_CR then it is not getting any error....

    So let me know any ideas...
     
  2. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    This is the error message when click on preview
     

    Attached Files:

  3. Hi Jagadekara,
    Where you able to get the result for your mentioned issue. I too am facing the same problem. Please mail to prabhu.palaniappan@oracle.com, if you got the answer to this issue.

    Thanks,
    Prabhu.
     
  4. sambuduk

    sambuduk Forum Advisor

    Messages:
    242
    Likes Received:
    73
    Trophy Points:
    455
    Location:
    Hyderabad , Telangana
    Hi,

    Normally If you are doing any calculations(like addition ,substraction..etc ) in RTF and in that any one of the variable is null that time you will get this error. In above case may be DR_MINUS_CR is having null value.

    So Prabhu are you doing any calculations in RTF??

    Regards
    Sambasiva Reddy.K
     
  5. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Yes Samba,

    I too have same issue on that day.

    So I used nvl in query itself. So my error was resolved.

    So Prabhu just check any null values coming for your data....