Which Table Can We Find The Role Name Values In Oracle BRM Database?
Last updated on JUNE 19, 2017
Applies to:Oracle Communications Billing and Revenue Management - Version 220.127.116.11.0 and later
Information in this document applies to any platform.
In which database table in Oracle Communications Billing and Revenue Management(BRM), one can find the Role name values defined?
Consider an example where one create Roles in Customer Center, with names as IT, Finance, and Sales. After that he/she added user John Tiger to IT, Peter Pan to Finance and Henry Joe to Sales.
From the technical point of view (database), how do we relate Peter Pan to Finance, John Tiger to IT and Henry Joe to Sales?
What columns or fields do we need to get the desired output?
Tried the below query, but the user does not relate to the roles:
from ACCOUNT_T a, SERVICE_T b, ACCOUNT_NAMEINFO_T c
where a.poid_id0 = b.account_obj_id0 and a.poid_id0 = c.obj_id0 and b.poid_type = '/service/admin_client' ;
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms