My Oracle Support Banner

Rated Event Loader Is Throwing ORA-0001 Error While Loading Rated Output From Rated Event Formatter (Doc ID 2624429.1)

Last updated on JANUARY 17, 2023

Applies to:

Oracle Communications Billing and Revenue Management - Version and later
Oracle Communications BRM - Elastic Charging Engine - Version and later
Information in this document applies to any platform.


In a setup with ECE (Elastic Charging Engine) and BRM (Billing and Revenue Management), while loading the rated CDR (call detail record) by Rated Event Loader (REL), the RE loader is throwing an "ORA-00001: unique constraint:" error and the same is seen in the .blk file in the rejected archives folder.

ORA-0001 error in SQL Loader is coming because the POID_ID0 value sent from ECE  already exists in the BRM database. This could be possible when ECE had already sent the same POID_ID0 value in another rated out file. When the CDR is reprocessed, the same CDR goes through fine.



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.