I need to query PVO data in BI Publisher, here's the PVO name:
HcmTopModelAnalyticsGlobalAM.HcmElementSetupAM.ElementEntryValue
Any screenshots, ideas, hints?
Thanks.
@Juan Jesus - OTBI team can assist you with the same. Please create a request in the below forum seeking the information on the query formation for the PVOs you are having issues with.
https://community.oracle.com/products/oracleanalytics/categories/otbi
Hello , any idea i am not able to Query the following
select_physical * from "FscmTopModelAM.FinExtractAM.ArBiccExtractAM.TransactionLineExtractPVO"
Hi @User_H31GM
You can review the below sample one
select * from EXTERNAL('ADF','"oracle.apps.fscm.model.analytics.applicationModule.FscmTopModelAM_FscmTopModelAMLocal"."Connection Pool"').'FscmTopModelAM.FinFunBusinessUnitsAM.BusinessUnitPVO' as t FETCH FIRST 100 ROWS ONLY
@Sumanth V -Oracle / Community
In order to a do a data mapping exercise, I am trying to look at the columns and "the data" in a BICC Public view object as BICC is being used to extract data out of oracle to a data warehouse
Is it possible to query BICC public views
I get the message Missing left Parenthesis
Select * from
EXTERNAL('ADF','"oracle.apps.fscm.model.analytics.applicationModule.FscmTopModelAM_FscmTopModelAMLocal"."Connection Pool"').'FscmTopModelAM.ScmExtractAM.DooBiccExtractAM.FulfillLineDetailExtractPVO' as t
FETCH FIRST 100 ROWS ONLY
Alternatively – If I try writing
select_physical * from "'FscmTopModelAM.ScmExtractAM.DooBiccExtractAM.FulfillLineDetailExtractPVO"
It gives error “Missing Right Parenthesis”
Is there anything i did wrong
Hello @Nathan CCC
I am getting same connection pool error when issueing SQL for ERP PVO, hwoever it retruns data for HCM PVO.
Can you help what is missing in this case ?
Regards Sandeep
