add

About Me

My photo
Oracle Apps - Techno Functional consultant

Monday, October 1

Data Loader Commands

Command
Description
EBS - R12
EBS - 11i
EBS - 10.7/11.0 NCA
EBS - 10.7SC
Other
TAB
TAB key
\{TAB}
\{TAB}
\{TAB}
\{TAB}
\{TAB}
ENT
Enter key
\{ENTER}
\{ENTER}
\{ENTER}
\{ENTER}
\{ENTER}
*UP
Up arrow key
\{UP}
\{UP}
\{UP}
\{UP}
\{UP}
*DN
Down arrow key
\{DOWN}
\{DOWN}
\{DOWN}
\{DOWN}
\{DOWN}
*LT
Left arrow key
\{LEFT}
\{LEFT}
\{LEFT}
\{LEFT}
\{LEFT}
*RT
Right arrow key
\{RIGHT}
\{RIGHT}
\{RIGHT}
\{RIGHT}
\{RIGHT}
*SP
Save & proceed
\%F%V
\%F%V
\%A%{DOWN 4}{ENTER}
\%A%A

*SAVE
Save
\^S
\^S
\^S
\{F10}

*NB
Next Block
\+{PGDN}
\+{PGDN}
\+{PGDN}
\^{PGDN}

*PB
Previous Block
\+{PGUP}
\+{PGUP}
\+{PGUP}
\^{PGUP}

*NF
Next Field
\{TAB}
\{TAB}
\%G%{DOWN}{ENTER}
\{TAB}

*PF
Previous Field
\+{TAB}
\+{TAB}
\%G%{DOWN 2}{ENTER}
\+{TAB}

*NR
Next record
\{DOWN}
\{DOWN}
\%G%{DOWN 3}{ENTER}
\+{DOWN}

*PR
Previous record
\{UP}
\{UP}
\%G%{DOWN 4}{ENTER}
\+{UP}

*FR
First record
\%V%DF
\%V%DF
\%G%{DOWN 5}{ENTER}
\%G%F

*LR
Last record
\%V%DL
\%V%DL
\%G%{DOWN 6}{ENTER}
\%G%L

*ER
Erase record
\{F6}
\{F6}
\{F6}
\+{F4}

*DR
Delete record
\^{UP}
\^{UP}
\^{UP}
\+{F6}

*SB
Space bar
\
\
\
\
\
*ST
Select field text
\{HOME}+{END}
\{HOME}+{END}
\{HOME}+{END}
\{HOME}+{END}
\{HOME}+{END}
*BM
Block menu
\^B
\^B
\^B
\{F5}

*QE
Query enter
\{F11}
\{F11}
\{F11}
\{F7}

*QR
Query run
\^{F11}
\^{F11}
\^{F11}
\{F8}

*FI
Find
\%V%F
\%V%F
\%Q%{DOWN}{ENTER}


*FA
Find all
\%V%I
\%V%I
\%Q%{DOWN 2}{ENTER}


*IR
Insert record
\^{DOWN}
\^{DOWN}
\^{DOWN}
\{F6}

*CL
Clear field
\{F5}
\{F5}
\{F5}
\^U

*FE
Field edit
\^E
\^E
\^E
\^E

*AA
Alt A
\%A
\%A
\%A
\%A
\%A
*AB
Alt B
\%B
\%B
\%B
\%B
\%B
*AC
Alt C
\%C
\%C
\%C
\%C
\%C
*AD
Alt D
\%D
\%D
\%D
\%D
\%D
*AE
Alt E
\%E
\%E
\%E
\%E
\%E
*AF
Alt F
\%F
\%F
\%F
\%F
\%F
*AG
Alt G
\%G
\%G
\%G
\%G
\%G
*AH
Alt H
\%H
\%H
\%H
\%H
\%H
*AI
Alt I
\%I
\%I
\%I
\%I
\%I
*AJ
Alt J
\%J
\%J
\%J
\%J
\%J
*AK
Alt K
\%K
\%K
\%K
\%K
\%K
*AL
Alt L
\%L
\%L
\%L
\%L
\%L
*AM
Alt M
\%M
\%M
\%M
\%M
\%M
*AN
Alt N
\%N
\%N
\%N
\%N
\%N
*AO
Alt O
\%O
\%O
\%O
\%O
\%O
*AP
Alt P
\%P
\%P
\%P
\%P
\%P
*AQ
Alt Q
\%Q
\%Q
\%Q
\%Q
\%Q
*AR
Alt R
\%R
\%R
\%R
\%R
\%R
*AS
Alt S
\%S
\%S
\%S
\%S
\%S
*AT
Alt T
\%T
\%T
\%T
\%T
\%T
*AU
Alt U
\%U
\%U
\%U
\%U
\%U
*AV
Alt V
\%V
\%V
\%V
\%V
\%V
*AW
Alt W
\%W
\%W
\%W
\%W
\%W
*AX
Alt X
\%X
\%X
\%X
\%X
\%X
*AY
Alt Y
\%Y
\%Y
\%Y
\%Y
\%Y
*AZ
Alt Z
\%Z
\%Z
\%Z
\%Z
\%Z

No comments: