Oracle Reports (MOSC)

MOSC Banner

NLS_NUMERIC_CHARACTERS Environment Variable

edited Apr 2, 2013 11:57AM in Oracle Reports (MOSC) 6 commentsAnswered
Converting an Oracle report from 11i to R12 in EBS.  The report utilizes the following: 
srw.reference(:Invoice_Amt);
srw.reference(:Currency_Code);
:RP_DATA_FOUND := :customer_name;
srw.user_exit('FND FORMAT_CURRENCY
               CODE=":Currency_Code"
               DISPLAY_WIDTH="13"
               AMOUNT=":Invoice_amt"
               DISPLAY=":D_Invoice_Amount"');
The log displays the following messages.  I added MSG-00111 for debugging purposes:
Forcing NLS_NUMERIC_CHARACTERS to: '.,' for XDO processing
 APPLLCSP Environment Variable set to :
 Current NLS_LANG and NLS_NUMERIC_CHARACTERS Environment Variables are :
American_Germany.UTF8
'.,'

MSG-00111: :D_Invoice_Amount =      1,428.00  - this is not the desired format 
Does anyone know why the NLS_Numeric_characters is not working to print the amount as 1428,00?

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