Patch 14844844 Populates SRCH_CHAR_VAL For New Rows, How To Populate Existing Rows? (Doc ID 1968063.1)

Last updated on APRIL 25, 2017

Applies to:

Oracle Utilities Customer Care and Billing - Version 2.3.1 to 2.4.0.2.0 [Release 2.3 to 2.4]
Oracle Utilities Framework - Version 2.2.0 to 4.2.0.2.0 [Release 2.2 to 4.2]
Information in this document applies to any platform.

Goal

The table SC_USER_CHAR has an index on the field SRCH_CHAR_VAL but this field is not populated.
The following statement returns no rows:
SELECT * FROM SC_USER_CHAR where SRCH_CHAR_VAL <> ' '

 This KM article explains how to populate the SRCH_CHAR_VAL field on CI_xxx_CHAR tables.


 

Solution

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