Impact of enabling Audit for BI Publisher

Question

I would like to understand the potential system and performance impact of enabling audit logging for BI Publisher in our Oracle Fusion environment. Specifically, I am interested in knowing if enabling audit logging for BI Publisher affects report performance and if there are any other impacts on the system, such as resource usage or storage.

Mallikarjuna Kuppauru-Oracle · Accepted Answer

Hi @User_AMVQU

Yes. You have an Advantages vs resource usage while you enable the Auditing . refer below Note and links for your reference.

Note:

The Audit tables for BI Publisher may fill up very quickly and can soon have huge amount of data that can take long time to process and may even exceed the data size limits to view these reports online. Therefore, all report properties are unchecked to be viewed online as default and these reports should be run as scheduled Jobs.

The retention period of 90 days has been set for BI Publisher Audit data. You can even create a recurring BI Publisher job to run the Audit reports and deliver the XML or CSV data and the report output to WebCenter Content or any other delivery destination.

With these reports users can identify long running reports, reports which are erroring often, etc and review the usage/performance of reports and take appropriate actions to ensure the resources are used efficiently.

https://blogs.oracle.com/fusionhcmcoe/post/bi-auditing-in-cloud-hcm

https://www.oracle.com/technetwork/middleware/bi-publisher/wp-fusionbipaudit-5459609.pdf

Regards,

Arjun