My Oracle Support Banner

Person With 300+ Accounts Encounter System Error In Start/Stop Page (Doc ID 2533800.1)

Last updated on AUGUST 24, 2020

Applies to:

Oracle Utilities Customer Care and Billing - Version 2.5.0.2.0 to 2.6.0.1.0 [Release 2.5 to 2.6]
Information in this document applies to any platform.

Symptoms

On : 2.5.0.2.0 / 2.6.0.1.0 version, ENV - Environment

Person with 300+ accounts encounter System Error in Start/Stop Page
System error is encountered during Start Stop. Person has 300+ accounts and many person contacts. Upon investigation, PER_DATA_AREA clob has 9,999 precision but cannot cater the scenario if there’s a lot of contacts.

ERROR
-----------------------
System Error. Please see logs for more details.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create a person linked to more than one person contact.
2. Link this person to more than one account.
3. Attempt to start a service agreement (SA) for each account. Note how at some point, a system error will be encountered.


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot start/stop person with over 300+account.

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.