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.
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms