My Oracle Support Banner

REL is Failing With ORA-01722 Error (Doc ID 2684898.1)

Last updated on JULY 15, 2020

Applies to:

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

Symptoms

It is observed that Oracle Communication Billing and Revenue Management (BRM) database is not getting updated with the Elastic Charging Engine (ECE) rated records/Event Detail Records (EDRs), where as one is able to see that balance bucket is getting consumed in ECE cache.

For example, for a particular user, Customer Center shows 150 GB is granted and it not yet used. But in ECE cache it shows 140 GB around is available. So 10GB is already used.

Below error is observed in rel.pinlog:


NOTE: event_dyld_ses_telcodata_t is custom table.

Changes

 

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
Changes
Cause
Solution


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