My Oracle Support Banner

Diff ID's And Diff Types are in Initcaps When Created Using Data Load Scripts (Doc ID 2618131.1)

Last updated on DECEMBER 13, 2019

Applies to:

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


While migrating Diff Id's and Diff Types from legacy systems , it is created in Initcap.

Whereas creating the  Diff ID's and Diff Types by item induction or GUI screen ,it created in uppercase.

Steps to recreate

  1. Create new Diff ID’s and Diff Types in RMS using Data load scripts to be migrated from legacy system(Data reflected -Diff Id: Aqua1 and Diff Type: Size1).
  2. Verify Diff ID and Diff Types in RMS Database (Data reflected in database: Diff id: AQUA1 and Diff Type: SIZE1).
  3. Verify Diff ID and Diff Types in RMS UI by downloading the spreadsheet (Data reflected : Diff id: AQUA1 and Diff Type: SIZE1).
  4. Because of this mismatch, users are not able to update the values of Diff_ids and Diff_Types in GUI screen or via induction.




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.