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 FEBRUARY 27, 2024

Applies to:

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.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.