Data Loader Commands / Shortcuts

Since remembering and typing keystrokes is quite difficult in Macro Loading, Forms Data Loader comes with built-in shortcuts (commands) for complex, frequently used keystroke sequences.

For example, in Oracle Apps we often use the key sequence Alt+Save & Proceed to save and proceed to the next record. The equivalent keystroke for Alt+Save+Proceed is \%F%V.

Instead of specifying the complex keystroke \%F%V, you can use the shortcut *SP.

Data Loader recognizes a cell's contents as a shortcut (command) if the preceding character is an asterisk "*".

Data Loader also lets you modify the default shortcuts and change keystrokes to suit your own requirements. To change the default shortcuts / commands, simply modify whatever shortcut or equivalent keystroke you like and click Save.

Here is the list of default Data Loader commands / shortcuts:

Shortcut	Description	Behaviour in Oracle Forms	Equivalent Keystroke Sent In
Shortcut	Description	Behaviour in Oracle Forms	Oracle Apps 11i/R12	Oracle Apps NCA	Oracle Rel 10SC	Other Apps
TAB	TAB Key	Key Next_item	`\{TAB}`	`\{TAB}`	`\{TAB}`	`\{TAB}`
ENT	Enter	Depends on Context	`\{ENTER}`	`\{ENTER}`	`\{ENTER}`	`\{ENTER}`
*UP	Up arrow key	Key Up	`\{UP}`	`\{UP}`	`\{UP}`	`\{UP}`
*DN	Down arrow key	Key Down	`\{DOWN}`	`\{DOWN}`	`\{DOWN}`	`\{DOWN}`
*LT	Left arrow key	Depends on Context	`\{LEFT}`	`\{LEFT}`	`\{LEFT}`	`\{LEFT}`
*RT	Right arrow key	Depends on Context	`\{RIGHT}`	`\{RIGHT}`	`\{RIGHT}`	`\{RIGHT}`
*SP	Save & Proceed	MENU CUSTOM FILE ACCEPT	`\%F%V`	`\%A%{DOWN 4}{ENTER}`	`\%A%A`
*SAVE	Save	Key Commit_form	`\^S`	`\^S`	`\{F10}`
*NB	Next Block	Key Next_block	`\+{PGDN}`	`\+{PGDN}`	`\^{PGDN}`
*PB	Previous Block	Key Previous_block	`\+{PGUP}`	`\+{PGUP}`	`\^{PGUP}`
*NF	Next Field	Key Next_item	`\{TAB}`	`\%G%{DOWN}{ENTER}`	`\{TAB}`
*PF	Previous Field	Key Previous_item	`\+{TAB}`	`\%G%{DOWN 2}{ENTER}`	`\+{TAB}`
*NR	Next record	Key Down	`\{DOWN}`	`\%G%{DOWN 3}{ENTER}`	`\+{DOWN}`
*PR	Previous record	Key Up	`\{UP}`	`\%G%{DOWN 4}{ENTER}`	`\+{UP}`
*FR	First record	MENU CUSTOM RECORD FIRST	`\%V%DF`	`\%G%{DOWN 5}{ENTER}`	`\%G%F`
*LR	Last record	MENU CUSTOM RECORD LAST	`\%V%DL`	`\%G%{DOWN 6}{ENTER}`	`\%G%L`
*ER	Erase record	Key Clear_record	`\{F6}`	`\{F6}`	`\+{F4}`
*DR	Delete record	Key Delete_record	`\^{UP}`	`\^{UP}`	`\+{F6}`
*SB	Space bar	Depends on Context	`\{SPACE}`	`\{SPACE}`	`\{SPACE}`	`\{SPACE}`
*ST	Select field text	[none]	`\{HOME}+{END}`	`\{HOME}+{END}`	`\{HOME}+{END}`
*BM	Block menu	Key Block_menu	`\^B`	`\^B`	`\{F5}`
*QE	Query enter	Key Enter_query	`\{F11}`	`\{F11}`	`\{F7}`
*QR	Query run	Key Execute_query	`\^{F11}`	`\^{F11}`	`\{F8}`
*FI	Find	MENU CUSTOM VIEW FIND	`\%V%F`	`\%Q%{DOWN}{ENTER}`
*FA	Find all	MENU CUSTOM VIEW FIND_ALL	`\%V%I`	`\%Q%{DOWN 2}{ENTER}`
*IR	Insert record	Key Create_record	`\^{DOWN}`	`\^{DOWN}`	`\{F6}`
*CL	Clear field	Key Clear_item	`\{F5}`	`\{F5}`	`\^U`
*FE	Field edit	Key Edit	`\^E`	`\^E`	`\^E`
*AA	Alt A	Depends on Context	`\%A`	`\%A`	`\%A`	`\%A`
*AB	Alt B	Depends on Context	`\%B`	`\%B`	`\%B`	`\%B`
*AC	Alt C	Depends on Context	`\%C`	`\%C`	`\%C`	`\%C`
*AD	Alt D	Depends on Context	`\%D`	`\%D`	`\%D`	`\%D`
*AE	Alt E	Depends on Context	`\%E`	`\%E`	`\%E`	`\%E`
*AF	Alt F	Depends on Context	`\%F`	`\%F`	`\%F`	`\%F`
*AG	Alt G	Depends on Context	`\%G`	`\%G`	`\%G`	`\%G`
*AH	Alt H	Depends on Context	`\%H`	`\%H`	`\%H`	`\%H`
*AI	Alt I	Depends on Context	`\%I`	`\%I`	`\%I`	`\%I`
*AJ	Alt J	Depends on Context	`\%J`	`\%J`	`\%J`	`\%J`
*AK	Alt K	Depends on Context	`\%K`	`\%K`	`\%K`	`\%K`
*AL	Alt L	Depends on Context	`\%L`	`\%L`	`\%L`	`\%L`
*AM	Alt M	Depends on Context	`\%M`	`\%M`	`\%M`	`\%M`
*AN	Alt N	Depends on Context	`\%N`	`\%N`	`\%N`	`\%N`
*AO	Alt O	Depends on Context	`\%O`	`\%O`	`\%O`	`\%O`
*AP	Alt P	Depends on Context	`\%P`	`\%P`	`\%P`	`\%P`
*AQ	Alt Q	Depends on Context	`\%Q`	`\%Q`	`\%Q`	`\%Q`
*AR	Alt R	Depends on Context	`\%R`	`\%R`	`\%R`	`\%R`
*AS	Alt S	Depends on Context	`\%S`	`\%S`	`\%S`	`\%S`
*AT	Alt T	Depends on Context	`\%T`	`\%T`	`\%T`	`\%T`
*AU	Alt U	Depends on Context	`\%U`	`\%U`	`\%U`	`\%U`
*AV	Alt V	Depends on Context	`\%V`	`\%V`	`\%V`	`\%V`
*AW	Alt W	Depends on Context	`\%W`	`\%W`	`\%W`	`\%W`
*AX	Alt X	Depends on Context	`\%X`	`\%X`	`\%X`	`\%X`
*AY	Alt Y	Depends on Context	`\%Y`	`\%Y`	`\%Y`	`\%Y`
*AZ	Alt Z	Depends on Context	`\%Z`	`\%Z`	`\%Z`	`\%Z`

To access the Shortcuts (Commands) list, click the "Edit Shortcuts" button Edit Data Loader Shortcuts on the toolbar in the Forms Data Loader main window.

Tip: Remember, with the new Macro Recording feature it has become very simple to develop macro loads. The Macro Recorder in Data Loader will automatically recognize all keystrokes and prepare the sheet for you. Please click the "Create New by Recording" button Macro Recording in Data Loader on the toolbar. For more information click here.

Download Latest Data Loader - 2026 Edition

The most popular and frequently updated data loader for loading data into any Oracle EBS forms.

Data Loader for Oracle