My Oracle Support Banner

OFSAA FCCMINFO_BD_ECM_20220826_1 FAILED AT TASK 22 (Doc ID 2894849.1)

Last updated on SEPTEMBER 14, 2022

Applies to:

Oracle Financial Services Enterprise Case Management - Version 8.0.7 and later
Information in this document applies to any platform.

Symptoms

Verified the issue in the log file as noted below:

LOG FILE
-----------------------
Filename = LOAD_DATA_FCCMINFO_BD_ECM_20220826_1_Task191_T2TCPP.log

See the following error:


insert into KDD_CASE_ACCOUNTS(CASE_ACCT_SEQ_ID,ACCT_BUS_RISK_NB,ACCT_CLOSE_DT,ACCT_CUST_LIST_SRC_CD,ACCT_CUST_RISK_NB,ACCT_DSPLY_NM,ACCT_EFCTV_RISK_FACTR_TX,ACCT_EFCTV_RISK_NB,ACCT_GEO_RISK_NB,ACCT_INTRL_ID,ACCT_LIST_RISK_NB,ACCT_LIST_SRC_CD,ACCT_MATCH_TX,ACCT_MATCH_TYPE_CD,ACCT_OPEN_DT,ACCT_PEER_GRP_INTRL_ID,ACCT_PRM_BRKR_CD,ACCT_RPTNG_CRNCY_CD,ACCT_STAT_CD,ACCT_STAT_DT,ACCT_TAX_ID,ACCT_TYPE1_CD,ACCT_TYPE2_CD,ALT_ACCT_ID,BUS_DMN_LIST_TX,CASH_RPT_EXMPT_FL,CMSN_SCHED_TBL_CD,CSTM_RISK1_NB,CSTM_RISK2_NB,SRC_SYS_CD,DAY_TRD_APRVL_REQ_DT,DAY_TRD_APRVL_STAT_CD,DAY_TRD_APRVL_UPDT_DT,DAY_TRD_APRVL_UPDT_U_INTRL_ID,DIVIDEND_AM,DMCLD_BRCH_CD,DSCRN_FL,DVP_RVP_FL,EMP_ACCT_FL,FEE_SCHED_CD,FIRM_ACCT_ORG_INTRL_ID,GLOBL_RLSHP_FL,GROSS_PROCEEDS_RDMPT_AM,HH_ACCT_GRP_ID,HIGH_ACTVY_ACCT_FL,HIGH_PRFL_FL,INSTN_CNTRY_CD,INT_AM,JRSDCN_CD,LAST_ACTVY_DT,LAST_STMT_DT,LEGAL_NTITY_ID,MAINT_RQMT_PT,DATA_DUMP_DT,MKTG_CAMP_CD,MRGN_APPVL_FL,MTHD_ACCT_OPNG,MTHD_INIT_FUNDS,NOTFY_LTR_SUPR_FL,NVSMT_MGR_RETL_REFRL_FL,OPTN_APPVL_DT,OPTN_APRVL_LVL_CD,MANTAS_ACCT_PURP_CD,OTHER_INCM_AM,PAY_BASIS_START_DT,PAY_BASIS_TYPE_CD,PRMRY_CUST_INTRL_ID,PRMRY_CUST_PIN_NB,PRMRY_PRDCT_TYPE_CD,PROD_INTRL_ID,PRTFLO_MGR_INTRL_ID,PTTRN_DAY_TRD_FL,RETRMT_ACCT_FL,RGSTN_TYPE_CD,RISK_TLRNC_CD,SGMNT_ID,SRC_INIT_FUNDS,SRVC_TEAM_INTRL_ID,STBLTY_SURVL_LEVEL_NB,STMT_CUST_QT,STMT_SUPR_FL,TAX_ID_FRMT_CD,TAX_PAYR_CUST_INTRL_ID,TAX_WTHLD_CD,TEST_ACCT_FL,TITL_LINE1_TX,TITL_LINE2_TX,TITL_LINE3_TX,ULTMT_INSTL_CUST_INTRL_ID,CASE_INTRL_ID,YEAR_CLSG_ACCT_BAL_AM)SELECT FCC_ACCT.ACCOUNT_SKEY,FCC_ACCT.ACCT_BUS_RISK_NB,FCC_ACCT.ACCT_CLOSE_DT,FCC_ACCT.ACCT_CUST_LIST_SRC_CD,FCC_ACCT.ACCT_CUST_RISK_NB,FCC_ACCT.ACCT_DSPLY_NM,FCC_ACCT.ACCT_EFCTV_RISK_FACTR_TX,FCC_ACCT.ACCT_EFCTV_RISK_NB,FCC_ACCT.ACCT_GEO_RISK_NB,FCC_ACCT.ACCT_INTRL_ID,FCC_ACCT.ACCT_LIST_RISK_NB,FCC_ACCT.ACCT_LIST_SRC_CD,FCC_ACCT.ACCT_MATCH_TX,FCC_ACCT.ACCT_MATCH_TYPE_CD,FCC_ACCT.ACCT_OPEN_DT,FCC_ACCT.ACCT_PEER_GRP_INTRL_ID,FCC_ACCT.ACCT_PRM_BRKR_CD,FCC_ACCT.ACCT_RPTNG_CRNCY_CD,FCC_ACCT.ACCT_STAT_CD,FCC_ACCT.ACCT_STAT_DT,FCC_ACCT.ACCT_TAX_ID,FCC_ACCT.ACCT_TYPE1_CD,FCC_ACCT.ACCT_TYPE2_CD,FCC_ACCT.ALT_ACCT_ID,FCC_ACCT.BUS_DMN_LIST_TX,FCC_ACCT.CASH_RPT_EXMPT_FL,FCC_ACCT.CMSN_SCHED_TBL_CD,FCC_ACCT.CSTM_RISK1_NB,FCC_ACCT.CSTM_RISK2_NB,FCC_ACCT.DATA_ORIGIN,FCC_ACCT.DAY_TRD_APRVL_REQ_DT,FCC_ACCT.DAY_TRD_APRVL_STAT_CD,FCC_ACCT.DAY_TRD_APRVL_UPDT_DT,FCC_ACCT.DAY_TRD_APRVL_UPDT_U_INTRL_ID,FCC_ACCT.DIVIDEND_AM,FCC_ACCT.DMCLD_BRCH_CD,FCC_ACCT.DSCRN_FL,FCC_ACCT.DVP_RVP_FL,FCC_ACCT.EMP_ACCT_FL,FCC_ACCT.FEE_SCHED_CD,FCC_ACCT.FIRM_ACCT_ORG_INTRL_ID,FCC_ACCT.GLOBL_RLSHP_FL,FCC_ACCT.GROSS_PROCEEDS_RDMPT_AM,FCC_ACCT.HH_ACCT_GRP_ID,FCC_ACCT.HIGH_ACTVY_ACCT_FL,FCC_ACCT.HIGH_PRFL_FL,FCC_ACCT.INSTN_CNTRY_CD,FCC_ACCT.INT_AM,FCC_ACCT.JRSDCN_CD,FCC_ACCT.LAST_ACTVY_DT,FCC_ACCT.LAST_STMT_DT,FCC_ACCT.LEGAL_NTITY_ID,FCC_ACCT.MAINT_RQMT_PT,FCC_ACCT.MIS_DATE,FCC_ACCT.MKTG_CAMP_CD,FCC_ACCT.MRGN_APPVL_FL,FCC_ACCT.MTHD_ACCT_OPNG,FCC_ACCT.MTHD_INIT_FUNDS,FCC_ACCT.NOTFY_LTR_SUPR_FL,FCC_ACCT.NVSMT_MGR_RETL_REFRL_FL,FCC_ACCT.OPTN_APPVL_DT,FCC_ACCT.OPTN_APRVL_LVL_CD,FCC_ACCT.ORCL_ACCT_PURP_CD,FCC_ACCT.OTHER_INCM_AM,FCC_ACCT.PAY_BASIS_START_DT,FCC_ACCT.PAY_BASIS_TYPE_CD,FCC_ACCT.PRMRY_CUST_INTRL_ID,FCC_ACCT.PRMRY_CUST_PIN_NB,FCC_ACCT.PRMRY_PRDCT_TYPE_CD,FCC_ACCT.PROD_INTRL_ID,FCC_ACCT.PRTFLO_MGR_INTRL_ID,FCC_ACCT.PTTRN_DAY_TRD_FL,FCC_ACCT.RETRMT_ACCT_FL,FCC_ACCT.RGSTN_TYPE_CD,FCC_ACCT.RISK_TLRNC_CD,FCC_ACCT.SGMNT_ID,FCC_ACCT.SRC_INIT_FUNDS,FCC_ACCT.SRVC_TEAM_INTRL_ID,FCC_ACCT.STBLTY_SURVL_LEVEL_NB,FCC_ACCT.STMT_CUST_QT,FCC_ACCT.STMT_SUPR_FL,FCC_ACCT.TAX_ID_FRMT_CD,FCC_ACCT.TAX_PAYR_CUST_INTRL_ID,FCC_ACCT.TAX_WTHLD_CD,FCC_ACCT.TEST_ACCT_FL,FCC_ACCT.TITL_LINE1_TX,FCC_ACCT.TITL_LINE2_TX,FCC_ACCT.TITL_LINE3_TX,FCC_ACCT.ULTMT_INSTL_CUST_INTRL_ID,FCC_PRECASE_CASE_MAP.V_CASE_ID,FCC_ACCT.YEAR_CLSG_ACCT_BAL_AM FROM Fcc_Precase inner join fcc_precase_case_map
on Fcc_Precase.n_event_correlation_skey=fcc_precase_case_map.n_event_correlation_skey
INNER JOIN FCC_CORRELATION_ENTITY_MAP
ON Fcc_Precase.n_event_correlation_skey=FCC_CORRELATION_ENTITY_MAP.n_event_correlation_skey
AND FCC_CORRELATION_ENTITY_MAP.V_ENTITY_TYPE='ACCOUNT' and
( (Fcc_Precase.n_run_skey <> fcc_precase_case_map.n_run_skey and Fcc_Precase.n_run_skey=FCC_CORRELATION_ENTITY_MAP.n_run_skey) or Fcc_Precase.n_run_skey=fcc_precase_case_map.n_run_skey)
INNER JOIN FCC_ACCT
ON FCC_CORRELATION_ENTITY_MAP.N_ENTITY_SKEY=FCC_ACCT.Account_Skey WHERE ((1=1) AND (1=1) AND (9=9)) AND Fcc_Precase.f_promotion_flag='Y'
and Fcc_Precase.f_process_flag='N' and Fcc_Precase.N_RUN_SKEY in (select fcc_batch_run.n_run_skey from fcc_batch_run where fcc_batch_run.v_batch_run_id in ( 'FCCMINFO_BD_ECM_20220826_1') AND fcc_batch_run.N_RUN_STATUS = 1) LOG ERRORS INTO KDD_CASE_ACCOUNTS$ ('FCCMINFO_BD_ECM_20220826_1_Task191') REJECT LIMIT 0
[August 29, 2022 at 2:35:21 PM GMT PM +0000][INFO][BACKEND][OFSAA][T2TCPP] executing insert query
FAILED: ORA ERROR : ORA-00001: unique constraint (LUAT_OFSAAFCCM.PK_1701) violated

[August 29, 2022 at 2:35:21 PM GMT PM +0000][SEVERE][BACKEND][OFSAA][T2TCPP] ClsUDBConnect::executeInsertQuery, Error, unable to execute the insert query. ERROR Message: ORA-00001: unique constraint (OFSAAFCCM.PK_1701) violated

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.