My Oracle Support Banner

Batch Failed In Recon Load For 802 To 805 Environment with N_RUN_SKEY DM_ID STEPS ERROR_MESSAGE (Doc ID 2543743.1)

Last updated on NOVEMBER 07, 2019

Applies to:

Oracle Financial Services Behavior Detection Platform - Version 8.0 and later
Information in this document applies to any platform.

Symptoms

While copying data from 802 (ACCT_ATM_SMRY_DAILY) to 805 (FCC_ACCT_ATM_SMRY_DAILY_EVNT), the copy has been failed due to below failure. Based on our analysis, it looks like in fcc_dm_field_mapping for the DM id: 453 the process_date column configuration is not there. Since the column is having NOT NULL constraint.


N_RUN_SKEY DM_ID STEPS ERROR_MESSAGE
13618 453 4 ORA-01400: cannot insert NULL into ("LC_SAILECMFCCM_01"."FCC_ACCT_ATM_SMRY_DAILY_EVNT"."PROCESS_DATE")


2. While copying data from 802 (KDD_BREAK, KDD_BREAK_MTCHS) to 805 (FCC_EVENT_ENTITY_MAP) the data is not copied due BASE_TABLE configuration mismatch. It looks like, in fcc_dm_definition for the DM id:708 in V_SRC_FILTER a filter condition is there (BASE_TABLE=’NTCPTRY_PRFL’) instead of (BASE_TABLE=’ACCT_ATM_SMRY_DAILY’).

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
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.