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:

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

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