Categories
Oracle Fusion BIP SQL using BIPUBLISHER_V to pull data from Audit Tables via BIP for custom reports
Hi Guys
I saw a very old post relating to using BIPUBLISHER_V, quoting the PDF attached, but would like to know if this is still relevant for the latest versions of Oracle Fusion BIP SQL and the use case we have?
Basically we would like to build a custom report for our users showing changes relating to COA Segments, Supplier Details etc. for a certain BU, Before and After values. They cannot use the canned reports as they show data from other BUs, which are restricted.
We have turned on the auditing in Oracle Fusion, so the before/after values are being stored somewhere in the DB, the question is which tables/views? via BIPUBLISHER_V?
Thank you guys for any insight!
Gavin
Answers
-
Hi Gavin,
The reports you are mentioned are related to changes happening on BIP objects - catalogs etc but not on the changes related to a particular module.
If you are looking for a particular table, you need to check audit tables for that main base table (audit table have similar name but ends with an underscore).
Thanks.
0 -
Hi , is anyone aware of the underlying SQL of BIPUBLISHER_V ?
0 -
I haven't seen this anywhere. Would be interesting to get the SQL behind this view. But I assume this will be a restricted object and may not be available publicly.
Hi @Raghavendra Raghunath-Oracle ,
Hope you are doing well, Can you please help if it is possible to get the query behind BIPUBLISHER_V?
Thanks.
0 -
0
-
Not able to find the audit related to OTBI report in the table "BIPUBLISHER_V". Can you please suggest
0 -
BIPUBLISHER_V
is only for BIP objects not related to OTBI
1 -
@ravikiran goda-Oracle can you let us know how to get the audit report for the OTBI Reports.
0 -
Hi please review the below document
Fusion Applications OTBI: How To Configure And Use Audit For Usage and Performance In OTBI For Fusion SaaS Cloud Customers (Doc ID 2731495.1)
1
