My Oracle Support Banner

Query Timeout Issue During Eligible Accounts/Persons Search On Pricelist Ui (Doc ID 2448388.1)

Last updated on FEBRUARY 03, 2019

Applies to:

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

Symptoms

On : 2.6.0.1.0 version, OTH - Other Bugs

ACTUAL BEHAVIOR
---------------
Query timeout issue during Eligible Accounts/Persons search on pricelist ui


Analysis:
We are able to see all eligible accounts for all divisions except 731. After analyzing logs it seems this is happening because of the huge amount of data involved in the query which is running behind.
 

EXPECTED BEHAVIOR
-----------------------
Query should not timeout.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

• Login with 731 Analyst.
• Navigate to the Pricing Management->Pricelist search.
• Click on Yellow highlighted part from the attached screenshot.
• Please see last screenshot for time out query screenshot.

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.