Configure Audit in BI Publisher and Standard Reports


How to Configure and Use Audit in BI Publisher for Fusion SaaS Cloud Customers? (Doc ID 2059102.1)


Starting with Fusion Application Release 19B, BI Publisher Audit is available to SaaS


Attached you can find a list of available audit reports to be used in your application. For these to be used you need to perform the following steps:


  • Turn on the Audit Logging by logging in as a BI Administrator, and via Administration -> Server Configuration -> check the Enable Monitor and Audit checkbox



  • Click on Catalog link on the Global Menu on top,. In the Catalog page, navigate to Shared Folders/Custom Folder
  • Click on Upload from the Task window in the Accordion Pane and select Audit.xdrz file for upload.
  • Please download the FusionBIPAudit.pdf attached to this doc and review the “Download Instruction” section to get the Audit.xdrz file
  • After upload you will see the Audit Folder under Custom Folder with all the sample Audit Reports included
  • Before you run the report, you need to configure the Audit Data Source.
  • Click Administration > Data Sources > JNDI Connection,
    • Click Add Data Source. On Add Data Source page,
    • Enter Data Source Name: AuditViewDB
    • JNDI Name: jdbc/AuditViewDB
    • Click “Test Connection” to confirm the data source works, and click Apply to save.
  • Under Security section for this Data Source, you can define the roles that will have access to the Audit Data. You can further add security permission to the Audit Folder to secure the access to these reports
  • The following 6 reports are available as sample Reports built using Audit Data:
    • Audit Reports
      • Audit Data for Report Execution
      • Audit Data for Catalog Object Updates
    • Usage Reports
      • Hourly Concurrency
      • Report Execution-Time Metrics
      • Report Performance by Report Type
      • Runtime Statistics