Oracle Application Development Services

FAQ's about Oracle Application

Q. How do I set up an Oracle Account for a new user?

A. You need to have your department supervisor contact the help desk at 448-2222 and request an Oracle account.

Q. What do I do When I press Page Down or Page Up on an Oracle Web Form and get this error? " FRM-41009 Function key not allowed..."

A. Most likely a Query has been opened, but has not been executed or closed. Most function keys, such as Page up/Page down , are diabled while a Query is open. Click "OK" to the Alert. Then press the F4 key

Q. Are there any tips you can give when entering a Query?

A. When entering a query, use the wildcard '%' symbol to pull all "like" information. Example: To do a query for the last name of NELSON, enter NEL%. This will return NELSON, NELS, NELL, . . . Entering %SON, will return NELSON, ROBINSON, JOHNSON, . .

A. When the "Enter Query" button is pressed, the form will automatically be cleared and the new query data will be retrieved. There is no need to clear the form before entering different filter criteria.

Q. What is Oracle?

A. Oracle is the name of the Relational Database Management System we currently use as well as the company who developed it.

Q. What is a Relational Database Management System?

A. A type of database management system (DBMS) that stores data in the form of related tables. Relational databases are powerful because they require few assumptions about how data is related or how it will be extracted from the database. As a result, the same database can be viewed in many different ways.

Q. How do you minimize a window in Netscape/Explorer?

A. At the top right corner of your browser you will see three small buttons. The first has a dash, the second looks like two small overlapping boxes and the third has an X. To minimize the window move your mouse over to the box with the dash. When the arrow is on this box, click the left mouse button. This will cause the window to minimize so that it does not obscure any other windows currently open. You can still be access the minimized window from the toolbar at the bottom of your screen.

Q. How do I use the new menu search option?

A. In the upper right corner of your main menu is an input box with a gray search button to its immediate right. Place your mouse over the input box and left click so that your cursor appears inside the box. Then you can type in a keyword or keywords that you wish to find. After entering your search string move your mouse to the gray search button and left click. Your matches will appear below. Be careful when entering multiple words! The search engine will pull every occurrence of each word you type into the input box. You could get a long list of options.

Q. Would more memory on my PC improve performance?

A. You can open and minimize as many Oracle screens as your PC's memory will allow. The more memory you have on your PC, the more screens you will be able to open without noticing a slowdown on your PC. It is recommended that you keep only the screens that you will use most often minimized on your PC. Please note that once you have a screen minimized you can not open it up again through your main menu. A message saying "loading form …." will appear and nothing will happen.

Q. How many Oracle screens can I have opened and minimized at one time?

A. More memory on your workstation will improve your overall performance. Your forms will load faster and you can keep more items minimized while working, but your reports will not run any faster. The speed of your reports depends on the load on the server at the time you send your report. If the server is not busy, your report will run faster.

Q. How can I tell what versions of Netscape, J-initiator, and Adobe Acrobat I have on my PC?

A. To find out which version of Netscape you are running, first open up Netscape just like you normally would to access your Oracle applications. Along the very top toolbar you will see the options "File", "Edit", "View", "Go", "Communicator", and "Help". Move your mouse over the text, "Help", and left click. A list of options should appear then appear below the text, "Help". Move your mouse down the list until you have highlighted the option, "About Communicator". This should be the last option on the list. Left-click this option. A page should appear telling you what version of Netscape you are currently using. To find out what version of Oracle J-Initiator or Adobe Acrobat Reader you are using first click the "Start" button on the bottom left corner of your desktop. A list of items will appear directly above. Move your mouse cursor up until you have highlighted "Settings". A list of items will appear directly to the right of "Settings". Move your mouse cursor over and highlight the option, "Control Panel". Left-click on "Control Panel" and a screen will appear with several icons or a list of options from which to choose. Double-click on the item called "Add/Remove Programs". A box should appear with a list of all your programs in the center. Scroll down the list until you see Adobe Acrobat or Oracle J-Initiator. You should see a version number listed along with these items. You may have more than one version on your computer. It is most likely you are using the version with the highest version number listed. Do not make any changes here, simply exit by clicking on "Cancel" or by clicking the "X" in the top-right corner of the box.





	Copyright ©2003 The University of Tennessee Health Science Center · Memphis, Tennessee 38163 · Telephone 901-448-5848