My Oracle Support Banner

Search Results Are Not Correct When Using Non Dynamic Item Range Catalogs (Doc ID 2242322.1)

Last updated on FEBRUARY 05, 2019

Applies to:

PeopleSoft Enterprise SCM eProcurement - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.


When using non dynamic item ranges items are being returned in the search results that don't exist in the item range.

The issue can be reproduced at will with the following steps:
1.Create a new catalog / Tree with a root node (ALLITEMS) and 1 child node (SUPPLIES).
The ALLITEMS NODE is defined with a dynamic range.
The SUPPLIES Node is defined with an item range.
2.Create a new REQ and click on the catalog link.
3.Next click on the catalog link for TESTING.
4.All items are returned that have a category of “ALLITEMS” or “SUPPLIES”.
This is due to the ALLITEMS node being defined as dynamic.
5.If I only click on the Supplies category then only the items specified in the range are returned. However, if I were to a wildcard search from the search bar again all items from both categories would be returned.
6.Edit the tree and remove the dynamic leaf.
7.ALLITEMS is no longer dynamic.
8.Run the incremental build for Items with Vendors.
Run the incremental build for items without vendors.
9.Test again.
Click on the TESTING catalog link.
Items with category ALLITEMS are still being returned.
This should not happen since ALLITEMS has no item range and is not dynamic.
Item description shows the category as ALLITEMS.
Incremental search does not appear to be working for this scenario!
Run the full load for items with vendors
Run full load for items without vendors.
Test again.
Now only the items from the item range are returned. The full build seems to have worked.

The issue has the following business impact:
Due to this issue, users can see all the items even if it is not in the Item range


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.