IP 16 PS 15 Numeric Calculated Fields Defined As DTYPE_TEXT Causes Invalid search specification error

(Doc ID 2318606.1)

Last updated on OCTOBER 17, 2017

Applies to:

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

Symptoms

On :  16.15 [IP2016] version, Client Functionality

Numeric Calculated Fields Defined As DTYPE_TEXT caused the below errors in the log:

ERRORS:

----------------------------------------
SBL-DAT-00493: Text constant (2) needs to be enclosed in single quotes.
SBL-DAT-00501: Invalid search specification 'IIF (([abc Dscl Calc1] > 2), "Y", "N")'.
SBL-DAT-00501: Invalid search specification '<?>'


STEPS
----------------------------------------
The issue can be reproduced at will with the following steps:
1) Created two fields in a buscomp for example  the Contact buscomp:
a.Name = abc Dscl Calc1
Calcuated Value = 5
Type = DTYPE_TEXT
Force Active = True

b. Name = abc Dscl Calc2
Calcuated Value = IIF (([abc Dscl Calc1] > 2), "Y", "N")
Type = DTYPE_TEXT
Force Active = True

2) Go to any view based on the above buscomp. For this example: Visible Contact List View


3) The below error is displayed on the UI:
Invalid search specification '<?>' (SBL-DAT-00501) 

The below errors are generated in the log:
SBL-DAT-00493: Text constant (2) needs to be enclosed in single quotes.
SBL-DAT-00501: Invalid search specification 'IIF (([abc Dscl Calc1] > 2), "Y", "N")'.
SBL-DAT-00501: Invalid search specification '<?>'


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, numeric calculated fields won't function properly.

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