Report Access Issue

Question

Hi

The user is able to access the report, but I am not — I'm getting a timeout error, even when scheduling it.

I found an alternative way to make it work, but I still can't access the report directly.

The actual issue seems to be with the HRQ_PTCPNT_RESPONSES_V table, specifically the SUBJECT_ID column.

I resolved it by modifying the query to use TRIM(HPRV.SUBJECT_ID).

Interestingly, the user can access the report without this change, but we cannot — it appears to be a table-level permission issue.

Could anyone please suggest what the exact problem might be?

Thanks in Advance.

Regards,

Karthikeyan

MandeepGupta · Answer

Hi @Karthikeyan ,

Welcome to Oracle analytics community.

I can see your question is more specific to Fusion HCM, so I suggest you to kindly post your query on cloud customer connect for more traction and response:

https://community.oracle.com/customerconnect/categories/hcm-reporting-and-analytics-for-hcm

Thanks.

Gianni Ceresa · Answer

Hi @Karthikeyan s-Oracle ,

Welcome to the (public) Oracle Analytics community and forum.

What product are you asking about? It helps if you can provide a full product name (and version if relevant). Right now you are talking about a table and a column, but Oracle Analytics Cloud or Server, both comes empty, with no data.

You are maybe not in the right place for your question…