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  ....
meagain0707Asked:
Who is Participating?
 
meagain0707Connect With a Mentor Author Commented:
The correct format is:

YYYY-MM-DDThh:mm:ss+HH:MM

Found out here:

http://docs.oracle.com/cd/E12844_01/doc/bip.1013/e12187/T421739T481157.htm

All is working thanks.
0
 
Muhammad Ahmad ImranDatabase DeveloperCommented:
default format
dd-Mon-YYYY
01-JAN-1951
0
 
meagain0707Author Commented:
I have tried that too. I get
Calling XDO Data Engine ...
java.text.parseException: unparseable date: "01-JAN-1951"
0
 
meagain0707Author Commented:
I found the answer.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.