Oracle Business Intelligence Applications

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Business Intelligence Applications

Categories

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

Fusion : Table which stores UserIds against Role names?

Received Response
44
Views
1
Comments
User618255-OC
User618255-OC Rank 3 - Community Apprentice
in Oracle Business Intelligence Applications

Hi,

I have a question.

Is there a table in Fusion which stores which user is assigned to which role. Is this a BPM table?

Thanks a lot for your help!

-abhishek

Answers

  • Surendar Babu
    Surendar Babu Rank 1 - Community Starter

    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 Babu S D