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 18.104.22.168.0 [Release 2.3 to 2.4]
Oracle Utilities Framework - Version 2.2.0 to 22.214.171.124.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.
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