My Oracle Support Banner

During Store Creation a Distinct Operation Is Performed on MONTH_DATA Table (Doc ID 2637357.1)

Last updated on FEBRUARY 13, 2020

Applies to:

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


When a user is creating a store, after a store number is inputted, the application validates if the number can be used. It was noticed that a distinct operation is being performed to the MONTH_DATA table. This means that the validation takes a long time and the users get locked out until the operation is finished.

Steps to reproduce:
1. Login and go to the store creation screen.
2. Insert a store number.
3. Notice that Retail Merchandising System (RMS) starts validating the store number.
4. Go to the database and confirm that an RMS session is performing a distinct operation to the MONTH_DATA table.




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.