Item Number Type Prefix Field On Add Children Does Not Filter Correctly
(Doc ID 2706446.1)
Last updated on SEPTEMBER 02, 2020
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:
- Create a new SKU.
- Select [Create Children] to open the Item Children screen.
- Select to Add.
- Select Variable Weight PLU for the new child.
- Select a PLU format.
- Observe the list of values in the Prefix dropdown.
- 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