How to identify differences between two users’ job or parent roles instead of inherited roles?

 In the Security Console, under Users → Compare Users, the comparison lists all inherited roles.

How to view or compare only the users’ job or parent roles?

As a work-around build the custom BI Report using the below query:

 SELECT USER1.ROLE_NAME1,
        USER2.ROLE_NAME2
FROM   (SELECT PU.USERNAME    USERNAME1,
               PRDT.ROLE_ID   ROLE_ID1,
               PRDT.ROLE_NAME ROLE_NAME1
        FROM   PER_USER_ROLES PUR,
               PER_USERS PU,
               PER_ROLES_DN_TL PRDT,
               PER_ROLES_DN PRD
        WHERE  PU.USER_ID = PUR.USER_ID
               AND PU.USERNAME = 'USER1' -- UserName1
               AND PRDT.ROLE_ID = PUR.ROLE_ID
               AND PRDT.ROLE_ID = PRD.ROLE_ID
               AND PRDT.LANGUAGE = USERENV ('LANG')
               AND PU.ACTIVE_FLAG = 'Y') USER1
       FULL OUTER JOIN (SELECT PU.USERNAME    USERNAME2,
                               PRDT.ROLE_ID   ROLE_ID2,
                               PRDT.ROLE_NAME ROLE_NAME2
                        FROM   PER_USER_ROLES PUR,
                               PER_USERS PU,
                               PER_ROLES_DN_TL PRDT,
                               PER_ROLES_DN PRD
                        WHERE  PU.USER_ID = PUR.USER_ID
                               AND PU.USERNAME = 'USER2' -- UserName2
                               AND PRDT.ROLE_ID = PUR.ROLE_ID
                               AND PRDT.ROLE_ID = PRD.ROLE_ID
                               AND PRDT.LANGUAGE = USERENV ('LANG')
                               AND PU.ACTIVE_FLAG = 'Y') USER2
                    ON USER1.ROLE_ID1 = USER2.ROLE_ID2  

Create Data Model

Navigation: Tools → Reports and Analytics → Browse Catalog

Create → Data Model

Sample Output

Save Sample Data

Create Report

Roles can be easily compared between two users and exported to Excel.