My Oracle Support Banner

Performance Issue For Payment Related To Suspense Account (Doc ID 2407477.1)

Last updated on JUNE 15, 2018

Applies to:

Oracle Utilities Customer Care and Billing - Version 2.4.0.3.0 and later
Information in this document applies to any platform.

Goal

On : 2.4.0.3.0 version, ENV - Environment

Performance Issue For Payment Related To Suspense Account

CC&B has trouble loading for Payment related to suspense account.

The following loading time is encountered:
Loading Account in Control Central = 6mins 11seconds
Loading for Suspense Account = 30 seconds
Loading for Suspense Service Agreement = 22 seconds
Go To Payment = 41 seconds
Choosing Payment = 42 seconds

The Financial Transaction for the suspense account is now at 294,272 records

The system shows a SQL type error and it doesn't allow them see the information
of the account.

Can recommend a fix to improve the performance for Payment related functionalities in CC&B?

Solution

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
Goal
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.