A day in the life of an Oracle Applications Consultant

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.

The Cancel Query button in Oracle Applications

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.