My Oracle Support Banner

Apply Patch 28580034 Reported Error ORA-00001: Unique Constraint (CISADM.SYS_C0052350) Violated (Doc ID 2490075.1)

Last updated on DECEMBER 23, 2020

Applies to:

Oracle Financial Services Revenue Management and Billing - Version 2.4.0.1.0 to 2.4.0.1.0 [Release 2]
Information in this document applies to any platform.

Symptoms

On : 2.4.0.1.0 version, IP - Installation Upgrade Process

Apply roll up patch 28580034. During processing the single patch 22450873 within the roll-up, following error reported:

ERROR
-----------------------
Error: ORA-00001: unique constraint (CISADM.SYS_C0052350) violated (DBD ERROR: OCIStmtExecute)occured while executing INSERT INTO CI_MD_FLD(FLD_NAME,BASE_FLD_NAME,DATA_TYPE_FLG,EXT_DATA_TYPE_FLG,SIGNE
D_SW,FLD_PRECISION,FLD_SCALE,FLD_VAL_CB,WORK_FLD_SW,OWNER_FLG,OBJ_PROPERTY_NAME,F1_TRANSLATION_CONTEXT,F1_TRANSLATABLE_FLG) SELECT 'FLD_TYPE ',' ','CH
AR',' ','N',30,0,' ','Y','F1 ','fieldType',' ','F1YS' FROM F1_INSTALLATION WHERE NOT EXISTS (SELECT 1 FROM CI_MD_FLD WHERE FLD_NAME = 'FLD_TYPE ' AND OWNER_FLG = 'F1')

Error Occured, Do you want to start with the same SQL script again (Y/N)?


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Download Roll-up patch 28580034.
2. Apply Roll-up using command line D:\RMBPatches\28580034\FW-V4.2.0.3.0\Database\Oracle\CDXPatch>CDXPatch.exe
3. Error reported during processing patch 22450873 within the Roll-up.

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


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