My Oracle Support Banner

In iStore Flexfields, the % (Percent) Sign Is Converted Into A Hex Value Once Searching (Doc ID 2727110.1)

Last updated on FEBRUARY 11, 2021

Applies to:

Oracle iStore - Version 12.2.8 and later
Information in this document applies to any platform.
wildcard
wildcard search

Symptoms

ACTUAL BEHAVIOR
---------------
When searching for a value in the iStore flexfields, the % sign (percent sign) is converted into its HEX value once searching.

EXPECTED BEHAVIOR
-----------------------
Expect the search string to not be modified.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Open a flexfield, click on the search icon (flashlight)
2. Enter any value with %, click search then Cancel
3. Notice that % is converted into its hex value

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot search with wildcard.

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.