Oracle Analytics Named a Leader in the 2025 Gartner® Magic Quadrant™ Oracle Analytics whas been recognized as a Leader in the 2025 Gartner Magic Quadrant for Analytics and BI Platform
Oracle Analytics Cloud September 2025 update Empower your team with advanced AI insights, enhanced visualizations, deep customization, and seamless collaboration
Join the Oracle Analytics & AI Community Happy Hour at Oracle AI World! Secure your spot for a limited-seating, private happy hour at Oracle AI World to network with peers and Oracle experts!

Oracle Fusion SCM Analytics

Liwen Chiu · 2025-01-15 03:08:33

Hi Experts, Would like to reach out to you on how to set the default value of a Prompt with user's login name. Please refer to below screenshot that I have an Analysis created with subject area of "Receiving - Purchase Receipts Real Time", and a Prompt is using the column of "- Purchase Receipt Header Details > Created…

How to default a Prompt's selection as user's login name

Received Response

Views

Comments

Answers

Liwen Chiu Rank 4 - Community Specialist

Jan 21, 2025 3:24AM

Hi @Raghavendra Raghunath-Oracle,
We register our user accounts with each user's emails, so like mine, the user name is in fact "liwen_chiu@tslines.com".
It seems that the per_users table only have the username or user account, not the display name.
But the column "- Purchase Receipt Header Details > Created By" is using display name as selections.
May I ask what is the table that having user account's display names?
Thank you:

Liwen

0

MFA for Oracle Community

Oracle Fusion SCM Analytics

Categories

How to default a Prompt's selection as user's login name

Answers