Query Timeout with SQL Error 000099997 when Freezing Payment Having 200+ Bill Segments

(Doc ID 2319359.1)

Last updated on OCTOBER 27, 2017

Applies to:

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

Symptoms

On RMB v2.3.0.2 version, PY - Payment:
Query Timed Out when freezing payment with >200 segments.

This payment was sitting as unidentified after the payment was created as part of the base payment upload process. Once the user identified where and how this payment needs to be applied then they processed it.

ERROR
-----------------------
SQL Error code 000099997 occurred in module CIPQCAAN:XQ010 SELECT

STEPS
-----------------------
The issue was reproduced with the following steps:
We do not have detail steps on how all this pay segments were generated but it most likely was done by creating a payment event with many segments and then try to freeze it.
1. Go to payment event and hit the "Freeze" button
2. Query timed out error occurs

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot freeze payment with more than 200 segments.

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms