• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2413
  • Last Modified:

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  ....
0
meagain0707
Asked:
meagain0707
  • 3
1 Solution
 
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:
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
 
meagain0707Author Commented:
I found the answer.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now