Oracle Fusion BIP SQL using BIPUBLISHER_V to pull data from Audit Tables via BIP for custom reports

GAVMAX

Hi Guys

wp-fusionbipaudit-5459609.pdf

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

MandeepGupta

Oracle Fusion BIP SQL using BIPUBLISHER_V to pull data from Audit Tables via BIP for custom reports

GAVMAX

Dec 2, 2024

Hi Guys

wp-fusionbipaudit-5459609.pdf

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

---

View Post

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.

JpSubbu

Hi , is anyone aware of the underlying SQL of BIPUBLISHER_V ?

MandeepGupta

JpSubbu

Feb 7, 2025

Hi , is anyone aware of the underlying SQL of BIPUBLISHER_V ?

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.

Mallikarjuna Kuppauru-Oracle

@Ashish Shrivastava-Oracle

Hi Ashish,

Any inputs on above Customer question/request?

Regards,

Arjun

ak1707

Not able to find the audit related to OTBI report in the table "BIPUBLISHER_V". Can you please suggest