Link to home
Start Free TrialLog in
Avatar of meagain0707
meagain0707

asked on

Oracle ERP BI Publisher default value for date in data template

Hello,

I would like to know the  format for the default date in a parameter in the data template.

 <parameter name="FROM_DATE" dataType="date" defaultValue="1951-01-01"/>
     <parameter name="TO_DATE" dataType="date" defaultValue="4712-01-01"/>

I have tried different formats, but I get errors, here is the part of the log:

SQLException ORA-06550 pls-00193 Encountered the symbol "." when expecting one of the following  ....
Avatar of Muhammad Ahmad Imran
Muhammad Ahmad Imran
Flag of United Kingdom of Great Britain and Northern Ireland image

default format
dd-Mon-YYYY
01-JAN-1951
Avatar of meagain0707
meagain0707

ASKER

I have tried that too. I get
Calling XDO Data Engine ...
java.text.parseException: unparseable date: "01-JAN-1951"
ASKER CERTIFIED SOLUTION
Avatar of meagain0707
meagain0707

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I found the answer.