Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Report Access Issue

Received Response
1
Views
2
Comments
Karthikeyan s-Oracle
Karthikeyan s-Oracle Rank 1 - Community Starter
in Oracle Analytics Cloud and Server

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

Tagged:

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    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…

  • MandeepGupta
    MandeepGupta Rank 8 - Analytics Strategist

    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.