My Oracle Support Banner

Product and Services Categories: When searched with '%' does Not Show All Available Categories properly (Doc ID 2856420.1)

Last updated on MARCH 17, 2022

Applies to:

Oracle Supplier Lifecycle Management - Version 12.2.7 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.7 version, Supplier Profile Management

ACTUAL BEHAVIOR
---------------
List of categories are not displayed properly when searched with '%' in Supplier > Product and Services Category > Search with '%'
The result is
7
7-01
7-01-001
7-01-002
7-01-003
8
8-02

EXPECTED BEHAVIOR
-----------------------
Product and Service category search on Supplier update should display proper Category combinations completely.
For example:

7-01-001,
7-01-002,
7-01-003,
8-02-001,
8-02-002,
8-03-001,
8-03-002,
8-03-003,
8-03-004

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Go to Supplier Management Administrator > Supplier Home
2. Search supplier and and click on update icon
3. Choose “Product and Services Category” and press “Add”
4. Choose “Search for Specific Product & Service” enter % in Code field and press Go
5. Results does not contain all Categories. It’s shown combinations that contains values in second or third segment only once
For example, we have available combinations 7-01-001, 7-01-002, 7-01-003, 8-02-001, 8-02-002, 8-03-001, 8-03-002, 8-03-003, 8-03-004,
The result is
7
7-01
7-01-001
7-01-002
7-01-003
8
8-02

Changes

 

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
Changes
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.