My Oracle Support Banner

CFIN-RFI-RMS: Supplier Does Not Exist But Cannot Be Created (Doc ID 2889575.1)

Last updated on AUGUST 18, 2022

Applies to:

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

Symptoms

CFIN-RFI-RMS: Supplier does not exist but cannot be created

While trying to create a new supplier (not supplier site), RFI logs an error saying:

a duplicate record was found. Delete or modify this record. 300000008913629sun.reflect.GeneratedConstructorAccessor47383.newInstance(Unknown Source)
com.oracle.retail.rfi.common.RFIServerException: Unable to execute Parametric Statement: delete from RFI_SUPP_SITES_STAGE WHERE RFI_SUPP_SITES_STAGE.VENDOR_ID IN (10563)

What this error is saying is that, for some strange reason, RFI is not able to delete the existing record.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Create a new supplier in CFIN
2. Block RFI from furthering the message to RMS
3. Update the same supplier in CFIN
4. Check RFI log


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.