My Oracle Support Banner

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

Last updated on JULY 22, 2020

Applies to:

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


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.

SQL Error code 000099997 occurred in module CIPQCAAN:XQ010 SELECT

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

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




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

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