My Oracle Support Banner

Supplier Flow is Failing Error "ORA-00001: unique constraint (CFIN_RFI_INT.RFI_XREF_DVM_PK) violated" (Doc ID 2894280.1)

Last updated on NOVEMBER 26, 2023

Applies to:

Oracle Retail Integration Cloud Service - Version 19.0 and later
Information in this document applies to any platform.

Goal

Supplier processing is failing with below error in Retail Financial Integration (RFI) layer :

2022-09-01T10:01:30,242 [Timer-15] DEBUG BaseOracleDao - EXECUTING : insert into RFI_XREF_DVM (CATEGORY_TYPE, CATEGORY_TYPE_DESC, COMMON_ID, RETL_ID, EXT_SYSTEM_ID, EXT_SYSTEM) values (?, ?, RFI_XREF_SEQUENCE.nextval, ?, ?, ?)[SUPPLIER_XREF][SUPPLIER_XREF][26][400278][CFIN]
2022-09-01T10:01:30,257 [Timer-15] ERROR RfiSupplierService - Error while calling Supplier service: Unable to execute ParametricStatement: insert into RFI_XREF_DVM (CATEGORY_TYPE, CATEGORY_TYPE_DESC, COMMON_ID, RETL_ID, EXT_SYSTEM_ID, EXT_SYSTEM) values (?, ?, RFI_XREF_SEQUENCE.nextval, ?, ?, ?)[SUPPLIER_XREF][SUPPLIER_XREF][26][400278][CFIN]
com.oracle.retail.rfi.common.RFIServerException: Unable to execute ParametricStatement: insert into RFI_XREF_DVM (CATEGORY_TYPE, CATEGORY_TYPE_DESC, COMMON_ID, RETL_ID, EXT_SYSTEM_ID, EXT_SYSTEM) values (?, ?, RFI_XREF_SEQUENCE.nextval, ?, ?, ?)[SUPPLIER_XREF][SUPPLIER_XREF][26][400278][CFIN]
....
Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (CFIN_RFI_INT.RFI_XREF_DVM_PK) violated
....
Caused by: oracle.jdbc.OracleDatabaseException: ORA-00001: unique constraint (CFIN_RFI_INT.RFI_XREF_DVM_PK) violated

Solution

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.