Oracle Transactional Business Intelligence

Products Banner

Table Documentation - Data Source: AuditViewDB

Received Response
195
Views
5
Comments

Content

Hi all - I cannot find documentation for the data source AuditViewDB.  I have the documentation for the data source ApplicationDB_HCM (https://docs.oracle.com/en/cloud/saas/human-resources/20d/oedmh/index.html).  I submitted a ticket to Oracle to inquire where to find this documentation and was told that these tables are from BI and not from FA.  Can anyone explain that to me - what exactly that means?  How do I find all the tables available in AuditViewDB?

Thank you!

Answers

  • Prudence,

    I'd refer you to the BIPublisher white paper as the that datasource is to provide auditing information relating to BIPublisher reports.

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

     

    Noelle

  • Prudence K
    Prudence K ✭✭✭✭

    Thank you Noelle - this document is actually what drove the question.  When I use these reports, there is no name listed for the user columns.  For us, the user name is your person number.  I want to combine the person number with another field to display the person name.  We dumped the tables that sit within these queries and cannot find anything that shows us what we could potentially use.  When I look for documentation, there is nothing about what tables are available other than what is in those reports.  So, trying to understand what else is available for tables to use :)

  • Hi Prudence,

    You can create sample data model using 'AuditViewDB' data source with following query, but the other objects (apart from the view used in the audit data models) from the data source not useful for you. You can create data set with other data sources and join the data set with these audit view data sets. 

    Query: "select * from tab"

    Thanks,

    Anil

  • Prudence K
    Prudence K ✭✭✭✭

    Anil - Thank you for the query!  

    OK, so when I create two datasets (one using the audit area and one using the HCM area), when I join them together, the report just never works.  So maybe I am doing something wrong?

    AuditViewDB

    SELECT IAU_RESOURCE
    ,IAU_INITIATOR
    FROM BIPUBLISHER_V

    ApplicationDB_HCM

    SELECT DISTINCT PPSLV.PERSON_NUMBER
    , PPNF.FULL_NAME
     
    FROM PER_PERSON_SECURED_LIST_V PPSLV 
     
    INNER JOIN 
    PER_PERSON_NAMES_F PPNF 
    ON PPSLV.PERSON_ID = PPNF.PERSON_ID
    AND PPNF.NAME_TYPE = 'GLOBAL'
     
    I then choose Create Link between IAU_RESOURCE and PPSLV.PERSON_NUMBER.  When I run a test data sample, it pulls through 5 rows just fine.  But when I run a full report, it never runs (well, to be fair I canceled it after 2 hours).  So, I know I can optimize by code and get it working better, as long as I understand the process is right.  Is it?
  • Hi Prudence,

    Yes, the process is correct.

     

    Regards,

    Anil