My Oracle Support Banner

Search For Item List Provides Unexpected Results (Doc ID 2330988.1)

Last updated on APRIL 11, 2022

Applies to:

Oracle Retail Allocation - Version and later
Information in this document applies to any platform.


Problem Description

When searching for an Item List that contains some children of a parent, but not all children of that parent, the Search does not work correctly. For Create Standard Allocation, 'No data to display' is returned. For Create What If Allocation, all of the children are returned. To create the allocation, the user must select individual items as Fashion SKUs or select ALL of the children for that color.

 Steps to Recreate :

Standard Allocation :

1. Create Standard Allocation.
2. Select Advanced Search.
3. Add Item List field.
4. Search for either Item List xxx or yyy.
5. The results say 'No Data to display'.

What If Allocation :

1. Create What If Allocation.
2. Search for Item List.
3. The Parent is returned.
4. Expand the Parent and you will see the second tier showing the colors Black and Brown.
5. Expand the colors to see each individual item is listed as a Fashion SKU. It lists all the children and not just the ones in the Item List.
6. You could select the ones in the item list but that forces you to do a SKU allocation and not a Fashion allocation. Also, it defeats the purpose of using the Item List in the first place.
7. You could select the 2 colors but that selects all of the children and not just the ones in the Item List.
8. Problem is: The entire point of using an Item List is so that you get specific items. The users do not want to select each specific item.


Select items individually. Each item needs to be selected as a Fashion SKU.




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.