How to access APPS packages, functions used in Discoverer in OBIEE BI Publisher — Oracle Analytics

Oracle Analytics Cloud and Server

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

How to access APPS packages, functions used in Discoverer in OBIEE BI Publisher

Received Response
31
Views
3
Comments

Summary

How to access APPS packages, functions used in Discoverer in OBIEE BI Publisher

Content

We are currently migrating some Discoverer reports to OBIEE BI Publisher. We are doing this by using the SQL from the Discoverer reports and using this same SQL in the BI Publisher Data Model and creating the report in BI Publisher. However, we are having issues with some reports that are using packaged functions such as APPS.PO_INQ_SV.GET_ACTIVE_ENC_AMOUNT() where we are only returning -1. We believe this is due to a permission issue. We have granted execute permission to the PO_INQ_SV package to a role but we still receive -1; does anyone know how we can resolve this issue?

Answers

  • Brajesh Shukla-95078
    Brajesh Shukla-95078 Rank 7 - Analytics Coach

    Hi,

    If you don't have access to package in related schema it will error out by calling itself , instead of returning -1.  Code debugging require to check from where its returning -1

  • YGUTTIKONDA
    YGUTTIKONDA Rank 6 - Analytics Lead

    When you create the DB connection in BI Publisher are you using APPS user ? if not make sure the user that is being used has the appropriate access to read and execute.

  • Dclay
    Dclay Rank 3 - Community Apprentice

    No, we are not using APPS. They do not want use to use APPS due to that it has to it has too high of permissions. We need assistance on how we should setup permissions to this function as a non-apps user.