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 184.108.40.206.0 and later
Oracle Communications BRM - Elastic Charging Engine - Version 220.127.116.11.0 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