My Oracle Support Banner

Application Of Patch Not Successful (Doc ID 469697.1)

Last updated on SEPTEMBER 29, 2020

Applies to:

Oracle Order Management - Version 11.5.9 to 11.5.10.3 [Release 11.5 to 11.5.10]
Oracle Order Management - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

On 11.5.9 in Production:
When attempting to apply several patches system fails,
the following error occurs.

ERROR
Uploading from the data file
/u01/app/hlpth/hlpthappl/ont/11.5.0/patch/115/import/US/ontpcas.ldt

Altering database NLS_LANGUAGE environment to AMERICAN
FLOAD-DUMP INTO STAGE TABLES
FLOAD-DUMP LCT
FLOAD-DUMP LDT
FLOAD-DUMP A BATCH
FLOAD-UPLOAD FROM STAGE TABLES

Error loading seed data for OE_PC_ASSIGNMENTS: ASSIGNMENT_ID = xx,
ORA-00001: unique constraint (ONT.OE_PC_ASSIGNMENTS_U2) violated


STEPS
The issue can be reproduced at will with the following steps:
Apply patches.



.
.

Cause

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
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.