BICC Privileges or data access sets required to query PVO ReceivingReceiptTransactionExtractPVO
Summary:
Need to query PVO FscmTopModelAM.ScmExtractAM.RcvBiccExtractAM.ReceivingReceiptTransactionExtractPVO via BI Cloud Connector.
PVO is filtering data. Is there documentation detailing the security requirements to query Receiving PVOs in BICC ? Assuming Inventory Org data access is required but are there additional requirements ?
No luck with :
Content (please ensure you mask any confidential information):
Query in Code Snippet below returns no rows (OTBI > Administration > Issue SQL) :
Version (include the version you are using, if applicable):
25C
Code Snippet (add any code snippets that support your topic, if applicable):
select * from EXTERNAL('ADF', '"oracle.apps.fscm.model.analytics.applicationModule.FscmTopModelAM_FscmTopModelAMLocal"."Connection Pool"').'FscmTopModelAM.ScmExtractAM.RcvBiccExtractAM.ReceivingReceiptTransactionExtractPVO'FETCH FIRST 1000 ROWS ONLY