I'm dealing with Change Requests and I have found an Operand Type and Value Type of "GlobalRoleVersion"
But, what table/view does this type refer to? It doesn't appear to be PV_ROLE.
I'm dealing with Change Requests and I have found an Operand Type and Value Type of "GlobalRoleVersion"
But, what table/view does this type refer to? It doesn't appear to be PV_ROLE.
Role versions exist in the table T_AV_ROLEVERSIONS. The OPERAND_ID or the VALUE_ID in the cases described above would refer to the ROLEVERSION_ID column in the T_AV_ROLEVERSIONS table. The ROLE_ID column in the same table points to the ID of the role for which the version has been created.
Role versions are created when changes are made to roles using the role management feature.
Venkata, that is SO helpful. That makes a lot of sense.
There's not a Public View that corresponds, is there?
I ask because we're building reports and I would like to stay in the Public Views if possible.
Finally and here's a BIG ask. Can you provide the same type of answer for EACH of the possible enumerated types in the Opperand and Value fields?
So that's User | ApplicationRole | Account | UserGroup | GlobalRole | GlobalRoleVersion | GlobalRoleSet
I would LOVE to know where EACH of these IDs goes back to in a Public View or a table if not a view.
That would make my reporting SO easy.
There is no public view for the role versions.
Here are the associations for various operand and value types.
User(US) - ID of PV_USERS
ApplicationRole(AR) - ID of PV_APPLICATION_ROLE
Account(AC) - ID of PV_ACCOUNT
Usergroup(UG) - ID PV_USER_GROUP
GlobalRole(GR) - ID of PV_ROLE
GlobalRoleVersion(PR) - ROLEVERSION_ID of T_AV_ROLEVERSIONS
GlobalRoleSet(RS) - ID of PV_ROLESET
Entitlement(ET) - ID of PV_APPLICATION_ENTITLEMENT
Also look into view PV_CHANGE_REQUEST_DETAIL to see if the required details are already there.. OPERAND_NAME and VALUE_NAME for example.
Role versions exist in the table T_AV_ROLEVERSIONS. The OPERAND_ID or the VALUE_ID in the cases described above would refer to the ROLEVERSION_ID column in the T_AV_ROLEVERSIONS table. The ROLE_ID column in the same table points to the ID of the role for which the version has been created.
Role versions are created when changes are made to roles using the role management feature.