OFSA-43004 & ORA-01452: Transformation of Ledger Stops Before All Records Processed in OFSA 4.5 (Doc ID 219122.1)

Last updated on JULY 31, 2017

Applies to:

Oracle Financial Data Manager - Version 4.5 to 4.5.39 [Release 4.5]
Information in this document applies to any platform.
Oracle Financial Data Manager - Version: 4.5 to 4.5.39
Transformation ID
Note: All OFSA 4.5 products have reached sustaining support.

Symptoms

In an Oracle Financial Services Applications (OFSA) module (ex. Performance Analyzer, Risk Manager, etc.), when you run a Transformation ID for the Ledger Stat table, the transformation stops before all records are processed.  You find the following errors in the ofste.xxxxx.log from the log directory on the server:

OFSA-43004: WARNING: Unable to create primary index on table: <table name>

ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found

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