My Oracle Support Banner

Warning When Installing Patch 30555840: OFS BD 8.0.7.0.129 (Doc ID 2777594.1)

Last updated on MAY 29, 2021

Applies to:

Oracle Financial Services Know Your Customer - Version 8.0.0 and later
Information in this document applies to any platform.

Goal

We have been installing following below patch. However, after patch installing finished, we have received following warning in "OFS_BD_LOG.log" file, which is attached to SR:

Patch 30555840: OFS BD 8.0.7.0.129: KYC DI BATCH FAILED AT TASK 9 POPULATE CUST_ID_DOC_PRCSNG (OFSBD patch 8.0.7.0.129)

[Thu 13/5/2021 01:42:18] [OFS_BD] [ WARN] - Query:

DECLARE
n INTEGER;
BEGIN
select COUNT(*)
into n
from USER_CONSTRAINTS
where TABLE_NAME = 'CUST_ID_DOC_SNAPHSOT' and CONSTRAINT_NAME='CUST_ID_DOC_SNAPHSOT_PK1';
IF n = 0 THEN
EXECUTE IMMEDIATE 'ALTER TABLE CUST_ID_DOC_SNAPHSOT ADD CONSTRAINT CUST_ID_DOC_SNAPHSOT_PK1 PRIMARY KEY (CUST_INTRL_ID, DOC_TYPE_CD, DOCUMENT_ID, FIC_MIS_DATE, BATCH_RUN_ID)';
ELSE
EXECUTE IMMEDIATE 'ALTER TABLE CUST_ID_DOC_SNAPHSOT DROP CONSTRAINT CUST_ID_DOC_SNAPHSOT_PK1';
EXECUTE IMMEDIATE 'ALTER TABLE CUST_ID_DOC_SNAPHSOT ADD CONSTRAINT CUST_ID_DOC_SNAPHSOT_PK1 PRIMARY KEY (CUST_INTRL_ID, DOC_TYPE_CD, DOCUMENT_ID, FIC_MIS_DATE, BATCH_RUN_ID)';
END IF;
END;

Warn:ORA-00955: name is already used by an existing object
ORA-06512: at line 13

[Thu 13/5/2021 01:42:18] [OFS_BD] [ INFO] - # of errors in file=1

In our environment, we see that we already have "CUST_ID_DOC_SNAPHSOT_PK1" created, however it is only created on 4 columns but not on 5 as per patch log:

CREATE UNIQUE INDEX "OFSAAFCCM"."CUST_ID_DOC_SNAPHSOT_PK1"
ON "OFSAAFCCM"."CUST_ID_DOC_SNAPHSOT" ("CUST_INTRL_ID", "DOC_TYPE_CD", "FIC_MIS_DATE", "BATCH_RUN_ID")

Also, patch did not drop and re-created the constraint, as per following statements:

EXECUTE IMMEDIATE 'ALTER TABLE CUST_ID_DOC_SNAPHSOT DROP CONSTRAINT CUST_ID_DOC_SNAPHSOT_PK1';
EXECUTE IMMEDIATE 'ALTER TABLE CUST_ID_DOC_SNAPHSOT ADD CONSTRAINT CUST_ID_DOC_SNAPHSOT_PK1 PRIMARY KEY (CUST_INTRL_ID, DOC_TYPE_CD, DOCUMENT_ID, FIC_MIS_DATE, BATCH_RUN_ID)';

Shall we therefore drop CUST_ID_DOC_SNAPHSOT_PK1 constraint and re-create it again? Could you please confirm?


 

Solution

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
Goal
Solution


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