Extract Data via BICC from Fusion SaaS
Summary: Hi, I'm trying to extract data from ERP SaaS via BICC for below tables.
Per the CX BIVO-to-Database Mappings document Rel13_21.x_BICC_FSCM_Database_Mapping_with_ViewObjects.zip, AP_INVOICES_ALL maps to multiple PVOs like
1) FscmTopModelAM.FinApInvTransactionsAM.InvoiceHeaderPVO 2)FscmTopModelAM.FinApInvTransactionsAM.InvoiceDistributionPVO 3)FscmTopModelAM.FinExtractAM.ApBiccExtractAM.InvoiceLineExtractPVO
and many more. I've tried to extract the data using some of those however data extracted using #1 and #2 above has duplicate records (records have same primary key) in the file extracted and #3 does not extract any data. Could you please advise which other PVO should be used to extract data that does not extract/list duplicate records in the file (spreadsheet)?