Format of Report parameter (date datatype) gets changed for Right to Left

Shehzeer vp

Hi,

I am using Forms and reports 12c with Weblogic as server.

I am calling a report from Form using "run_report_object" and "Web.show_document".

I am passing a Date value from the Form to Report . --Date in this case is '18-jan-2001'

When I run the report, I get the error - REP-0091, REP-0613 and ORA-03147.

I have tried all different Input masks (for parameter in report) and tried changing to different formats while sending from Forms. But not working.

The report direction is "Right to Left". But even if I change it to "Left to right", it doesnot work.

If I change the User parameter from Date to Character, it works.

Suresh Sangaran-Oracle

What is the NLS_LANG used in the Report Server?

Shehzeer vp

Btw, I forgot say- We are displaying Arabic characters in reports and Report direction is Right to Left.

So I have set nls_lang as "ARABIC_UNITED ARAB EMIRATES.AR8MSWIN1256".

It is set in rwserver.conf as :

<environment id="AR">

<envVariable name="NLS_LANG" value="ARABIC_UNITED ARAB EMIRATES.AR8MSWIN1256"/>

   </environment>

<engine id="rwEng" class="oracle.reports.engine.EngineImpl" maxEngine="1" minEngine="1" engLife="50" defaultEnvId="AR" >

FYI, When I revert nls_lang to "AMERICAN_AMERICA.AR8MSWIN1256", report runs fine, but Right to Left direction is lost, We want R to L direction also.