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

Last updated on DECEMBER 13, 2022

Applies to:

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

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