ORA-01455 Overflow Error While Loading Data on BRM Tables (Doc ID 1075092.1)

Last updated on SEPTEMBER 19, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.3.1.0.1 and later
Information in this document applies to any platform.
Checked for relevance on 10-Feb-2012.


Symptoms

While running a custom process, the following failure was met:

E Mon Mar 01 09:35:51 2010  xxxxx  dm:22700  dm_subr.c(112):7728 1:itxsa03d:publish_bill_to_sap:11788:1:7:1267432551:9
       ORACLE error: do_sql_mr_select: PINStmtExecute: code 1455, op 0
       =ORA-01455: converting column overflows integer datatype


The error was returned while trying to load this value for one of the records: 2237092984. This value is the result of a summation over several CDR records of the DURATION value.

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