add

About Me

My photo
Oracle Apps - Techno Functional consultant

Friday, November 15

Oracle Applications Shortcuts

Field Colors – the following table holds a list of the various field colors in Oracle Forms and what they mean


Color
Description

White
Optional, allows data entry

Yellow
Required Field, data must be entered

Gray
Information Only, not enabled for entry

Blue
Query Field, enter data to search


Find Window vs. Query – Details what functionality is available in a Find window vs an Ad-Hoc query window


Activity
Find Window
Query Window

Accessed
(M), (T)
(M), F11

Locating Data
Find Window
Existing Window

Use Wildcard
Yes
Yes

Use Operators
No
Yes

Count Record
No
Yes

Field Colors
White
Blue


Query Operators – these operators can be used within queries to further restrict or expand your search results


Operator
Example

=
Equal To
=’Janet’           =107

!=
Not Equal To
!=’Janet’        !=107

Greater Than
>’Texas’         >99.1

>=
Greater Than or Equal To
>=’Texas’       >=99.1

Less Than
<’Texas’         <1000

<=
Less Than or Equal To
<=’Texas’       <=100

#BETWEEN
Between Two Values
#BETWEEN 1 and 100


“%”  Wildcard Functionality – Oracle Apps searching allows you to use the percent sign (%) as a wildcard.


Use
Meaning
Data Retrieved

top%
Information beginning with “top” and ending with any text string or nothing
Top Drive

%top%
Information containing the text “top” anywhere within it
TDS Top Drive

%top
Information containing the text “top” as the last three letters
Swivel Top



Function
Shortcut Key(s)
Moving Around
Next / Previous Field
Tab   /   Shift + Tab
Next Block
Shift + Page Down
Next / Previous Record
Down / Up Arrows
Next Primary Key
Shift + F7
Scroll Down / Up
Page Down / Page Up
Closing Windows
Top Window
Ctrl + F4
All Windows
F4
Querying
Enter Query Mode
F11
Count Matching Records
F12
Execute Query
Ctrl + F11
Cancel Query
F4
Help
Help
Ctrl + H
Keyboard Shortcuts
Ctrl + K
Manipulating Data
Insert Record
Ctrl + Down Arrow
Editing
Ctrl + E
(opens text window)
Saving
Ctrl + S  /   Enter
Clear Field
F5
Clear Record
F6
Cut
Ctrl + X
Copy
Ctrl + C
Paste
Ctrl + V
Duplicate Field Above
Shift + F5
Duplicate Line Above
Shift + F6
Open a List of Values
Ctrl + L
Miscellaneous
Print Screen to Printer
Ctrl + P
Take Screen Shot
Print Screen
(Paste from ClipBoard)
Display Error
Shift + Ctrl + E

No comments: