Oracle Transactional Business Intelligence

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

Table to retrieve records from Audit reports in Oracle Cloud Fusion ERP 22A

Accepted answer
6282
Views
21
Comments

Summary:

Table to retrieve records from Audit reports in Oracle Cloud Fusion ERP 22A

Content (required):

Which table in SaaS stores information for Audit Reports?

Table to retrieve records from Audit reports in Oracle Cloud Fusion ERP 22A


Navigation

Tools - Reports & Analytics - Audit Reports

Version (include the version you are using, if applicable):

22A

Code Snippet (add any code snippets that support your topic, if applicable):


Welcome!

It looks like you're new here. Sign in or register to get started.

Best Answer

  • Rank 5 - Community Champion
    Answer ✓

    I got the audit tables for base tables. As per current analysis, it appears the audit occurs on the basis of audit policies set for the entity. the base table name with _ will be the audit table for the base table.

«13

Answers

  • Can you be a bit specific which audit data you are looking for ?

    Since you have created this thread under OTBI i would assume you are looking for BI related audit data ?

    Take a look at this

    Main Document : https://docs.oracle.com/en/cloud/saas/otbi/otbi-pub-admin/view-audit-data-publisher-catalog-objects.html#GUID-6E05FC42-D2CF-4658-B9A1-595968CC8FA6

    Download Sample Audit Reports with table and query details here : https://docs.oracle.com/en/cloud/saas/otbi/otbi-pub-admin/view-publisher-audit-data.html#GUID-5DF09423-C313-4B03-9F6E-BC414B9895E9

  • Rank 1 - Community Starter

    Hi,

    Can you please share the table names? Thanks

  • Rank 5 - Community Champion

    Sample table is for example : fa_additions_b , the audit table is fa_additions_b_

  • Rank 1 - Community Starter

    Thanks for sharing. Just for everyone's information I was specifically looking for the Audit Tables related to roles assignment at user level. Confirmed over SR that we do not have access to audit tables related to user role assignment. Alternatively OTBI subject area can be used to access that information (its Security Audit something.)

  • Rank 1 - Community Starter

    Hi ,

    Can any one help me to find the table name's which are storing the Permissions change details for BIP folder in catalogue.

    I can see in Audit Reports page but can't able to find which table stores this information.

    Thanks

  • Rank 5 - Community Champion
    edited Nov 14, 2023 1:58PM

    Hi @User_J3N5J

    This is mostly in bipublisher_v.

    1. Log in to BI Publisher with administrator privileges and click the Administration link.
    2. Under Data Sources, click JNDI Connection, then click Add Data Source.
    3. Enter the Data Source Name and JNDI Name jdbc/AuditViewDataSource.
    4. Click Test Connection to ensure that the data source connection works.
    5. Add the appropriate roles to the data source so that the report developers and consumers can view the reports built on this data source.
    6. Click Apply to save

    Select IAU_EVENTCATEGORY,

        IAU_EVENTTYPE,

        IAU_EVENTSTATUS,

        to_char("IAU_TSTZORIGINATING", 'DD-MON-YYYY HH24:MI:SSxFF') as IAU_DATETIME,

        IAU_INITIATOR,

        IAU_RESOURCE,

        IAU_MESSAGETEXT

    from BIPUBLISHER_V;


    Thanks

    Abhilash

  • Rank 1 - Community Starter

    Hello

    Can any one help me to find the table names  in SaaS which are storing the Event type, Business object type and description columns in Audit reports screen please


    Thanks

  • Rank 5 - Community Champion

    Hi @Alejandro Castillo Angeles ,

    This screen info is based on audit policies defined in Setup and Maintenance. If the audit is configured for products then you can find the information in the audit tables for the base tables. For example. for Product "Assets", it will be fa_additions_b as base table and fa_additions_b_ is the audit table. You can find latest record with audit action type as Update and old has history. Adding the underscore in the end would give you the corresponding audit table for the records in the screen.

    Please mark the answer as accepted if you are to be find for your case.

    Thanks,

    Abhilash

  • Rank 1 - Community Starter

    @Abhilash K Hi

    The BIPUBLISHER_V view only contains movements made in OTBI, however, I need to know which view stores the movements made in the ERP Cloud, could you help me with this information please?.
    


Welcome!

It looks like you're new here. Sign in or register to get started.