Oracle Reports has comma as decimal separator in XML output

Advertisement

In XML, numbers should be canonical, otherwise BI Publisher errors with java.lang.NumberFormatException.
(This regards the e-business suite, by the way.)
We have trouble with our invoice report, a modified RAXINV, that suddenly makes XML files with comma. Which brought our invoicing process to a screeching halt. "Suddenly" means that it used to work, but now it does not work. I think someone has changed a setting somewhere, but nobody admits to doing that.
Can anybody point out where to look? What is actually controlling the decimal separator used by Oracle Reports in the XML output?
Thanksalotinadvance,
Tore.

Advertisement

Thanks for replying, Tim. (and thanks for a most enlightening "meet the experts" session at OOW)
The language settings for RAXINV are controlled by an MLS language function. I have logged an SR, but the problem seemed to solve itself, so the SR was closed, and then the problem reappeared. Darn.
However, I did some more research on Metalink and found this bug that seem to match our problem:
Bug 5920262 - NLS_NUMERIC_CHARACTERS KEEP CHANGING DYNAMICALLY FROM SESSION TO SESSION
I've ordered patching, so i think we'll have this fixed soon.

November 30, -0001

Oracle Reports has comma as decimal separator in XML output

In XML, numbers should be canonical, otherwise BI Publisher errors with java.lang.NumberFormatException. (This regards the e-business suite, by the way.) We have trouble with our invoice report, a modified RAXINV, that suddenly makes XML files with c

Report will not generate PDF only the XML output.  View XML icon disabled

I created a PDF format report. When the report completes, View Output shows XML code not the PDF output. View XML button is disabled from Diagnostic on view request screen. Any thoughts. All settings are the same as when other XML to PDF reports are

How to get an effective EXCEL Spreadsheet as output for Oracle report 10g

Hi All, I am a newbie in Oracle reporting. I am using 10g. I have an oracle report whose output format is PDF from the user interface. User asked for Spreadsheet output. I changed the JAVA CODE "desformat" = Spreadsheet and got the report in Exc

Amount has moved one decimal place in the report

Hi, I am looking in to a report at present, Transaction amount has moved one decimal place, while the local amount stays the same. Any one could tell me the possible reason for this? Thanks in advance RNHi, Check this link, http://sap.ittoolbox.com/g

Unable to start Oracle Reports Server for 10g version 10.1.2.3.0

Attention Oracle Reports Team or anyone else: I am unable to start the Oracle Reports Server for 10g version 10.1.2.3.0 of the Application Server. I have included the trace files see below. I marked the text in bold that might indicate the issues. An

Oracle Report Server Engine is getting stopped after starting.

Hello, Reports Engine is shutting down after starting. OS = Solaris 10 Application Server = Oracle 10gr2 *** 2011/1/4 3:59:34:723 -- Shutting down engine rwEng-0 *** 2011/1/4 3:59:34:726 -- Reports Server shut down engine rwEng-0 *** 2011/1/4 3:59:34

Sum function do not work in oracle reports enhanced spreadsheet format

we are using oracle reports 10.1.2.3 in our oracle application server 10gr2 and we are creating enhanced spreed sheet.And the report opens in MS excel fine.But we can not apply any formula like VALUE,SUM,AVG on that report after opening it into excel

Print another PDF inside Oracle Report

We print an oracle report to PDF via oracle Forms, some customers have seperate PDFs that they want to link to the run oracle report. Ideally they want to merge the two into one document. Has anyone had any exprience of this or know of annyway to ach

Oracle Reports: Print HTML tags

I am reading data from DB that contains HTML tags and would like the tags to be interpreted when the PDF report is displayed. Currently, the HTML tags are being displayed in the report. When I output the report as a HTML is tags are interpreted and l

Oracle Reports - page numbering for repeating frames

Hello, I have an Oracle Report that has one parent repeating frame containing several children repeating frames. One repeating frame has a maximum of three records per page. If the records do not exceed the maximum, page numbering is fine. If there a

Oracle Reports SPREADSHEET option QUERY

Has anyone used the SPREADSHEET option for exporting. Is there any mechanism or setting that we may have to set, so that I dont switch off wordwrap for each cell? Is there any mechanism or setting that we may have to set, so that I can see the gridli

Oracle Reporting Server

I want to have a reporting server to work together with Oracle 10g database server and application server. I cannot find any similar product from Oracle. Is oracle has this kind of product or anyone introduce some reporting server to me. Thanks in ad

Importing an image into oracle report

hi all, I have created an oracle report which has to incorporate an image in it. I have created a link file and gave the image path in the property inspector. It was working fine. but my manager wants me to import the bmp file to the report. Can anyb

ORACLE reports Build 10g - Data Model - query - If statement in Alias ?

I have the following select statement. It has the alias Survivors, Deaths and "All With the ORACLE reports Build 10g - Data Model - I have the following query statement. I require the alias to change. Can the following be done. Cases". Is it pos

Any alternative to run Oracle Report without using Oracle Rpt Server?

Hi, Is there other alternative to run Oracle Reports if I don't have oracle report server? Reason being I'm thinking of using Oracle10g iAS Standard Edition but this edition does not come with Oracle Report Server. Is there anyway to run it? I need t

Format issue after Oracle Reports conversion

Hi all: I am an intermediate Oracle Reports user and am evaluating teh use of BI Publisher as a replacement. Since I have a large number of reports, some of which are fairly complex, I wish to take advantage of the conversion tool. The report in this

Oracle Report Server Not Accessible

Hi Folks, I'm facing a series of issues with Oracle reports server 11g. I'l list the issues one by one. 1. I'm not able to start the weblogic server from the domain which i've created for Reports. It gives me authentication error. I've tried clearing

FormatTrigger on line is not working in Oracle Reports

Hi there, I am using Oracle Reports 6i and trying to format code as follows : I have three sections of data say a,b,c. 1) If there is no data returned in Section b and c, then I need to print a line just after section a ends. 2) If there is no data i

Oracle Reports Download to Excel

Can my users download an Oracle report under 6.0 to MSExcel? Do I need to specify a particular report file format to facilitate this?hi there is a way to download to csv (comma seperated) file and that is by specifying the file format as DELIMITED an

How to fit image in oracle report

HI, I have a report developed by report builder "oracle 10g". the report has an image and I read the path of the image on run time and draw it using a field. the problem is that the image not fit on the field area. and not stretched to the whole