Client cannot view report data

Diego Zegarra

I have create a report BIP with data model but when the user execute it the result is empty when I can see data

example:

My user view:

Customer view:

Riyaz Ali-Oracle

Hey Diego,

It looks like to be a permission issue. Verify User Permissions:

1. The user running the report might lack access to required data.
2. Confirm role-based security settings and ensure the user has read access.
3. Please schedule the report directly from BIP application by enabling the diagnostics log option for both users. Once the process is completed, Compare BIP Diagnostics log for both user.( There should be '1=2' condition for the non-working user)

DocID:2473421.1 Fusion Applications BI Publisher: How to collect Diagnostics log for a scheduled BIP Report?

Incase of still issue, Please raise a SR with Oracle Support.

MandeepGupta

Client cannot view report data

Diego Zegarra

May 7, 2025

I have create a report BIP with data model but when the user execute it the result is empty when I can see data

example:

My user view:

https://us.v-cdn.net/6037859/uploads/H7KC6T53EJD7/image.png

Customer view:

https://us.v-cdn.net/6037859/uploads/NRKCJFXS3OR6/image.png

---

View Post

Hi Diego,

Is the BIP DM based on SQL query or OTBI analysis? OTBI Analysis inherits the application security. But if it is SQL based, are you using any secured views to restrict the data? If yes, try removing those and retry.

Thanks.

Arun Raj

If this is still no fixed, can you provide the query? Accessing data from some tables require adequate roles and privileges.