My Oracle Support Banner

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 11.1.1.10.2 and later
Information in this document applies to any platform.

Goal

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.


 

Solution

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
Goal
Solution
References


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