My Oracle Support Banner

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

Last updated on JANUARY 23, 2019

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.


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

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