The GEOCODE Field Is Being Reset To NULL Upon Editing Contact Info (Doc ID 2032988.1)

Last updated on AUGUST 17, 2015

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;


--Results--
1929340 Pittsburgh PA 15212 390033040 3

After changing the city to Wexford PA and the zip to 15090 the results are:
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

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