Query on calculated field with concatenated does not show result. (Doc ID 1956565.1)

Last updated on MARCH 02, 2017

Applies to:

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

Symptoms

On : 8.1.1.11.13 [IP2013] version, Configuration - General

ACTUAL BEHAVIOR
---------------
Siebel Sales Disconnected Mobile Client - wrong query result by calc fields


we have an issue with the Siebel Sales Disconnected Mobile Client.

In some applets (list and form applets - it doesn't matter) we have raised our custom fields and end users would like to query these fields.
Typical use case: we have a calculated field that concatenates business address fields. This custom field is showed in the 'Account List Applet' at the 'SHCE Account List View - Mobile'.

The problem there is: if we query on concatenated calculated field  the result is wrong.


Reproduced STEPS in the vanilla application
----------------------------------------------------------
The issue can be reproduced at will with the following steps:

1) On the Contact BC
  I changed First Name Last Name field with not mandatory field such as M/M field.

  First Name Last Name Calculated Value [M/M] + " " + [Last Name]

2) Exposed above field in the contact list applet

3) Some M/M field NULL


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Query on calculated field with concatenated does not show result.

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