Tuesday, April 15, 2008

BI Publisher + Release 12 Known Issues on Metalink

Quick pointer to a handy note on Metalink. I think it's excellent for Oracle to keep known issue lists and troubleshooting guides up to date.

Oracle XML Publisher Release 12 Known Issues

Some of the key issues that I think deserve reference as I've seen posts on the Oracle forums / public blogs about them:

12.1. Decimal Numbers and Rounding with BI Publisher syntax

Rounding Issue When Adding Decimal Numbers

As Oracle XDK conforms to XSL standards for IEEE 754, you might encounter rounding issues when adding numbers that are decimals. For example, suppose you add 13683.80 and 516.39, using this syntax in Oracle BI Publisher:
<?13683.80 + 516.39?>
The value returned is 14200.189999999999 which is caused by a limitation based on the IEEE 754 Binary Floating-Point-Arithmetic.

To work around this issue, use the format-number function or the round syntax as shown here to obtain a return value of 14200.19:
<?format-number:(13683.80 + 516.39);'D99'?>
or
<?(round((13683.80 + 516.39)*100) div 100)?>

12.2. XML Publisher Bursting "Request ID" parameter LOV values

Request ID Parameter LOV Not Populated for XML Publisher Bursting Report Program and XML Report Publisher Program

When you submit the XML Publisher Bursting Report Program (XDOBURSTREP) or the XML Report Publisher Program (XDOREPPB) you are prompted to select the Request ID for the data generation program. The LOV for this parameter is not being populated due to an incorrect profile option reference. You therefore cannot select the appropriate data file to complete the request.

See Note:404928.1 for details of workaround.

If anyone hits any other known issues not documented in the above note whether Release 11i or 12 related, please comment on this post, or ask Support to add it to Note:404928.1!

8 comments:

Prashanth said...

Hey Gareth, Excellent Posts..Keep posting such nitty gritty stuff..Very very useful!! Thanks a lot..

With Regards,
Prashanth GanapathyRaj

Unknown said...

Hi Gareth,

We are on release 12.0.6 and are using bursting. We have a working solutions, where we first build the xml file and after that run the XDOBURSTREP request.

Now I've created a second data definition with a bursting control file and call the XDOBURSTREP request but now i get an error. I wonder how this request knows what bursting control file to use. Do you have an idea?

--Exception
null
java.lang.NullPointerException
at oracle.apps.xdo.oa.cp.JCP4XDOBurstingEngine.getControlFile(JCP4XDOBurstingEngine.java:421)
at oracle.apps.xdo.oa.cp.JCP4XDOBurstingEngine.runProgram(JCP4XDOBurstingEngine.java:250)
at oracle.apps.fnd.cp.request.Run.main(Run.java:157)


Thnx in advanced!

Matt

Gareth said...

Hi Srabanti,

Try something like Try something like this:
" format-number: xdoxslt:get_variable($_XDOCTX,’element1’); '999G999' "
per thread:
http://forums.oracle.com/forums/thread.jspa?threadID=880363

Regards,
Gareth

Unknown said...

Hi Gareth,

Thank you very much..
Your suggestion works..
Thanks a Lot!!!!!!!


Regards,
Srabanti

biarray said...

Hello Guys,
Im new to OBIEE but Im running into the same problem with Publisher.
Im pulling a simple list of values where several values are 0,052342 / 0,100000 0,853456 etc so when I put in a table on publisher it rounds it up and the ones which are not able to round to 1.00 it turns to blank.
How can I solve this? I've spent the whole day today searching this but no success so far.
any help is IMMENSELY appreciated

Gareth said...

Hi - the suggestion here is to use format-number, or explicit rounding especially when you do calculations, then always display the number using format-number, either explicitly, or via the format field options in the RTF.
Drop me through more details if you still have issues. ggr 888 @ gmail . com
Regards,
Gareth

frolickbbc said...

I'm getting the below error when perfoming bursting.Someone help me out.

XML/BI Publisher Version : 5.6.3
Updating request description
Retrieving XML request information
Preparing parameters
--Exception
null
java.lang.NullPointerException
at oracle.apps.xdo.oa.cp.JCP4XDOBurstingEngine.getControlFile(JCP4XDOBurstingEngine.java:421)
at oracle.apps.xdo.oa.cp.JCP4XDOBurstingEngine.runProgram(JCP4XDOBurstingEngine.java:250)
at oracle.apps.fnd.cp.request.Run.main(Run.java:157)



Gareth said...

Hi frolickbbc,
Please check the contents of your control file carefully.
Regards,
Gareth