ORA-00001 & OFSA_TABLES_AR1 Error Running RM Process ID (Doc ID 337855.1)

Last updated on JULY 31, 2017

Applies to:

Oracle Risk Manager - Version 4.5 to 4.5.39 [Release 4.5]
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.

Symptoms

The following error occurs in the ofsrm.xxxx log file when running a Risk Manager (RM) Process ID:

ORA-00001: unique constraint (dbowner.TABLES_MLS_PK) violated
ORA-06512: at "dbowner.OFSA_TABLES_AR1", line 13
ORA-04088: error during execution of trigger 'dbowner.OFSA_TABLES_AR1'
ORA-06512: at "dbowner.OFSA_DBA, line 1556
ORA-06512: at "dbowner.OFSA_SQL", line 235
ORA-06512: at line 1

Driver Function: drv_oci::Execute()

SQL Statement: declare begin
ofsa_sql.tm_clone_table('dbowner','OFSA_IDT_RESULT_DETAIL','RES_DTL_102757',0,'1024','1024','data_
s','102757', 'TM','1','105','20');end;

As a result, no result detail table is created.
The same error occurs for all Risk Manager processes.

A similar error may occur for TAB_COLUMNS_MLS_PK and OFSA_TAB_COLUMNS_AR1.

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