Custom Field Not Showing Database Value On UI

(Doc ID 2345164.1)

Last updated on JANUARY 03, 2018

Applies to:

Siebel eCommunications - Version 15.18 [IP2015] and later
Information in this document applies to any platform.

Symptoms

On : 15.18 [IP2015] version, Configuration - General

ACTUAL BEHAVIOR
---------------
Custom field not showing database value on UI

We've a custom column created under S_DOC_QUOTE

Physical Type: varchar
Length: 10
Type: Extension

We created a field under Quote BC and mapped it in the UI in Quote List Applet.

Issue: When we navigate to the 'My Quotes' or 'All Quotes' view, even though the quote record have the value present for this custom column in database, it doesn't show in UI.

But if we query any one particular quote#, then we see the value in the UI for this field.
We also noticed that if we mark the field as 'Force Active' then it shows the value always(even when we drill down/navigate to 'My Quotes' or 'All Quotes' view).
 
We are seeing similar behavior with other custom columns as well (same table but displayed in Quote Form Applet).

We also checked the spool of dedicated/thick client and we saw that the custom column was part of 'SELECT ...' statement only when it was force active set to TRUE.

EXPECTED BEHAVIOR
-----------------------
The value of the custom field should be display on the UI.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create a custom column under S_DOC_QUOTE

Physical Type: varchar
Length: 10
Type: Extension

2. Created a field under Quote BC and mapped it in the UI in Quote List Applet.

3. Navigate to the 'My Quotes' or 'All Quotes' view, even though the quote record have the value present for this custom column in database, it doesn't show in UI.


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot see the value from the custom column

Changes

 

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