Query On Multi-org LOV Generates Long IN Clause With Duplicates

(Doc ID 1542988.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel CRM - Version 8.0 SIA [20405] and later
Information in this document applies to any platform.

Symptoms

On : 8.1.1.7 SIA [21238] version, Configuration - General

ACTUAL BEHAVIOR
---------------
When running a query using one of these duplicated values, Siebel is creating an IN clause with all matching LICs. For example:
(T1.X_ROLE_CD IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )

Where every input is the same, e.g.:
Bind variable 4: 4
Bind variable 5: 4
Bind variable 6: 4
Bind variable 7: 4
Bind variable 8: 4
Bind variable 9: 4
Bind variable 10: 4
Bind variable 11: 4
Bind variable 12: 4
Bind variable 13: 4
Bind variable 14: 4
Bind variable 15: 4
Bind variable 16: 4
Bind variable 17: 4
Bind variable 18: 4
Bind variable 19: 4
Bind variable 20: 4
Bind variable 21: 4
Bind variable 22: 4
Bind variable 23: 4
Bind variable 24: 4
Bind variable 25: 4


EXPECTED BEHAVIOR
-----------------------
There should not be 23 bind variables for one variable

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