My Oracle Support Banner

Batch C1-PDTXN Taking Longer Time (Doc ID 2878305.1)

Last updated on JUNE 23, 2022

Applies to:

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

Symptoms

On RMB v2.8.0.0.0, C1-PDTXN batch taking longer time.

C1-PDTXN batch is taking 12-15 hours - as records in CI_DISAGG_TXN_PRITM_DETAIL and CI_DISAGG_BCHG_DETAIL table increases, performance of the batch gets affected.
With every disaggregation run, records in this table increases and cause the performance issue.

These records are not actual txns or calculation data and we do not need these records in the table after disaggregation is complete.
Currently whenever records in this table increases (for example, 50 Million), we do cleanup (delete records) of these tables and then batch starts to perform as expected.
We have already tried different chunk sizes but it did not help.

Instead of us doing periodic cleanup to increase the performance, could you please provide us a permanent fix?

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.