ECE PublicUserIdentity Is Not in Sync with BRM Service Alias (Doc ID 3067686.1)

Last updated on FEBRUARY 12, 2025

Applies to:

Goal

On a customer production system it was found that PublicUserIdentity (PUI) cache in Elastic Charging Engine (ECE) is not in sync with corresponding Service alias entries in  Billing and Revenue Management (BRM). 

For example:

From BRM database:

       select count(*) from service_alias_list_t sa, service_t s where s.poid_id0=sa.obj_id0 and s.account_obj_id0=16387974;

       30242

From ECE cache:

       select count() from PublicUserIdentity where value().internalIdentities like '%16387974%';
       Results
       21701

See that 30242 is not equal to 21701, that means there are more entries in BRM than in ECE. Because of this, rating is failing in ECE for the missing PUI numbers.

Even after trying to perform incremental load of the customer it did not load all the PUIs.

How can one synchronize these? 

Solution

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