Getting OFSA-44309, ORA-00001, ORA-04088 Running Ledger Transformation (Doc ID 228196.1)

Last updated on JUNE 29, 2009

Applies to:

Oracle Financial Services Applications (OFSA) 4.5
Oracle Financial Data Manager - Version: 4.5
This problem can occur on any platform.
Transformation ID
Checked for relevance 29-Jun-2009.

Symptoms

In Oracle Financial Services Applications (OFSA) 4.5, you get an error running Ledger Stat transformation.  The following errors appear in ofste.xxxxx log after turning on server debug:

OFSA-44309: Error in block: Drop Result Table
ORA-00001: unique constraint (xxxxx.TABLES_MLS_PK) violated
ORA-04088: error during execution of trigger 'xxxxx.OFSA_TABLES_AR1'

As a result, the LEDGER_STAT table is not transformed.

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