My Oracle Support Banner

Like Item Functionality Doesn't Capture 'Created User' Information (Doc ID 2730400.1)

Last updated on DECEMBER 07, 2020

Applies to:

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


Like item functionality doesn't capture 'Created User' information correctly.It is observed that when the 'Create Like Item' functionality is used and locations are copied, the Create_ID on all itemrelated tables are not capturing the User ID .The Create_id column is capturing the RMS Async User ID (RMS16)/DB  instead of the user who created the Item.

Steps to Recreate:

  1. Choose an item eg: item1. Check ITEM_LOC.create_id='xxxxx' ( This is the user used to log into RMS UI). 
  2. Using Create Like Item' functionality create an item from the above selected item.
  3. Check ITEM_LOC.CREATE_ID='YYYYY' ( this is the user id of the RMS db). In all item related tables, CREATE_ID populated as 'YYYYY' only. (i.e DB user but not Application user).


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.