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

Question

Summary

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?

Dclay · Answer

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.

YGUTTIKONDA · Answer

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.

Brajesh Shukla-95078 · Answer

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