My Oracle Support Banner

OBIA 11g: HRA: Duplicate Keys On W_PSFT_WEVT_HDC_PS (Doc ID 1621189.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Business Intelligence Reporting and Publishing - Version and later
Information in this document applies to any platform.


OBIA 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.


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.