Oracle Transactional Business Intelligence

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Transactional Business Intelligence

Categories

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

The content is blocked contact the site owner to fix the issue. OTBI

Received Response
853
Views
8
Comments
Goutham.Manthri
Goutham.Manthri Rank 2 - Community Beginner
in Oracle Transactional Business Intelligence

Summary:

We have created a custom report using SQL based data model and gave permissions to the user for running it. But, they are receiving this error when trying to run the report.

Content (required):

Attaching the screenshot

Version (include the version you are using, if applicable):

22C


Code Snippet (add any code snippets that support your topic, if applicable):

Tagged:

Answers

  • Raghavan p-Oracle
    Raghavan p-Oracle Rank 5 - Community Champion

    Are you using any template, and is it invoking any third-party code/URL?

    Generally, these type of issues occurs when you use any non-orcl contents in the fusion code/logic/reports.

  • Goutham.Manthri
    Goutham.Manthri Rank 2 - Community Beginner

    Hi Raghavan,

    We just created a data model using the SQL query using HCM tables and converted it into a report.

  • Raghavan p-Oracle
    Raghavan p-Oracle Rank 5 - Community Champion

    Hi Goutham,

    Test this scenario to narrow down the issue.

    -> Limit the query result to 2 rows in the sql. -> check whether the data renders in data model.

    -> Verify each column data if it has any URLs/JS code in it. -> Now save and open the report -> do you see any issue?

    If no, then the initial issue is due to some data in the DB tables.

    you need to check each row/column data.

    Best Regards,

    Raghavan

  • Goutham.Manthri
    Goutham.Manthri Rank 2 - Community Beginner

    Hi Raghavan,

    As a report owner, I am able to see data in the report. But users are facing this issue. I gave them the permissions, but still, they are not able to see the data in the report.

  • Gaurav Bharadwaj-Oracle
    Gaurav Bharadwaj-Oracle Rank 6 - Analytics Lead

    Hi Gautham, What is the default template type you are using ?

    Is it PDF ?

    This doesn't seem like a BI issue, more to do with customer's browser and/or network.

  • Goutham.Manthri
    Goutham.Manthri Rank 2 - Community Beginner

    Hi Gaurav,

    Yes, the default is PDF. I will change it to Excel and ask the User to test again or try using a different browser.

  • Goutham.Manthri
    Goutham.Manthri Rank 2 - Community Beginner

    The report downloads when the default is set to Excel. Not sure why the error when set to PDF.

    Thanks Gaurav!

  • Gaurav Bharadwaj-Oracle
    Gaurav Bharadwaj-Oracle Rank 6 - Analytics Lead

    Hi Gautham.

    This error has to do with browser or network level restrictions or configuration on the user's PCs.

    1 of the reasons your users are seeing this could be this : https://mhedu.force.com/DTS/s/article/Google-Chrome-Content-Is-Blocked

    PDF viewer is provided by Adobe and Should be configured correctly on the browser. BI server does not control its behavior, it only uses it to show the PDF output.

    Hope that clarifies your concern.

    Thanks