MSISDN already exists In the User Table, NACK with CCSCD1=ADD while CCSCD1=QRY does not find the user (Doc ID 1953529.1)

Last updated on OCTOBER 18, 2016

Applies to:

Oracle Communications Network Charging and Control - Version 5.0.2 and later
Information in this document applies to any platform.

Symptoms

The problem happens after the CCSCD1=ADD is used to create a new MSISDN (user) on the system (the PROVIDER (Service provider = acs_customer) is necessary). The PI command does not properly complete as it receives a NACK and complains that the "user already exists in the user table", meaning that the user already exists.
When the CCSCD1=QRY is used to verify if the user already exists, it also receives a NACK "Error querying database" because the system cannot find a proper currency for it and complains with "Unknown Currency Id". However, it is clear that the a currency is properly configured for the user PROVIDER.

It is expected that if a user already exists for the PROVIDER, and if a currency is properly configured for that PROVIDER, the user should exist and be recoverable with the CCSCD1=QRY command for that PROVIDER.
It happens with Oracle Network Charging and Control version 5.0.2.

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