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 02, 2020

Applies to:

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

Symptoms

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.

 

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
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.