My Oracle Support Banner

ORA-01452: cannot CREATE UNIQUE INDEX on OFSA 4.5 RM Process (Doc ID 211629.1)

Last updated on DECEMBER 03, 2019

Applies to:

Oracle Risk Manager - Version 4.5 to 4.5.41
Information in this document applies to any platform.
Oracle Financial Services Applications (OFSA) 4.5
Note: All OFSA 4.5 products have reached sustaining support.


When running an RM process on server, the following error occurs in the ofsrm.xxxxx file:

OCI Function: [4] - oexec(), oexn()
SQL Function: [34] - PL/SQL EXECUTE
Oracle Error: ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found
ORA-06512: at "<OFSA OWNER>.OFSA_DBA", line 1293
ORA-06512: at "<OFSA OWNER>.OFSA_DBA", line 2170
ORA-06512: at "<OFSA OWNER>.OFSA_SQL", line 384
ORA-06512: at line 1

Driver Function: drv_oci::Execute()

SQL Statement: declare begin ofsa_sql.clone_all_indexes('<OFSA OWNER>', 'RES_DTL_123456','OFSA_IDT_RESULT_DETAIL','123456'); end;


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

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