Oracle Transactional Business Intelligence

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Transactional Business Intelligence

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

OTBI Variable Presentation Date Prompt Format DD-MON-YYYY

290
Views
1
Comments
Brenda Jacks-49721
Brenda Jacks-49721 Rank 3 - Community Apprentice
in Oracle Transactional Business Intelligence

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

Tagged:

Comments

  • RichardChan
    RichardChan Rank 6 - Analytics & AI Lead
    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