Table Documentation - Data Source: AuditViewDB

Prudence K

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!

Noelle Bartlam-Oracle

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

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

User_B8VQC

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

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?

User_B8VQC

Hi Prudence,

Yes, the process is correct.

 

Regards,

Anil