ORA-01455 Overflow Error While Loading Data on BRM Tables

(Doc ID 1075092.1)

Last updated on APRIL 16, 2018

Applies to:

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


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.


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