My Oracle Support Banner

Item ID Is Not Validated When Creating Like Item (Doc ID 2517908.1)

Last updated on MAY 16, 2022

Applies to:

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


When trying to create a like item, after choosing an item to be created like, RMS shows the front end screen to choose the number type and new Oracle Retail Item Number.
This automatically generates a new number, but if the generated number is replaced with an already used number, then the screen is not validating in the back-end before allowing to continue.
Then, when hit OK button, the Error messages show up:

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

  1. Create an Item (with cost, supplier and retail by zone)
  2. Approve it
  3. Go Manage Item, Search for the item created above
  4. Create Like Item based on previous item created
  5. In the front end Create Like item Screen, Generate a new ID, substitute the generate by one already used.
    Note: The Front end is not validating the ID as it does in other screen (Create Item, Create Children)
  6. Then Hit Ok.

    Additionally, the Front End (Create Like item) is caching the data.
    If fails showing the constraint message, then user actually re-generates a new ID, by hitting the OK is still showing constraint error and that is because is caching the first data of the screen.
    Even all the Attributes Available to Be Copied are cached.


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.