Oracle Fusion AI Data Platform Forum

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

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

Received Response
116
Views
12
Comments
2»

Answers

  • Liwen Chiu
    Liwen Chiu Rank 5 - Community Champion

    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:

    image.png

    Liwen

  • Liwen Chiu
    Liwen Chiu Rank 5 - Community Champion

    Hi team,

    Maybe I need more specific configurations to get this right…

    I put the SQL in "Default selection" like below, and it turns out not picking up my login USERID, and showing blank only…

    Would like to know how to adjust it.

    Thank you very much.

    image.png

    Liwen