A day in the life of an Oracle Applications Consultant

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.

Posted by Richard Byrom on 03/02 at 01:09 AM

Add Comment Information Here

Please note that comments will only be accepted from valid members of this site who provide feedback that is beneficial to readers of the blog. ALL comments (even those from members) will be subject to moderation.


Notify me of follow-up comments?

Submit the word you see below: