My Oracle Support Banner

ORA-00001: Unique Constraint Violated Executing OFSA 4.5 Ledger Stat Load (Doc ID 160283.1)

Last updated on OCTOBER 29, 2018

Applies to:

Oracle Financial Data Manager - Version 4.5 and later
Information in this document applies to any platform.
Oracle Financial Services Applications (OFSA) - Version 4.5
Note: All OFSA 4.5 products have reached sustaining support.
Server-Based Ledger Load
Server-Based Ledger Stat Load


When attempting to run the Ledger Stat Load in OFSA 4.5, the following error is returned:


ORA-00001: unique constraint violated

SQL> execute ofsa_util.ledger_stat_load;

BEGIN ofsa_util.ledger_stat_load;
END; *

ERROR at line 1: ORA-00001: unique constraint (LSLOADTAB) violated ORA-06512: at "SYS.DBMS_SYS_SQL", line 1076 ORA-06512: at "SYS.DBMS_SQL", line 316 ORA-06512: at "OFSA_UTIL", line 2861 ORA-06512: at "OFSA_UTIL", line 2884 ORA-06512: at "OFSA_UTIL", line 1815 ORA-06512: at line 1

The issue can be reproduced by running the Ledger Load from SQL*Plus:

1. execute ofsa_util.ledger_stat_load;


To view full details, 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 a vibrant support community of peers and Oracle experts.