MSISDN already exists In the User Table, NACK with CCSCD1=ADD while CCSCD1=QRY does not find the user
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.
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.
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