BI Publisher (MOSC)

MOSC Banner

Server Locale overriding coded Currency Format

edited Jul 29, 2010 10:19AM in BI Publisher (MOSC) 2 commentsAnswered
 Hi. We're having a problem here. Let me describe what's going on:
We have a XML file that has an amount we need to print as currency. XML file is like this:

<Amount>123456.78</Amount>
or
<Amount>123456</Amount>

We need to show that amount as currency, on format MXP (Mexican peso, format mask is the same as USD)
example: $123,456.78 or $123,456.00

server locale is set to EUR (probably Spanish, Spain), so amounts are printed like this
$123.456,78 or $123.456,00

We have already tried:

format-number(Amount,'###,###.##')
format-currency:Amount,'MXP','true'  
on MS Word, Field properties for Number $###,##0.00

format currency on local PC works when the currency code is MXN (obsolete) or USD, but does not work on MXP. However, on the server, any of these will work, but format mask will be EUR.

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