Constraint Violation on F1_SCHEMA When Applying DB Portion of Patch 8681042 (Doc ID 985547.1)

Last updated on JANUARY 05, 2010

Applies to:

Oracle Utilities Customer Care and Billing - Version: 2.2.0 - Release: 2.2
Information in this document applies to any platform.

Goal

During installation of the database component of Patch 8681042 the CDXPatch.exe program fails with the following error:

ERROR
-----------------------
Error: ORA-00001: unique constraint (CISADM.SYS_C0030122) violated (DBD
ERROR: OCIStmtExecute)occured while executing INSERT INTO F1_SCHEMA ( (SELECT
DISTINCT A.SCR_CD, 'F1BP',1,CASE UPPER(TRIM(A.DA
_NAME))
WHEN 'PARM' THEN '<schema><include'||decode(UPPER
(A.SCHEMA_TYPE_FLG),'F1BO','BO','F1MP','Map','F1BS','BS','F1SC','SS','F1DA','DA')||' name="'||trim(A.SCHEMA_NAME)||'"/></schema>' ELSE '<schema/>'
END,B.OWNER_FLG
FROM CI_SCR_DA A,
CI_SCR B
WHERE UPPER(TRIM(A.SCR_CD)) = UPPER(TRIM(B.SCR_CD))
AND UPPER(B.SCR_TYPE_FLG) = 'BPSC'
AND UPPER(A.SCHEMA_TYPE_FLG) IN ('F1BO','F1MP','F1BS','F1SC','F1DA')
AND NOT EXISTS ( SELECT 1
FROM F1_SCHEMA C
WHERE UPPER(TRIM(C.SCHEMA_NAME)) = UPPER(TRIM(A.SCR_CD))
AND UPPER(C.SCHEMA_TYPE_FLG) = 'F1BP'
)
)
UNION
(SELECT A.SCR_CD, 'F1BP',1,'<schema/>',A.OWNER_FLG
FROM CI_SCR A
WHERE UPPER(A.SCR_TYPE_FLG) = 'BPSC'
AND NOT EXISTS ( SELECT 1
FROM F1_SCHEMA B
WHERE UPPER(TRIM(B.SCHEMA_NAME)) = UPPER(TRIM(A.SCR_CD))
AND UPPER(B.SCHEMA_TYPE_FLG) = 'F1BP'
)
AND NOT EXISTS ( SELECT 1
FROM CI_SCR_DA C
WHERE UPPER(TRIM(C.SCR_CD)) = UPPER(TRIM(A.SCR_CD))
)
)
)

Solution

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