Account Balance Report is Empty On SMS due to ORA-06502 and ORA-06512 (Doc ID 2054397.1)

Last updated on FEBRUARY 13, 2017

Applies to:

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

Symptoms

In all versions of Oracle Communications Network Charging and Control (NCC), a problem exists when executing the ccsAccountBalanceCSV.sh tool.  The script is failing and generating an empty CSV report due to the following error message:

ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at line 39

It is expected that every day a csv report should be generated that extracts all the Mobile Station International Subscriber Directory Number (MSISDN) for some particular Advanced Control Service (ACS) customers.

Changes

Addition of new Charging Control Services (CCS) Balance Types.

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