R12 Patch 9363006/6678700 errors with ORA-00001: unique constraint (IBY.IBY_UPG_PPP_B_U1) violated

(Doc ID 1278933.1)

Last updated on SEPTEMBER 02, 2016

Applies to:

Oracle Payments - Version 12.1.1 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.
Checked for relevance on 24-Sep-2012.

Symptoms

Patch 9363006/6678700 fails on worker 1 with error "US_ibyupgpp_ldt.log" found ORA-00001: unique constraint (IBY.IBY_UPG_PPP_B_U1) violated

Changes

While loading seeded data from (ibytmppp.ldt, ibyupgpp.ldt),
FNDLOAD is getting failed with Numeric or Value Error and (or)
with unique constraint (IBY.IBY_UPG_PPP_B_U1) violated

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