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  to 18.104.22.168 [AN 1900] [Release V7]
Business Intelligence Applications Consumer - Version 7.9.6  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