My Oracle Support Banner

Problem with Pick Applet when Long Running Query is Cancelled On Pick Applet (Doc ID 2171131.1)

Last updated on APRIL 02, 2019

Applies to:

Siebel CRM - Version [IP2014] and later
Information in this document applies to any platform.




When cancel query timeout feature is enabled and a Picklist query running for longer than the timeout interval is executed, this query does not return any


If for example a query runs 5 seconds to return results and the cancel query timeout is set to 3 seconds, then this query is dropped. No results are

returned and the Picklist applet is being silently closed.

1. As an example, a picklist query runs 5 seconds to return results.

2. The CancelQuery timeout is set to 3 seconds.

3. After 3 seconds the CancelQuery popup appears, this tells the user the query is taking a long time and whether they wish to cancel the query by

hitting the Cancel button. (There is only one button on the popup and that is


4. User ignores the message and DOES NOT cancel the query.

5. The query is dropped. No results are returned and the Picklist applet is

silently closed.


1) Ensure that CancelQueryTimeout is set to low value, say 1s.

2) Navigate to Sales Order View

3) Create New Order

4) Add new Line Item to the order

5) Open artilce Picklist

6) Perform Query on the picklist

7) If the query is long running then Cancel Query Popup is shown. Once Query is over the control returns to article field from where Picklist was invoked and picklist applet disappears

8) If we try the picklist again and request on picklist then the applications shows popup as below.

9) This popup cannot be closed and only option left is to refresh the screen

10) This issue only happens in Pick applets in regular list applets in view issue is not observed.



If the user ignores the CancelQuery popup the picklist query should continue and complete successfully.The above behavior was observed in IP2014, PS18.Such behavior was not observed in IP2014, PS13.


If there are changes in the environment, product, account and hardware that trigger the problem describe them.


Explain what caused the issue.

This was identified as a product defect and <BUG 24443180> - PICK APPLET DISAPPEARS WHEN CANCEL QUERY IS ENABLED

was raised to address this issue.






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.