NLS_NUMERIC_CHARACTERS Environment Variable
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?
0