My Oracle Support Banner

FCCM NPRD - Mar 1 Daily Batch Has Failed (Doc ID 2958026.1)

Last updated on JULY 03, 2023

Applies to:

Oracle Financial Services Crime and Compliance Management Transaction Monitoring Cloud Service - Version NA and later
Information in this document applies to any platform.

Symptoms

FCCM NPRD Mar 1 Daily batch has failed with below error in UB_AMLDataLoad_220722_2023-03-01_1_TransactionPipeline.log

[ERROR] 2023-06-02 09:54:14.240 [http-nio-8080-exec-5] DataLoadingService - DELETE_CTL_FILE::: Error occurred in deleting existing file: load_data_20230301_stg_casa.ctl
[ERROR] 2023-06-02 09:54:14.240 [http-nio-8080-exec-5] DataLoadingService - DELETE_BAD_CSV_FILE::: Error occurred in deleting existing file: load_data_20230301_stg_casa_bad.csv
[ERROR] 2023-06-02 09:54:14.246 [http-nio-8080-exec-5] DataLoadingService - Some Bad Records

--

[DEBUG] 2023-06-02 09:54:14.096 [http-nio-8080-exec-5] DataLoadingService - Record 1: Rejected - Error on table STG_CASA_TXNS_TEMP_1167929275, column V_SERVICE_CHARGE_CODE.
[DEBUG] 2023-06-02 09:54:14.096 [http-nio-8080-exec-5] DataLoadingService - Field in data file exceeds maximum length
[DEBUG] 2023-06-02 09:54:14.096 [http-nio-8080-exec-5] DataLoadingService - Record 68: Rejected - Error on table STG_CASA_TXNS_TEMP_1167929275, column FIC_MIS_DATE.
[DEBUG] 2023-06-02 09:54:14.096 [http-nio-8080-exec-5] DataLoadingService - ORA-01400: cannot insert NULL into (FIC_MIS_DATE)
[DEBUG] 2023-06-02 09:54:14.097 [http-nio-8080-exec-5] DataLoadingService -
[DEBUG] 2023-06-02 09:54:14.097 [http-nio-8080-exec-5] DataLoadingService - Table STG_CASA_TXNS_TEMP_1167929275:
[DEBUG] 2023-06-02 09:54:14.097 [http-nio-8080-exec-5] DataLoadingService - 66 Rows successfully loaded.
[INFO ] 2023-06-02 09:54:14.097 [http-nio-8080-exec-5] DataLoadingService - Rows successfully loaded : 66
[DEBUG] 2023-06-02 09:54:14.097 [http-nio-8080-exec-5] DataLoadingService - 2 Rows not loaded due to data errors.
[INFO ] 2023-06-02 09:54:14.097 [http-nio-8080-exec-5] DataLoadingService - Rows not loaded due to data errors : 2
[DEBUG] 2023-06-02 09:54:14.097 [http-nio-8080-exec-5] DataLoadingService - 0 Rows not loaded because all WHEN clauses were failed.
[INFO ] 2023-06-02 09:54:14.097 [http-nio-8080-exec-5] DataLoadingService - Rows not loaded because all WHEN clauses were failed : 0
[DEBUG] 2023-06-02 09:54:14.097 [http-nio-8080-exec-5] DataLoadingService - 0 Rows not loaded because all fields were null.
[INFO ] 2023-06-02 09:54:14.097 [http-nio-8080-exec-5] DataLoadingService - Rows not loaded because all fields were null : 0
[DEBUG] 2023-06-02 09:54:14.097 [http-nio-8080-exec-5] DataLoadingService -

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.