Oracle Reports (MOSC)

MOSC Banner

Oracle Reports 12.2.1.3.0 fields with mixed numbers and characters are in incorrect direction

edited Jul 30, 2019 4:15AM in Oracle Reports (MOSC) 3 commentsAnswered

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

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