My Oracle Support Banner

Item Number Type Prefix Field On Add Children Does Not Filter Correctly (Doc ID 2706446.1)

Last updated on AUGUST 25, 2022

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version 19.0 and later
Information in this document applies to any platform.


Item Number Type Prefix Field on Add Children Does Not Filter Correctly. On the Add SKU pop-up on the Item Children screen, if the item number type is Variable Weight PLU, then the Prefix field is expected to list only the prefixes from code_detail where code_type = 'PREF' and used_ind = 'Y'. (Compare with the behaviour of the same field on the Create Item pop-up launched from the main Items menu.

Steps to Recreate:

  1. Create a new SKU.
  2. Select [Create Children] to open the Item Children screen.
  3. Select to Add.
  4. Select Variable Weight PLU for the new child.
  5. Select a PLU format.
  6. Observe the list of values in the Prefix dropdown.
  7. Compare the list of values with the results of this query: select * from code_detail where code_type = 'PREF'.



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.