My Oracle Support Banner

SSL Batches Performance Enhancement (Doc ID 2741872.1)

Last updated on JANUARY 08, 2021

Applies to:

Oracle Financial Services Revenue Management and Billing - Version 2.7.0.1.0 and later
Information in this document applies to any platform.

Symptoms

On RMB v2.7.0.1.0, SSL Jobs Performance Enhancement

Need to enhance performance to meet SLA.
A minor change in the query from AND asa.billable_chg_id = bcl.billable_chg_id to AND asa.billable_chg_id = bc.billable_chg_id has improved the performance by almost 30%.

ACTUAL BEHAVIOR
----------------------------
Batch performance issue for specific stop-loss accumulation jobs.
Noticeable long run time for C1-ACSSL job. It takes several hours to complete the batch run.

EXPECTED BEHAVIOR
---------------------------------
Batch performance should be improved to get a better & acceptable completion time.

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.