INSERT Oracle Error: ORA- 00001: unique constraint (OFSAA.PK_FSI_M_DATA_IDENTITY_DETAIL) violated Driver Error Running Allocation (Doc ID 1391501.1)

Last updated on OCTOBER 04, 2016

Applies to:

Oracle Financial Services Profitability Management - Version 5.6 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI) - Version 7.2
Oracle Financial Services Analytical Applications (OFSAA) - Version 5.x
OFSPM

Symptoms

On Oracle Financial Services Profitability Management (PFT) 5.6, when attempting to run an allocation, the following error occurs:

ERROR

Module Logging OFS errors: (203105) Oracle drv_oci error: OCI Function: [4] - oexec(),
oexn() SQL Function: [3] -
INSERT Oracle Error: ORA- 00001: unique constraint
(OFSA_OWNER.PK_FSI_M_DATA_IDENTITY_DETAIL) violated Driver
Function: drv_oci::Execute() SQL Statement:
INSERT INTO FSI_M_DATA_IDENTITY_DETAIL (identity_code,
as_of_date, src_drv_as_of_date, src_drv_type , row_count, balance
, parent_identity_code, balance_type_cd )
SELECT 11741.000000000000000 , '08/ 31/ 2010' , '08/ 31/ 2010' ,
'S' , TT.* , 105.000000000000000
from (
select count(a.identity_code), SUM((NVL(a.LOCATION_PREMIUM_BV,
0)+ NVL(a.LOCAL_INT_MARGIN_DEDUCTION_BV, 0))),
NVL(a.identity_code_chg , 0)
from RI_DEPOSITS a
where a.as_of_date='08/ 31/ 2010'
group by a.identity_code_chg ) TT

The issue can be reproduced at will with the following steps:
1. Create a new expression
2. Create a new allocation
3. Run the allocation
4. The mentioned error occurs

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