Oracle usage report that breaks down when a user last used a particular role.
We have requirement to build a BIP report where we need get the details when a user last used a particular role.
As an example, A user last accessed Procurement module from fusion application on 07/29/2023 which means that Procurement Manager role was last used by that user is on 07/29/2023.
When we run the BIP report we are expecting to the get the 'last used a particular role' date as mentioned above.
Could you please help us with table name which stores the details when a particular role was used by a user.
Version (include the version you are using, if applicable):