FA BICC Some Data Is Being Excluded From Extract FscmTopModelAM.PrcPoPublicViewAM.AgreementLinePVO and standardlinePVO (Doc ID 2558864.1)

Last updated on JULY 16, 2020

Applies to:

Goal

When extracting FscmTopModelAM.PrcPoPublicViewAM.AgreementLinePVO from BICCC, missing records.... expect to see.

Example: In FscmTopModelAM.PrcPozPublicViewAM.SupplierSitePVO we see records for VendorSiteId = 30000000xxxxxx
but in FscmTopModelAM.PrcPoPublicViewAM.AgreementLinePVO we get no records extracted for PurchasingDocumentHeaderVendorSiteId = 30000000xxxxxx

================

The following datastores from BICC are returning less records than what was loaded to their base tables:

FscmTopModelAM.PrcPoPublicViewAM.StandardHeaderPVO - BICC: ~600 Base: ~16,000
FscmTopModelAM.PrcPoPublicViewAM.StandardLinePVO - BICC: ~11,000 Base: ~300,000
FscmTopModelAM.PrcPoPublicViewAM.StandardDistributionPVO - BICC: ~180,000 Base: ~1,000,000
FscmTopModelAM.PrcPoPublicViewAM.StandardShipmentPVO - BICC: ~650 Base: ~1,000,000

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.