My Oracle Support Banner

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

Last updated on FEBRUARY 03, 2019

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

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
Symptoms
Changes
Cause
Solution
References


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