My Oracle Support Banner

OBIA 7963:PSFT - SDE_PSFT_PROJECTDIMENSION Mapping Failed With Duplicate Integration Id's While Loading To Project Dimension Stage Table (Doc ID 1413918.1)

Last updated on JANUARY 10, 2020

Applies to:

Data Warehouse Business Adapter for PeopleSoft - Version 7.9.6 [1340] to 7.9.6.3 [AN 1900] [Release V7]
Business Intelligence Applications Consumer - Version 7.9.6 [1340] and later
Information in this document applies to any platform.

Symptoms

After running SDE_PSFT_ProjectDimension mapping in a full load, the same Integration Id is appearing multiple times in the table. This as a result is causing failure of the unique index creation in the table. The table PS_PROJECT_DESCR the keys are the fields (BUSINESS_UNIT,PROJECT_ID, DTTM_STAMP). However, in the creating of the integration id only BUSINESS_UNIT and PROJECT_ID are used.There seems to be no criteria to filter on a single Project Desc record. Multiple project descriptions were being selected which made the map to fail.

Cause

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
Symptoms
Cause
Solution

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