My Oracle Support Banner

Likeic Operator Does Not Return the Correct Results in Search on Reference Sheet Lines (Doc ID 2518544.1)

Last updated on DECEMBER 04, 2019

Applies to:

Oracle Health Insurance Claims Adjudication - Version 2.17.3.0.0 and later
Information in this document applies to any platform.

Symptoms

On : 2.17.3.0.4 version, Integration Points


The likeic operator only returns the correct results if the search string is present in uppercase characters only.

If there are 2 lines present with a description containing the string HEA (in uppercase) a likeic search on %HEA% or %hea% returns the 2 rows.

If there is 1 line present with a description containing the string HEA (in uppercase) and one containing hea (in lowercase) the same searches return only the row with the uppercase string.

This was detected using the post method on the search url:
{{host}}/api/generic/referencesheetlines/non_base_codes/search

EXPECTED BEHAVIOR
-----------------------
All rows containing the search string, regardless of uppercase or lowercase characters, are expected.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1) Create a reference sheet with a character field.
2) Add data to the reference sheet with the same string in uppercase and in lowercase.
3) Post a search on the reference sheet with the likeic operator on the character field for the common string.

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.