My Oracle Support Banner

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

Last updated on SEPTEMBER 20, 2022

Applies to:

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


On : / 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.

System Error. Please see logs for more details.

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.

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


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

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