My Oracle Support Banner

Column 'SRCH_CHAR_VAL' Goes Blank On 'D1_SP_CHAR' Table When Servicepoint Char Is Edited From C2M (Doc ID 2622740.1)

Last updated on DECEMBER 23, 2019

Applies to:

Oracle Utilities Customer to Meter Base - Version 2.7.0.1.0 to 2.7.0.1.0 [Release 2.7]
Information in this document applies to any platform.

Symptoms

On :C2M 2.7.0.1.0 version, Framework

ACTUAL BEHAVIOR
---------------
Column 'SRCH_CHAR_VAL' goes Blank on 'D1_SP_CHAR' table when Servicepoint char is edited from C2M


EXPECTED BEHAVIOR
-----------------------
Column 'SRCH_CHAR_VAL' is not Blank on 'D1_SP_CHAR' table when Servicepoint char is edited from C2M


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Search for a ServicePoint with a Service Point Characteristic present on it.
2. All the characteristics present on Service Point has the field 'Allow Search By Char Val' marked as 'Allowed'
3. Database Snapshot of D1_SP_CHAR Table. (Column SRCH_CHAR_VAL populated as expected)
4. On the Service Point Characteristics Zone, Click on Edit Button. (SP Char maintenance screen is displayed)
5. Change the Value of one of the Characteristics listed ans save. (Value appears as updated in the SP Char screen)
6. Query the Database Table D1_SP_CHAR with selected Service Point id. (All values in Column SRCH_CHAR_VAL for the said Service Point is now Blank )

Changes

 

Cause

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
Symptoms
Changes
Cause
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.