Hi @proharikg,

You can use following tables.

• FNDRR_USER_CLIENT_PROFILE_TAB
• FNDRR_CLIENT_PROFILE_TAB
• FNDRR_CLIENT_PROFILE_VALUE_TAB

In FNDRR_USER_CLIENT_PROFILE_TAB, you would ideally see 3 profiles per user and you can identify which is which using the value in ‘ORDINAL’    column. 

Ordinal 0 - current personal profile

Ordinal 1 - current base profile

Ordinal 9 - IFS Standard profile, which is assigned by the system the first time a user logs into the application. 

Hope this helps!

Hi Charith,

I can only find Profile ID in this table , could you please help me to find the base profile name which is associated with these id’s

Base profiles can be identified using following query

select * from CLIENT_PROFILE where owner is null

Base profiles can be identified using following query

select * from CLIENT_PROFILE where owner is null

Base profile values:

select p.profile_id, p.profile_name,
       pv.profile_id,
       pv.profile_section,
       pv.profile_entry,
       pv.profile_value,
       pv.profile_binary_value   
       from CLIENT_PROFILE p, CLIENT_PROFILE_VALUE pv
where p.owner is null
and p.profile_id = pv.profile_id

Cheers!

Damith

Base profiles can be identified using following query

select * from CLIENT_PROFILE where owner is null

Base profile values:

select p.profile_id, p.profile_name,
       pv.profile_id,
       pv.profile_section,
       pv.profile_entry,
       pv.profile_value,
       pv.profile_binary_value   
       from CLIENT_PROFILE p, CLIENT_PROFILE_VALUE pv
where p.owner is null
and p.profile_id = pv.profile_id

Cheers!

Damith

Hi @proharikg,

If all you need is just the base profile IDs and their names, then following query mentioned in @dsj’s reply is the easiest way to do that. 

I should also highlight that a certain profile appears in FNDRR_USER_CLIENT_PROFILE_TAB only if it is assigned to a user. Otherwise it will not show up here. So to list down all base profiles, regardless of whether they are assigned to a user or not, above query is more accurate.

You can JOIN these tables as necessary using the Profile_ID column to fetch any other data you need since it is common to them all.

Hope this helps!