BI Publisher (MOSC)

MOSC Banner

User Profile Decimal Formating

edited May 3, 2016 9:07AM in BI Publisher (MOSC) Question

Trying to change coding in RTF template to look at the F0092 since the decimal symbol defined in User Profile (P0092) is not taken in consideration while generating the XML output in BI Publisher. (which is reported in  Bug 11008640  - DECIMAL FORMAT IGNORED IN XMLP but is not going to be fixed.)

 

I have been able to determine the user preference and have added it to the xml.  My issue now is the syntax to check this field and reformat. 

Something like

<xsl:decimal-format xdofo:ctx="begin" name="myFMT" grouping-separator="." decimal-separator=","?>

<? if DecimalFormat_ID38 = ","

<?format-number(UnitsTransactionQty_ID10, '#.##0,00', 'myFMT')?> 

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