You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

BICC Privileges or data access sets required to query PVO ReceivingReceiptTransactionExtractPVO

in Reporting and Analytics for ERP

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

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!