How to know when a role is granted

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.

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. :-(

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