How To Fix Null Value In Susp_usage_telco_info_t.Obj_id0 and Event_t.Poid_id0? (Doc ID 1249184.1)

Last updated on MARCH 29, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.3.0.0.0 and later
Information in this document applies to any platform.
*** Checked for relevance on 03-29-2016 ***

Goal

We have found poid_id0 in table event_t  with value NULL.
Poid_type is ‘/event/delayed/session/telco/gsm’
Session_obj_id0 is ‘/batch/rel’

We also found in susp_usage_telco_info_t .obj_id0 NULL values:

select count(*) from susp_usage_telco_info_t where obj_id0 is null  

returns 1450.

There are also obj_id0 filled with value , but they do not reference to a line in suspended_usage_t .
In this case, also other columns are filled with wrong values.

Note: All values are provided by pin_rel.

Please let us know, how to fix missing values in susp_usage_telco_info_t.obj_id0 and
event_t.poid_id0


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