My Oracle Support Banner

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

Last updated on DECEMBER 03, 2019

Applies to:

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


General 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, the script fails to complete, with an oracle error output such as:

smf_oper@sms01:/IN/service_packages/CCS/bin> ./ 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 are available in article Doc ID 1273689.1


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
 Problem Description

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