"ORA-01722: invalid number" Error is Generated when Creating a New Calling Card Subscriber (Doc ID 1332440.1)

Last updated on SEPTEMBER 16, 2016

Applies to:

Oracle Communications Network Charging and Control - Version: 2.2.0 and later   [Release: 2.2 and later ]
Information in this document applies to any platform.

Symptoms

General

ccsAccountWithPrivacy.sh is the ccsAccount tool which have following functions:

- Set the initial wallet state to a configurable value, when creating new Calling Card subscribers. i.e. to something like "Frozen"
- Add a new command line option to allow specified serial number ranges, to have their state changed. i.e. to "Active" or "Pre-use"

Problem Description

When attempting to create new Calling Card Subscriber through usage of ccsAccountWithPrivacy.sh, the script fails to complete, with an oracle error output such as:

smf_oper@sms01:/IN/service_packages/CCS/bin> ./ccsAccountWithPrivacy.sh GPG-Key Test -s 207000000000 -e 207000020000 -c "Currency" -n 5000 -C 5 -t "CallingCard" -d -B 1 -u -w frozen

Jun 22 07:37:04.537309 ccsAccount(10772) NOTICE: Number of accounts pre-allocated at a time=100
Jun 22 07:37:05.761500 ccsAccount(10772) ERROR: An Oracle error ocurred that the program did not expect:
Jun 22 07:37:05.761774 ccsAccount(10772) ERROR: SQL error code -1722 at ccsAccountSQL.pcc:52
Jun 22 07:37:05.761920 ccsAccount(10772) ERROR: SQL error: ORA-01722: invalid number
Jun 22 07:37:05.762076 ccsAccount(10772) ERROR: SQL statement: select count(*) into :b0 from ccs_acct_reference where (to_number(account_number)>=to_number(:b1) and to_number(account_number)<to_number(:b2))
Jun 22 07:37:05.762224 ccsAccount(10772) ERROR: Aborting program


Complete descriptions about what is Calling Card and how to used ccsAccountWithPrivacy.sh are available in article Doc ID 1273689.1

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