My Oracle Support Banner

Query on calculated field with concatenation does not show results (Doc ID 1956565.1)

Last updated on NOVEMBER 22, 2019

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


Customer has 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



Changes

 

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
Changes
Cause
Solution
References


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