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

Last updated on JANUARY 30, 2017

Applies to:

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

Symptoms

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

Cause

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