E1: 32: Performance Using Asterisk (*) Wildcard in Configured Item Segments (P3291) (Doc ID 2751169.1)

Last updated on APRIL 23, 2021

Applies to:

Symptoms

In an environment where multiple records (i.e. > 1 million) exist in the Configured Item Segments (F3291) table, when an Asterisk (*) is used in the Skip to Branch/Plant field and filtering on one 2nd Item Number, the system can take more than 2 minutes to find the records. However, if a specific branch is entered in the Skip to Branch/Plant field, the system returns the record immediately.

Steps:
1. Create a configured item in the Item Master and Item Branch (P4101/P41026).
2. In Work with Configured Items (P3291), take the form exit to Segment.
3. Create Configured Item Segments with Branch Plant blank (generic) for the configured item.
4. Re-inquire on Work with Configured Items (P3291, form W3191K). In the Skip to Branch/Plant, enter asterisk (*) and enter the configured item in the 2nd Item Number field.
5. Click on the Find button; in an environment with multiple records in the F3291, the system will take a long time to display the grid records: one for generic Branch/Plant and one for the Branch Plant.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.