NullPointerException Where Retrieving Person Information

(Doc ID 1556328.1)

Last updated on OCTOBER 18, 2016

Applies to:

Oracle Utilities Customer Care and Billing - Version and later
Information in this document applies to any platform.


After upgrading from v2.2 to v2.4 we get NPE in custom code when retrieving
person information.
This is due to the fact that in the CI_PER table state column is empty and
country column is filled and no state exists with such information.

When trying to get CI_PER information in custom java code using HQL we get
NPE (see attached batch logs CMF0ITF1.20130410093309.86.THD1.stdout and


If state and coutry columns are filled in CI_PER accordingly to CI_STATE
entry no NPE is issued.

As workaround, we have removed all calls to getStateId method from our custom
code to avoid issuing NPE.

Could you please let us know what is the explanation of this change of


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