Update: It worked when I out the following line on reports.sh:
NLS_NUMERIC_CHARACTERS=",."; export NLS_NUMERIC_CHARACTERS
The problem is that this is at system-level, all users must have the same format mask. In forms, as I configure it on the env file, I can have multiple configurations. Is there another way to solve this issue?
You can create the environment for reports as well as for forms. This is done in the <REPORTS_SERVER>.conf file in <Oracle_Home>/reports/conf/. The whole section in this file would look something like this (depending on your actual values):
<envVariable name="REPORTS_PATH" value="<copy_from_the_current_environment>"/>
<envVariable name="NLS_LANG" value="BRAZILIAN PORTUGUESE_BRAZIL.WE8MSWIN1252"/>
<envVariable name="NLS_DATE_FORMAT" value="DD/MM/YYYY"/>
<envVariable name="NLS_NUMERIC_CHARACTERS" value=",."/>
How to we choose the environment when running reports?