Oracle Analytics Publisher

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Impact of enabling Audit for BI Publisher

Accepted answer
21
Views
1
Comments
User_AMVQU
User_AMVQU Rank 1 - Community Starter

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.

Best Answer

  • Mallikarjuna Kuppauru-Oracle
    Mallikarjuna Kuppauru-Oracle Rank 8 - Analytics Strategist
    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