GOV_CLASS Key Issue in OWS J_STAGE_PS_VNDR_GOV_CERT FSCM91 and FSCM92 ETL Jobs (Doc ID 2051988.1)

Last updated on SEPTEMBER 03, 2015

Applies to:

PeopleSoft Enterprise EPM Foundation - Version 9.1 to 9.1 [Release 9]
Information in this document applies to any platform.

Symptoms

The source table PS_VNDR_GOV_CERT has unique index on columns (SETID, VENDOR_ID, CERTIF_SOURCE, GOV_CLASS, EFFDT).

The OWS table PS_VNDR_GOV_CERT has unique index on columns (SETID, VENDOR_ID, CERTIF_SOURCE, EFFDT, SRC_SYS_ID).

GOV_CLASS column is missing from the unique index.

Therefore the job will fail for certain rows with unique index violation error.

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