OBIA 11g: [BI] Duplicate Records Are Getting Populated In The FscmTopModelAM.PjfProjectAM.ProjectRefPVO Extract
(Doc ID 2621730.1)
Last updated on FEBRUARY 12, 2020
Applies to:Business Intelligence Applications Consumer - Version 22.214.171.124.2 and later
Information in this document applies to any platform.
How to get one out of all the duplicates to be loaded to the DW?
Duplicate records are getting populated in the FscmTopModelAM.PjfProjectAM.ProjectRefPVO in the incremental extract file.
The base Fusion Physical table has only one record for a PROJECTID, however the extract is bringing 4 records of a same project id which are exact duplicates.
However even if the extract brings the duplicate records, SDS mappings diagnostic auto correct should handle this by rejecting the duplicates and considering only one record. This functionality is not working for SDE_FUSION_11_ADAPTOR_FTS_FUSION_FSCMTOPMODELAM_PJFPROJECTAM_PROJECT (rejecting all 4 duplicate records not considreing even 1 record) resulting the updated record not flowing to OBIA.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document