Patch 14844844 Populates SRCH_CHAR_VAL For New Rows, How To Populate Existing Rows?
Last updated on APRIL 25, 2017
Applies to:Oracle Utilities Customer Care and Billing - Version 2.3.1 to 220.127.116.11.0 [Release 2.3 to 2.4]
Oracle Utilities Framework - Version 2.2.0 to 18.104.22.168.0 [Release 2.2 to 4.2]
Information in this document applies to any platform.
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.
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