You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Oracle OTBI Report View does not run for wider search

edited Jan 29, 2025 3:29PM in Reporting and Analytics for ERP 2 comments

The only table/view I have been able to identify, that provides OTBI report usage statistics is the BIPUBLISHER_V view as provided by Oracle. This view consistently either fails or takes forever to complete (running the SQL select below) via scheduled report. The report is a simple select to count how many times a report has been used in a given time period. Regardless of time period, the report still fails.

Is this an issue with this view? Does anyone have the underlying tables in that view?

SQL below:

select
count(IAU_INITIATOR),
IAU_RESOURCE

from BIPUBLISHER_V

where 1=1

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!