Solved

Oracle ERP BI Publisher default value for date in data template

Posted on 2012-03-10
4
2,007 Views
Last Modified: 2012-03-15
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
Comment
Question by:meagain0707
  • 3
4 Comments
 
LVL 14

Expert Comment

by:leoahmad
ID: 37705204
default format
dd-Mon-YYYY
01-JAN-1951
0
 

Author Comment

by:meagain0707
ID: 37705314
I have tried that too. I get
Calling XDO Data Engine ...
java.text.parseException: unparseable date: "01-JAN-1951"
0
 

Accepted Solution

by:
meagain0707 earned 0 total points
ID: 37705417
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
 

Author Closing Comment

by:meagain0707
ID: 37723924
I found the answer.
0

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Oracle Next Available Number 2 41
Oracle Public Synonyms and Privileges 2 65
Oracle Pivot Question 8 58
Character matching different date formats for dates between 6 44
Hello All, In previous article we used Hortonworks sandbox to work with Hadoop. Now, lets think to create own single node Hadoop on Linux. Here we Install and Configure Apache Hadoop on UI based Oracle Linux. I assume, you have VMware installe…
For cloud, the “train has left the station” and in the Microsoft ERP & CRM world, that means the next generation of enterprise software from Microsoft is here: Dynamics 365 is Microsoft’s new integrated business solution that unifies CRM and ERP fun…
Via a live example, show how to take different types of Oracle backups using RMAN.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

816 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now