OTBI Variable Presentation Date Prompt Format DD-MON-YYYY

Brenda Jacks-49721

Summary

Users need to be able to enter a date in DD-MON-YYYY format at the prompt

Content

Our date format changed to dd-MON-yyyy (15-MAY-2017), but the only way the report runs is if the date is entered in DD-MM-YYYY format (15-05-2017) at the prompt.  Is there a way to change this so the user can enter dd-MON-yyyy?

 

 

RichardChan

1. Go to the directory $ORACLE_HOME/bifoundation/web/display/localedefinitions.xml
2. Take a back up of the file localedefinitions.xml.
3. Open localedefinitions.xml to edit  , Find<localeDefinition name="en"> 
4. Replace below properties with appropriate value
   • <property name=”dateShortFormat”>dd-MON-yyyy</property>
   • <property name=”dateOrder”>dmy</property>
5. Restart the services