Oracle Transactional Business Intelligence

Products Banner

OTBI Variable Presentation Date Prompt Format DD-MON-YYYY

163
Views
1
Comments

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?

 

 

Prompt.PNG

Comments

  • RichardChan
    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