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 New Product Roadmap June 2025 Oracle Analytics June '25 roadmap: OAC & FDI updates, fresh look, enhanced features.
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!

Welcome to the Oracle Analytics Community

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

Comments

HI, Use this code to get the Person Number and Roles Mapped to the User. SELECT DISTINCT EMPL.PERSON_NUMBER, PRD.ROLE_NAME FROM PER_USER_ROLES UR, PER_USERS PU, PER_ALL_PEOPLE_F EMPL, PER_ROLES_DN_VL PRD WHERE PU.USER_ID = UR.USER_ID AND PU.PERSON_ID = EMPL.PERSON_ID AND UR.ROLE_ID = PRD.ROLE_ID Thanks & Regards, Surendar…

in Fusion : Table which stores UserIds against Role names? Comment by Surendar Babu Jul 25, 2017 5:54AM