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

Question

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

AishwaryaTiwari · Answer

https://community.oracle.com/products/oracleanalytics/discussion/comment/65708#Comment_65708

Hi Did you find the solution to this, i am also facing same issue. Thanks in advance!

User_GVEIY · Answer

Hi Daniela. Did you find a solution on this? I am facing the same issue

Gianni Ceresa · Answer

Hi,

I believe BICC questions, mostly when about default PVOs, should be asked in forums looking after Fusion application as that's the one providing BICC and the PVOs.

They are covered in a parallel forum:

https://community.oracle.com/customerconnect

Look at the many categories available there and ask in the one that you believe is the most appropriate (source application / content wise).