Oracle Business Intelligence Applications

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

BICC PVO missing information in FscmTopModelAM.PrcExtractAM.PozBiccExtractAM.SupplierExtractPVO

Closed
62
Views
3
Comments
Daniela Simionescu
Daniela Simionescu Rank 0 - Community Observer

Hi,

Could you help me please with some advices related to below issue?

We configured FscmTopModelAM.PrcExtractAM.PozBiccExtractAM.SupplierExtractPVO in order to get Supplier information, including IncomeTaxId value for each supplier.

Even if the BIP Data set returns value for IncomeTaxId column from source table (POZ_SUPPLIERS_PII) , the BICC PVO does not display values for this column ( only null).

In addition, I have also queried the PVO in Administration page and it returns values successfully for the needed column (IncomeTaxId) :

select "VendorId",

"AliasPartyName",

"IncomeTaxId"

from EXTERNAL('ADF', '"oracle.apps.fscm.model.analytics.applicationModule.FscmTopModelAM_FscmTopModelAMLocal"."Connection Pool"').'FscmTopModelAM.PrcExtractAM.PozBiccExtractAM.SupplierExtractPVO'

Regards,

Daniela

Answers

This discussion has been closed.