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 [IP2013] and later
Information in this document applies to any platform.


On : [IP2013] version, Configuration - General

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




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

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