OBIA 11g: HRA: Duplicate Keys On W_PSFT_WEVT_HDC_PS
Last updated on JANUARY 30, 2017
Applies to:Business Intelligence Reporting and Publishing - Version 184.108.40.206.1 and later
Information in this document applies to any platform.
OBIA 220.127.116.11.1 HRA, using PSFT 9.1 adapter on Peoplesoft HVM 9.1.
Package sde_psft_persistedstage_workforceevent_headcount inserts records with duplicate keys into w_psft_wevt_hdc_ps on a limited number of rows. 11460 unique keys after a full load, and 60 duplicates (120 records).
These see to be all cases where in the source data exists with both empl_rcd 0 and 1. The duplicates all have a empl_rcd of 0.
The error codes are generated by the table_maint_proc that follows the package and tries to create a unique index on w_psft_wevt_hdc_ps.
The situation looks like the one mentioned in Doc ID 1615571.1, but on a different table.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms