My Oracle Support Banner

Issue When Calculating The Recommended Budget Amount (Doc ID 2641978.1)

Last updated on FEBRUARY 27, 2020

Applies to:

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

Goal

On : 2.6.0.1.0 version, ENV - Environment

When a read-only custom XAI Inbound Service is invoked to retrieve Person Account information, it invokes a base method (recommendBudgetAmount) from the Account object then it got an error response.

The error stemmed from a query iterator that is not closed. The root cause of this is the attempt to update some records even if the nature of the service request is just read-only. Upon checking the logs, the Account has an active Wastewater service that has insufficient Billing History. Because of that, it tries to calculate the suggested budget using Premise history and customer trends (ProgramCIPGCBAX_Impl). Once the estimate has been made, it then calls the rate application so it can generate the bill amount which will then be the basis for the budget amount. During rate application (ProgramCIPRRTAN), it invokes all the SQ Rules. One of the custom SQ Rules (CmWasteWaterAverageServiceQuantityRuleComp_Impl) performs an add/update to SA Characteristics. This causes the error “Unable to issue an updating SQL in a read-only session.

Why does this error occur?
 

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.