ORA-00001 When Loading OKC_SUBCLASS_ROLES (Doc ID 294083.1)

Last updated on SEPTEMBER 06, 2016

Applies to:

Oracle Service Contracts - Version 11.5.10 to 12.2.4 [Release 11.5 to 12.2]
Information in this document applies to any platform.

Symptoms

The application of the 11.5.10 patchset fails while loading data from the data file okssresd.ldt.

This is the error message:

Uploading from the data file
/u002/app/applmgr/OABLK2appl/oks/11.5.0/patch/115/import/US/okssresd.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 OKC_SUBCLASS_ROLES: ID = 32, ORA-00001: unique constraint
(OKC.OKC_SUBCLASS_ROLES_U2) violated

 

Changes

 This issue can Also happen during an Upgrade/Migration to a higher version.

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