White Space in Between Two Words Should Not Be Truncated (Doc ID 2249147.1)

Last updated on MARCH 28, 2017

Applies to:

Siebel CRM - Version 8.1.1.8 [23012] and later
Information in this document applies to any platform.

Symptoms

On :  8.1.1.8 [23012] version, System Admin

ACTUAL BEHAVIOR  
---------------
White Space(Double Space) in Between Two Words got Truncated as single space

EXPECTED BEHAVIOR
-----------------------
White Space in Between Two Words Should Not Be Truncated

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Call up on GAP score (1 space between GAP and score)
2. Call up on GAP score (2 spaces between GAP and score)
3. query on Call up on GAP score (2 spaces between GAP and score), without single or double quotes, the record returned is Call up on GAP score (1 space between GAP and score), NOT Call up on GAP score (2 spaces between GAP and score).
Customer would like to have functionality wherein more than 1 white space IN BETWEEN 2 words is NOT truncated/ignored when querying without single/double quotes.


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot do specific action based on position.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms