Navigation

Tags:

documentation2 forms2 create new tag

Quick Reference For Forms Naviagation

The following is information about navigating in the professional interface forms. Many of the function keys and control keystrokes originated in the pre-GUI days of SQL*Forms version 2.3. They still work, can save lots of data entry time, and may improve accuracy.

The Menu and Toolbar

The icons (from left to right)

1. New Record
2. Find Window
3. Navigator
4. Save
5. Next Process Step
6. Print Screen
7. Close Form
8. Cut
9. Copy
10. Paste
11. Clear Record
12. Delete Record
13. Edit Field
14. Custom Zoom
15. Translations
16. Attachments
17. Folder Tools
18. Window Help

Menus

• File
  • New
  • Open
  • Save
  • Save and Proceed
  • Next Step
  • Export
  • Place on Navigator
  • Log on as a Different User
  • Switch Responsibility
  • Print
  • Close Form
  • Exit Oracle Applications
• Edit
  • Undo Typing
  • Cut
  • Copy
  • Paste
  • Duplicate
    • Duplicate Record Above
    • Duplicate Field Above
  • Clear
    • Clear Record
    • Clear Field
    • Clear Block
    • Clear Form
  • Delete
  • Select All
  • Deselect All
  • Edit Field
  • Preferences
    • Change Password
    • Set Profile Options
• View
  • Show Navigator
  • Zoom
  • Find
  • Find All
  • Query By Example
    • Enter Query
    • Run Query
    • Cancel Query
    • Show Last Query Criteria
    • Count Matching Records
  • Record
    • First
    • Last
  • Translations
  • Attachments
  • Summary/Detail
  • Requests (Concurrent)
• Folder
  • New
  • Open
  • Save
  • Save As
  • Delete
  • Show Field
  • Hide Field
  • Move Right
  • Move Left
  • Move Up
  • Move Down
  • Widen Field
  • Shrink Field
  • Change Prompt
  • Autosize All
  • Sort Data
  • View Query
  • Reset Query
  • Folder Tools
• Tools The Tools Menu is Variable. In addition to these variations, the Tools Menu can change depending on the application module.
  • Tools When On Navigator
    • Expand
    • Collapse
    • Expand Branch
    • Expand All
    • Collapse All
    • Add to List
    • Remove from List
    • Function List
    • Top Ten List
    • Close Other Forms
  • Tools When View Output or View Log
    • Copy File
  • Tools When View Requests
    • Managers
    • Reprint
• Window
  • Cascade
  • Tile Horizontally
  • Tile Vertically
  • 1 (title of open window)
  • 2 (title of open window)
  • 3 (title of open window) etc.
• Help
  • Window Help
  • Oracle Applications Library
  • Keyboard Help
  • Diagnostics
    • Display Database Error
    • Examine
    • Logging
      • Preferences
      • View
    • Test Web Agent
    • Trace
    • Debug
    • Properties
      • Item
      • Folder
    • Custom Code
      • Normal
      • Off
    • Client System Analyzer
  • Record History
  • About Oracle Applications
• Right Mouse
  • Cut
  • Copy
  • Paste
  • Folder
    • Show Field
    • Hide Field
    • Move Right
    • Move Left
    • Move Up
    • Move Down
    • Widen Field
    • Shrink Field
    • Change Prompt
  • Help

Function Keys and Control Key Combinations

These keystrokes can keep your hands on the keyboard and save many mouse clicks by executing a complex menu choice in a single stroke!

Log Off	F4		Cut, Copy, and Paste Functions
Enter and Save Records			Cut	Ctrl x
Insert Record in Form	Ctrl		Copy	Ctrl c
Save to Database	Ctrl s		Paste	Ctrl v
			Duplicate Field Above	Shift F5
Clear Functions			Duplicate Record Above	Shift F6
Clear Field	F5
Clear Record	F6		Delete Functions
Clear Block	F7		Delete Character	Backspace
Clear Form	F8		Delete Field	Delete
			Delete Record and Save	Ctrl , Ctrl s
Select and Deselect Records
Select One Record	Ctrl - click		Cursor Movement
Select Group	Shift and click first and last		Move/Scroll Right
			Move/Scroll Left
Open/Close Lists and Windows			Next Field	Tab
List of Values (LOV)	Ctrl L		Previous Field	Shift Tab
Open Calendar Popup	Ctrl L		Beginning of Field	Home
List Tabs	F2		Ending of Field	End
List Poplist Choices	Alt		Next Record
Display Entire Field	Ctrl e		Previous Record
Cancel Popup	Esc		Next Block	Shift Page Down
Close Window	Ctrl F4		Previous Block	Shift Page Up
Close Form	F4		Next Set of Records	Page Down
			Previous Set of Records	Page Up
Query Functions			Execute Buttons and Boxes
Enter Query Mode	F11		Highlighted Button	Enter
Display Last Query	F11 again		Other Button or Option	Alt + Underlined Letter
Fields to Query	% is Wild Card		Check Box	Space Bar
Execute Query	Ctrl F11
Count Matching Records	F11, Query, F12		On-Line Help
Cancel Query Mode	F4		Keyboard	Ctrl k
Next Set of Records	Page Down		Help	Ctrl h
Previous Set of Records	Page Up		Error	Shift Ctrl e

Things to Try if the Form Won't Cooperate

• If the form insists that a field must be entered, try to clear the record or the form with F6 and F8. Then try to close the window or the form using Ctrl F4 or F4. If you get a message prompting to Discard Changes; do so.
• If you are stuck in a flexfield or Find window, try clearing with F5.
• If you are trying to escape a flexfield or LOV, try the cancel button or Esc.
• If a menu or navigator does not respond, try F4 to cancel query mode.
• If a folder does not return data from the database, use the menu choice Folder >> Reset Query
• If a message box says "Exit Oracle Applications", use Esc or the cancel button to stay logged in.

Comments

Links

• Related:

This Topic Is Referenced By These Topics:
Related Links: R12Naviagation, WebStatistics

---

---

Was This Topic Useful to You?

Others rated this topic as shown. Please include your rating.

Choice

Select ...Very UsefulSomewhat UsefulNo OpinionNot Useful

Very Useful (3) Somewhat Useful (1)

Collaborating Authors and Reviewers: JimCrum