My Oracle Support Banner

OBIEE 12C: Non-Admin User Can't See Currency Value From Prompt Dropdown List Or Under My Account (Doc ID 2633927.1)

Last updated on FEBRUARY 05, 2020

Applies to:

Business Intelligence Suite Enterprise Edition - Version and later
Information in this document applies to any platform.


You have configured currency options using a dynamic mapping

Below is the dynamic query example configured in the userpref_currencies.xml

SELECT "Dynamic Currency Preference"."Preference List"."Currency Preference Code", '', "Dynamic Currency Preference"."Preference List"."Currency Preference Name", 'column',"Dynamic Currency Preference"."Preference List"."Currency Support Flag" FROM "Dynamic Currency Preference"."Preference List" order by "Dynamic Currency Preference"."Preference List"."Currency Preference Name" ASC

After Implementation, all admin user is able to see currency under my account and also prompt dropdown list

But for non-admin user id, my account and prompt have empty value for currency


Migrate OBIEE from 11g to 12c


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.