My Oracle Support Banner

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

Last updated on SEPTEMBER 12, 2022

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.0.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

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
Goal
Solution
References


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