You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Unable to view audit data in _ tables

edited May 19, 2020 1:53PM in Reporting and Analytics for ERP 6 comments

Summary

Unable to view audit data in _ tables

Content

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:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!