The Value Of Checkboxes Cannot Be Written To The Database on Tile Applets in OpenUI application (Doc ID 1925385.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel CRM - Version 8.1.1.11.9 [IP2013] and later
Information in this document applies to any platform.

Symptoms

On : 8.1.1.11 SIA [23030] version, Configuration - General

1. When displaying the records of list applet in Tile format, the field hidden_flg of table (s_asset_xa)need to be displayed in (CheckBox)format on the applet, the specific configuration is as follows:
1) No change on table level, using OTB format CHAR(1 CHAR) default 'N' not null
2) In BC level, Set field hidden_flg as Type = DTYPE_BOOL
3) In Applet level, Set hidden_flg as HTML Type = CheckBox
When unchecking the selected check-box or checking the unchecked check-box, the update data cannot be submitted to database back-end.

If we make the following configuration changes:
1) No change on table level using OTB format CHAR(1 CHAR) default 'N' not null
2) In BC level, Set field hidden_flg as Type = DTYPE_TEXT
3) In Applet level, Set hidden_flg as HTML Type = Text
When we manually modify the data, the data can be synchronized in the database back-end.

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