Which Table Can We Find The Role Name Values In Oracle BRM Database? (Doc ID 1338306.1)

Last updated on JUNE 19, 2017

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.2.1.0.0 and later
Information in this document applies to any platform.

Goal

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:

select c.COMPANY, c.CITY, c.FIRST_NAME, c.LAST_NAME, b.LOGIN
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' ;

Solution

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