Skip to main content

Hi all,

 

I need quick help from you. I need to find out when a role is granted to an user (IFS APPS 😎.

I have a requirement to take list of users for the accounting year 2024 who has got additional roles and on which date it is added to them.

Example : Lets say I was having only one role granted till yesterday and today i have been granted with a new role . I wanted all roles connected to my user ID along with when it is connected (ie: DATE).

 

I would appreciate your quick help as this is very URGENT! Please.

 

Thanks,

Pushpa S

Hi @Pushpalatha 

you need to activate the history logs for that.

 

You may create ad SQL Query on Select * from FND_USER_ROLE and if lucky ( i do not have access to SQL Query tool for now)  the column objversion shows an Date when it was touched  latest.   Most likely it is the date of creation.  Eventually one need to look into the ..._TAB.

But it is recommended to have history table active on this one, you are then able to see who did this connection.

You may create ad SQL Query on Select * from FND_USER_ROLE and if lucky ( i do not have access to SQL Query tool for now)  the column objversion shows an Date when it was touched  latest.   Most likely it is the date of creation.  Eventually one need to look into the ..._TAB.

 

But there isn’t the date available on that the permission set assigned to a user. 

Ok  I see, then there it no option to fetch the information from the past. :-(

Ok  I see, then there it no option to fetch the information from the past. :-(

No, unfortunately.

If you want to use the history logs activate these tables:

FND_USER_ROLE_RUNTIME_TAB
FND_USER_TAB

Then use this query:

Select hl.log_id,
       hl.lu_name,
       hl.table_name,
       hl.time_stamp,
       hl.keys,
       hl.history_type,
       hla.column_name,
       hla.old_value,
       hla.new_value,
       hl.username,
       IFSAPP.FND_USER_API.Get_Description(hl.username) AS "DESCRIPTION",
       hla.objversion AS "OBJDATE"
 From IFSAPP.HISTORY_LOG hl
 Right Join IFSAPP.HISTORY_LOG_ATTRIBUTE hla
    On hl.log_id = hla.log_id
 where hl.table_name in ('FND_USER_TAB', 'FND_USER_ROLE_RUNTIME_TAB')
  Order by hl.log_id

 

Reply


Terms & ConditionsCookie settings