My Oracle Support Banner

AML Data Load Batch Failing with error "ORA-00001: unique constraint (AMLDD.PK_241) violated " (Doc ID 3054904.1)

Last updated on OCTOBER 25, 2024

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

AML Data load batch CustomerPipeline failing in NPRD with error
AMLDataLoad_220722_2024-09-26_2_CustomerPipeline.log
[ERROR] 2024-10-06 19:35:18.194 [http-nio-8080-exec-3] DataLoadingService - LOAD_TO_TEMP_TABLE::: Error occurred in running SQL Loader Command.
java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (AMLDD.PK_241) violated

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


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