OracleAppsBlog

Tuesday, March 01, 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.

Oracle Software Prices

What is the official list price of all Oracle products?

Oracle posts the list price on their site. Next to the database, application server and tools, you find the price metrics for all the e-Business Suite modules.

For HRMS, these are the prices per person:

• Human Resources: US$50
• Self-Service Human Resources: US$35
• Advanced Benefits: US$40
• iRecruitment: US$50
• Payroll: US$60
• Time and Labor: US$35
• HR Intelligence: US$25

I wonder what the definition of ‘a person’ is in case of iRecruitment. Is it an applicant, is it an employee? And do you need licenses for all contacts of an employee when licensing core HR?