Thanks Sumanth,

I already know this approach:

But I cannot find the way to query for:

oracle.apps.financials.payables.shared.publicView.ReportsBankAccountPVO

or ReportsPayeePVO or ReportsSupplierSitesPaymentContextPVO

I am missing something, how to compose the query for these PVOs? I need the AM, where to find them?

Juan

Hi Luis,

Our host has turned off a few years ago in OTBI the OBI feature to issue SQL using select_physical. I assume due to hacking penetration test security concerns or something like that.

But you can still query a PVO. In your data set of type SQL your data source must be Oracle BI EE.

Then you issue sql - see the examples in the answers in this post

select all t.* from EXTERNAL('ADF',"…"."Connection Pool")."…PVO" t order by null

Test your SQL query out first on page Issue SQL /analytics/saw.dll?issuerawsql. For this as bi administrator on page manage privileges /analytics/saw.dll?PrivilegeAdmin grant to your user or a role your user is grated or inherit the privileges Issue SQL Directly and Manage Sessions.

for example

select all t.* from EXTERNAL('ADF',

'"oracle.apps.hcm.model.analytics.applicationModule.HcmTopModelAnalyticsGlobalAM_HcmTopModelGlobalAMLocal"."Connection Pool"').'HcmTopModelAnalyticsGlobalAM.HCMExtractAM.UserBiccExtractAM.RoleDNExtractPVO'

t

fetch first 7 rows only

Then for it to work in your data model in your report in OTBI you need the users of your report need to be granted access to that data source to issue logical SQL using this database connection. As bi administrator go to manage publisher in OTBI using page Administration /analytics/saw.dll?Admin. Select Data source of type JDBC Connection then select data source row for the out of the box bi metadata repository database using jdbc:oraclebi called "Oracle BI EE". Scroll to the bottom then move to allowed role an available role your users have such as BI Consumer Role then scroll to the top again to Apply. Sorted.

Hi, it seems that is no longer to add new JDBC connection with the release 24D.