My Oracle Support Banner

Query Timeout with SQL Error 000099997 when Freezing Payment Having 200+ Bill Segments (Doc ID 2319359.1)

Last updated on SEPTEMBER 27, 2024

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

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
Changes
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.