nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle AI and Analytics

Child Item

How prompt date format change

User_SOJXT

Hi,

OBIEE App, How can I change that my date prompt will always stay in format dd.mm.yyyy?

This slq format dd.mm.yyyy but prompt format mm.dd.yyyy.

I am client user, please in fix client page NLS/ SQL or other set command ?

Fix help

Thank you.

Find more posts tagged with

Comments

Federico Venturin - Oracle

Hi @User_SOJXT ,

In OBIEE/OAS, DATETIME columns in prompts are formatted according to your locale (the custom format that you set up in the SQL is basically ignored if you don't change the data type to VARCHAR).

Please follow this procedure to update the default locale for your account:

Login to OBIEE
Click on your profile icon (top right corner of the page)
Click on My Account
Select the Preferences tab and set the Locale to something different (e.g. "English - United States" if you want to display months before days in dates)
Click OK

User_SOJXT

Thank you. work perfect.

New problems -> OBIEE promt sapmle 1,2 promt replace '1','2'. easy method ?

There are 70 billion rows of records and there is a performance problem when in list

Thank you.

rtrim(Varchar_ID ) In

( select rtrim(deger ) as deger from( select regexp_substr('@{ID_BAR}[@]{TRIM(0)}','[^,]+', 1, level) as deger

from dual

connect BY regexp_substr('@{ID_BAR}[@]{TRIM(0)}', '[^,]+', 1, level)

is not null))

and '@{ID_BAR}[@]{TRIM(0)}' !='0' -- promt null then false

Federico Venturin - Oracle

Hi @User_SOJXT ,

I'm glad that the solution I posted worked for you. You can mark it as correct in order to help other people with the same issue.

For the new question, since it's not related to the original topic, I suggest you to create a new thread.

New Announcements

Upcoming Events

Analytics - Fusion Data Intelligence: CEAL Guidance Office Hours | Americas and Europe
Agenda Presentation: FDI Security & Deep Dive into GL Segment Security. We are revisiting FDI Security - a top topic requested by our Office Hours attendees. We will begin with an overview of key security concepts and how security is managed in FDI. We will then dive deeper into GL Segment Security across Fusion and FDI…
OCI Enterprise AI - Product Roadmap Update October 2026
Description: Join the OCI Enterprise AI Product Management team for a deep dive into the latest product roadmap updates and upcoming innovations. During this webinar, we’ll cover key roadmap highlights, showcase product demos, and share insights into what’s ahead for OCI Enterprise AI. The session will conclude with a live…
Analytics - Fusion Data Intelligence: CEAL Guidance Office Hours | APAC and Middle East
Agenda Presentation: EPM Integrator connectors and Salesforce CRM Connector. Join us to learn more about the EPM Integrator connectors and Salesforce CRM Connector in Oracle FDI. We will explore the enhanced capabilities of the EPM integrator connectors and how you can load data from EPM modules to FDI to deliver a…