My Oracle Support Banner

Data Upload Status Shown as 'Processing Successfully' While Uploading Any Template With Duplicate Records (Doc ID 2432833.1)

Last updated on AUGUST 25, 2022

Applies to:

Oracle Retail Merchandising System - Version 16.0.1 and later
Information in this document applies to any platform.


When user trying to upload consecutive duplicate records using base and custom template loader in RMS (Retail Merchandising System), upload status is showing as "Processed Successfully" instead of "Processed with errors". However when trying to upload non-consecutive duplicate records, correct status "Processed with Errors" is encountered, saying that some records are duplicates. But application should throw error as 'Duplicate records' for non consecutive codes.

Steps to Reproduce:

1. Log in to RMS .
2. Navigation, Tasks > Foundation Data > Data Loading > Upload Data.
3. Upload Codes and Description file.
      Template Type: Administration
      Template: Codes and Description
4. Observe the above error.

Note: In excel that’s a limitation that if consecutive records are duplicate , system shows processed successfully but one record would get successfully inserted. The process will error out only when duplicates are present in Non-Consecutive Rows.


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

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