My Oracle Support Banner

Getting Error In Supplier Import Attribute Screen While Adding Import Attribute Values (Doc ID 3011093.1)

Last updated on MARCH 18, 2024

Applies to:

Oracle Retail Merchandising System - Version 16.0.3 to 16.0.3 [Release 16.0]
Information in this document applies to any platform.

Symptoms

Getting error in supplier import attribute screen while adding import attribute values

When we want to set up/update the import attributes values like discharge port to 'DOM' for a dummy supplier like '9999999988' from RMS UI screen,



ERROR
-----------------------

We are getting below JAVA error on clicking on save and close and RMS UI screen is not closing.
"A record being inserted is a duplicate of an existing record. Please delete the duplicate record and try again."



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. consider a dummy supplier site like 9999999988 for which we want to set up/update the import attributes from UI screen
2. Open RMS UI screen.
3. Go to Tasks -> Foundation Data -> Suppliers and Partners -> Manage Suppliers
4. Search for the supplier site by providing the value in supplier site 9999999988.
5. Open supplier site and then go to More actions -> Import attributes
6. Provide the data for discharge port as 'DOM' and click on save/save and close
7. You will get the error as "A record being inserted is a duplicate of an existing record. Please delete the duplicate record and try again."
8. If we backend insert the record for the supplier in sup_import_attr table and try to open the RMS UI screen we are getting the below error
  Failed to load value at index 1 with java object of type java.lang.Integer due to java.sql.SQLException.


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, The issue has happened in PROD and has significant impact to business.

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.