Wednesday, March 02, 2005

Enabling the Cancel Query option

This post discusses the profile option which controls access to concurrent requests used to view reports.

In organisations where there are a large number of transactions or where for some reason the system tends to run slowly, entering and executing an inappropriate query within your Oracle Application can be rather annoying and time consuming. This simple trick provides you with the ability to cancel a query after you have executed it.

By setting the FND: Enable Cancel Query profile option to yes, you will cause the button displayed below to appear every time you execute a query.

To cancel a query (in instances where it is taking too long to run or where you entered the wrong query) simply press the button.