PVO BankAccountExtractPVO returns bank account data in OTBI - Issue SQL but no data via BICC
Need to identify missing privilege or profile. PVO FscmTopModelAM.FinExtractAM.CeBiccExtractAM.BankAccountExtractPVO not returning data via BICC.
In Fusion > Tools > Reports and Analytics > Browse Catalog > Administration > Issue SQL :
- Following query is returning expected data :
select * from EXTERNAL('ADF', '"oracle.apps.fscm.model.analytics.applicationModule.FscmTopModelAM_FscmTopModelAMLocal"."Connection Pool"').'FscmTopModelAM.FinExtractAM.CeBiccExtractAM.BankAccountExtractPVO'
FETCH FIRST 1000 ROWS ONLY
In ODI, configuring a BI Cloud Coinnector (BICC) extract using FscmTopModelAM.FinExtractAM.CeBiccExtractAM.BankAccountExtractPVO no data is returned.
Tagged:
0