My Oracle Support Banner

12.1.3 Oracle HTML Quoting Add Products Search No Longer Allows * For Wild Card (Doc ID 1463843.1)

Last updated on SEPTEMBER 01, 2020

Applies to:

Oracle Quoting - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Searching for an item using the wildcard character '*' returns no rows

Expect rows to be returned, since restricting the search criteria to use '7' does return matching results.

Steps to Reproduce
The issue can be reproduced at will with the following steps:

  1. Quote lines
  2. Add product

Changes

  Upgraded database code level.

This works on R12.1.3 if the db version is lower
  For example, internally with RDBMS versions:
     11.2.0.1  - Searching with * is not successful
     11.1.0.7  - Searching with * is successful

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.