Unable to view audit data in _ tables
Summary
Unable to view audit data in _ tablesContent
Hi All
I have enabled audit for user roles and able to view the data from Tools -> Audit reports. I want to extract the same data in BI to send the data to third party systems. But I can't see any data for example for the below query -
select * from FUN_USER_ROLE_DATA_ASGNMNTS_
The following query shows that audit is enabled for the area in question and also being able to see the audit data from front end.
select distinct TABLE_NAME || '_'
from fusion.fnd_audit_attributes
Tagged:
0