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