Oracle Reports 12.2.1.3.0 fields with mixed numbers and characters are in incorrect direction
i create reports in 12.2.1.3.0. (new development, not upgrade)
when i run report from forms on the server (linux) fields that contains both numbers and characters text are incorrect.
for example:
1. date instead of 10/07/2015 is displayed 2015/07/10,
2. phone number instead of 0303-5221 is displayed as 5221-0303
3. text like QTR461B is displayed as B461QTR
when i run reports in report builder (windows) all fields all fields are displayed correctly
settings in reports.sh are:
NLS_LANG=AMERICAN_AMERICA.IW8ISO8859P8
USER_NLS_LANG=HEBREW_ISRAEL.IW8ISO8859P8
REPORTS_BIDI_ALGORITHM=UTF8
REPORTS_ENHANCED_SUBSET=YES
REPORTS_ENHANCED_FONTHANDLING=YES