My Oracle Support Banner

GEOCODE Field Being Reset to NULL Upon Editing Contact Info (Doc ID 2032988.1)

Last updated on AUGUST 16, 2018

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.5.0.0.0 to 7.5.0.0.0 [Release 7.5.0]
Information in this document applies to any platform.

Goal

Issue:

The GEOCODE field is being reset to NULL upon editing/saving contact info from Customer Center.  In addition, TAXPKG_TYPE is being set to 0. This issue is consistently happening for all accounts.

Example:

SQL for account before edit:

SELECT ACCOUNT_T.POID_ID0, ANIT.CITY, ANIT.STATE, ANIT.ZIP, ANIT.GEOCODE, ANIT.TAXPKG_TYPE
FROM ACCOUNT_T
INNER JOIN ACCOUNT_NAMEINFO_T ANIT ON ACCOUNT_T.POID_ID0 = ANIT.OBJ_ID0
WHERE ACCOUNT_T.POID_ID0 = 1929340;


The result is:

1929340 Pittsburgh PA 15212 390033040 3


After changing the city to Wexford PA and the zip to 15090, the result is:

1929340 Wexford PA 15090 0


EXPECTED BEHAVIOR
-----------------------
GEOCODE field should not get reset to NULL; instead, it should remain the existing value, e.g 390033040 in the above scenario.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1)  Verify that GEOCODE on  ACCOUNT_NAMEINFO_T has some value
2)  Edit contact info of an account through Customer Center
3)  Notice that contact info is updated correctly but GEOCODE getting reset to NULL, in addition TAXPKG_TYPE is being reset to 0( from original value 3)

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

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