Format number in BI report according to the ICX: Numeric Char profile option

Format number in BI report according to the ICX: Numeric Char profile option:

Its common in Oracle Apps UIs that the number and date formats are displayed according to the user preferences.

Often we need the number format preference be honoured in BI Publisher (XML Publisher) reports.

With the following we can achieve the same:
1) Set the profile 'ICX: Numeric characters' according to your need.
2) Set the profile XDO: Numeric characters to 'Read from ICX: Numeric characters'

When the above is set, the system passes the separators to xslt._XDONFSEPARATORS XDO parameter during runtime.

In your RTF for the number field - write the following code:
<?format-number:NUM_COLUMN;'999G999D99'?>

Where 'G' denotes thousands separtor and D denotes decimal separator.

During runtime, the BIP engine uses XSL-FO style sheet instead of RTF that was uploaded. 
As soon as you upload the RTF document and save you can see one more extra record in XDO_LOBS for the XSL:

We can see the XSL from the BIP add-in as well.

Open your RTF --> From Add-ins --> Tools --> export --> XSL-FO Style sheet.

You will something like this:

<xsl:value-of select="xdoxslt:xdo_format_number($_XDOXSLTCTX, .//NUM_COLUMN, '999G999D99')"/>


$_XDOXSLTCTX is made up of locale, timezone, calendar, numeric separtors etc..

You can refer metalink notes 760434.1,1355022.1