Query On Calculated Field Returns All Caps (Doc ID 2759732.1)

Last updated on MARCH 16, 2021

Applies to:

Symptoms

Query on calculated field in Siebel 20.9 returns all caps when calculated expression have an field with Force Case set to UPPER


STEPS
-----------------------
1) The issue can be reproduced at will with the following steps:

-Tools>Create Workspace>Contact BC
-Field: Full Name
-Add Calculated Value: [Last Name] + [First Name] + " " + [M/M]
-For Field: Last Name, Set Force Case Attribute to: Upper
-Deliver

-Login to Client
-Contact List Applet
-Query on Full Name Column
-Value is displayed in UPPER Case for last name like:

ADMINITRATORSiebel

2) Custom Scenario:

In "Order Entry - Orders" BC have a custom calculated field "DB BahnCard Character" with expression:

IIF([DB Card Type]="BC25" OR [DB Card Type]="BC50",IIF([DB Product Code]="BUS","BahnCardBusiness","BahnCard"),IIF([DB Card Type]="BC100","BahnCard100","BahnCard"))

Force Case is set to UPPER for DB Product Code field.

In custom workflow, which queries "Order Entry - Orders" BC (worfklow operation step) and uses "DB BahnCard Character" field as an output.

Changes

Cause

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