State Id In Device_t Table Is Not Imported Properly

(Doc ID 880548.1)

Last updated on SEPTEMBER 15, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version: 7.3.1.0.0
This problem can occur on any platform.

Symptoms

As part of Migration using cmt utility for legacy data, it is migrating data related to device_t, device_sim_t and device_num_t tables.The state_id in device_t table for MDN & RUIMS has to pick the value from input XML.The value as 1,2 & 3 for MDN(device_num_t) is defined.

But it is found that for any given value in input XML the value that is getting inserted is 2 for state_id. The similar issue is occuring for RUIM(device_sim_t) where state_id is getting set to 5 irrespective of value present in input XML for state id.



Cause

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