RatedEventInRerating Cache Is Not Getting Consumed (Doc ID 2975761.1)

Last updated on SEPTEMBER 25, 2023

Applies to:

Symptoms

ACTUAL BEHAVIOR
---------------

Rerating is completed and no accounts are in status IN_RERATING, but still this cache is not getting reduced and there is no usage for these accounts.

There are 82k events in RatedEventInRerating
CohQL> select count() from RatedEventInRerating;
Results
82780

EXPECTED BEHAVIOR
-----------------------
Cache should be cleared after re-rating is completed.

STEPS
-----------------------

Customer had run rerating for this account 1-2 months back, and noticed now that the account status is still IN_RERATING.
Customer ran -queue & -recycle jobs but still same. Then incrementally loaded the account again to ECE which changed the status to NOT_IN_RERATING.

1. expected after changing the status RatedEventInRerating cache will get consumed and files will be written, but it didn't happen.
2. tried restart of brmgateway & ratedeventformatter also but still same.
3. also tried rollingupgrade but no result.

Changes

Cause

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