My Oracle Support Banner

Item Search For Cross Reference Type W/O Organization Speicifed Returns All Item / Organization Combinations (Doc ID 1361463.1)

Last updated on JUNE 04, 2021

Applies to:

Oracle Item Master - Version 11.5.10.2 and later
Information in this document applies to any platform.
Form:INVIVCSU.FMB - Search Items


Symptoms

Find when conducting a Item Search by Cross Reference AND you do not have an ORG defined as part of the search. The results will show rows for every organization to which the item is assigned.  It will not show every item / organization combination that is associated with the specified cross-reference.

-- Steps
The issue can be reproduced at will with the following steps.
1. Item > Item Search
2. Clear Organization
3. Search by cross-reference type
4. Enter specific cross-reference value
5. Click Find
6. If an item is associated with the cross-reference value for any organization, ALL item / organization combinations will displayed regardless of whether each combination is associated with the cross-reference value.

-- Business Impact
The issue has the following business impact:
Due to this issue, users gets misleading results.

Cause

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
Symptoms
Cause
Solution
References


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