My Oracle Support Banner

Getting Server Error When Click On Billable Charge Link Of Calc Lines Tab In Bill Segment UI (Doc ID 2626299.1)

Last updated on JANUARY 08, 2020

Applies to:

Oracle Financial Services Revenue Management and Billing - Version 2.8.0.0.0 and later
Information in this document applies to any platform.

Symptoms

On : 2.8.0.0.0 version

Select any Bill Segment and go to Calc Lines tab. Then, click on the Billable Charge Id link.
It should take to Billable Charge UI, but it is not loading the billable charge details.
The following error is displayed: "The server has encountered a problem. Your request cannot be processed. Please try again."

In logs the below error is displayed.

SYSUSER - 326646-1096-1 2019-12-06 12:24:37,367 [[ACTIVE] ExecuteThread: '19' for queue: 'weblogic.kernel.Default (self-tuning)'] INFO (api.program.Displayer_Impl) 2019-09-01 User: SYSUSER 12:24:37.36 End : CIPZSELL
SYSUSER - 326646-1096-1 2019-12-06 12:24:37,370 [[ACTIVE] ExecuteThread: '19' for queue: 'weblogic.kernel.Default (self-tuning)'] ERROR (support.context.FrameworkSession) The following Query iterators have not been closed:
SQL: SELECT CHGTYL.CHG_TYPE_CD, CHGTYL.DESCR FROM CI_CHG_TYPE CHGTY, CI_CHG_TYPE_L CHGTYL, CI_SATY_CHGTY S WHERE S.SA_TYPE_CD= ? AND S.CIS_DIVISION = ? AND S.CHG_TYPE_CD=CHGTY.CHG_TYPE_CD AND S.CHG_TYPE_CD=CHGTYL.CHG_TYPE_CD AND CHGTYL.LANGUAGE_CD = ? AND CHGTY.CHG_TYPE_CD > ? ORDER BY CHGTY.CHG_TYPE_CD /* SQL for program 'com.splwg.base.program.sample.b.cht.ProgramCIPBCHTW_Impl', SQL name 'S_FILTER' */


  at com.splwg.shared.common.LoggedException.raised(LoggedException.java:67) [spl-shared-4.3.0.6.0.jar:?]
  at com.splwg.base.support.context.FrameworkSession.assertNoOpenedQueryIterators(FrameworkSession.java:2220) [spl-base-4.3.0.6.0.jar:?]
  at com.splwg.base.support.context.FrameworkSession.assertNoOpenedDBResources(FrameworkSession.java:2327) [spl-base-4.3.0.6.0.jar:?]
  at com.splwg.base.support.context.SessionExecutable.doInReadOnlySession(SessionExecutable.jar

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Go to Menu -> Financial -> Bill Segment -> Search;
2. Search and Select any Bill Segment;
3. Go to Calc Lines Tab and Click on Billable Charge ID link.

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.