IP 16 PS 15 Numeric Calculated Fields Defined As DTYPE_TEXT Causes Invalid search specification error (Doc ID 2318606.1)

Last updated on FEBRUARY 14, 2022

Applies to:

Symptoms

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

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 '<?>' 

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.