Which Table Can We Find The Role Name Values In Oracle BRM Database?
(Doc ID 1338306.1)
Last updated on AUGUST 13, 2018
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' ;
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document