My Oracle Support Banner

Error ORA-00001: Unique Constraint While Executing Customer_Master Feed (Doc ID 2429496.1)

Last updated on AUGUST 03, 2018

Applies to:

Oracle FLEXCUBE Private Banking - Version 12.0.3 and later
Information in this document applies to any platform.

Symptoms

Below exception is observed in viewlog of Customer Master feed upload:


Error FOR EXTERNAL CLIENT ID:<Client_id> EXCEPTION : INSERTING DATA INTO CRM_CLIENT_MASTER. ERROR :ORA-00001: unique constraint violated

Changes

Based on the data shared by the bank, the customer data has been partially deleted using scripts at some point. Hence customer data is not present in Client Master table whereas the data from below tables remains undeleted.

1) SMS_APP_USER

2) SMS_USER_ROLE

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!


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