My Oracle Support Banner

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

Last updated on FEBRUARY 28, 2018

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

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


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.