Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
How to access APPS packages, functions used in Discoverer in OBIEE BI Publisher

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
-
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
0 -
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.
0 -
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.
0