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 [AN 1900] [Release V7]
Business Intelligence Applications Consumer - Version 7.9.6 [1340] and later
Information in this document applies to any platform.


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.


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

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