We help IT Professionals succeed at work.

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  ....
Comment
Watch Question

Muhammad Ahmad ImranDatabase Developer

Commented:
default format
dd-Mon-YYYY
01-JAN-1951

Author

Commented:
I have tried that too. I get
Calling XDO Data Engine ...
java.text.parseException: unparseable date: "01-JAN-1951"
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.

Author

Commented:
I found the answer.