Search

Wednesday, July 29, 2009

Data Load

Data Load is a convenient tool used for loading data into Oracle Apps forms. It has a look of a spreadsheet where we can put in commands or data and that data will get pasted into the selected Window (Oracle Apps Window etc.) and the commands will get executed in that window.

Data loader commands:
TAB: Tab
ENT: Enter
*UP: Up Arrow

*DN: Down Arrow

*LT: Left Arrow

*RT: Right Arrow

*SP: Save & Proceed

*FE: Field Editor
*PB: Previous Block
*NB: Next Block
*PF: Previous Field
*NF: Next Field
*PR: Previous Record
*NR: Next Record
*ER: Erase Record
*DR: Delete Record
*FR: First Record
*LR: Last Record
*SAVE: Save Record

*SB: Send a single space character
*ST: Select entire field text.
*SLN or *SL(N): Pause for N seconds.

*BM: Block Menu
*AX: Alt + X where X is a single letter (A-Z).
*FI: Find
*FA: Find All
*QE: Query Enter
*QR: Query Run
*CL: Clear Field
*IR: Insert record
*CW(window): Change to window window.
*ML(coordinates): Position the mouse at coordinates and press the left button.
*MR(coordinates): Position the mouse at coordinates and press the right button.
*CW(window): Make window the new target window for DataLoad.
*DL(coordinates): Position the mouse at coordinates and double click the left button.
PROMPT(message): Prompt the user with message and wait for a response.

Auto Tab

The auto tab check box enables automatic tabbing while working in Copy & Paste mode. When Auto Tab is used the "TAB" command can be omitted from the grid and DataLoad will automatically send a TAB command after each data cell has been sent.



Exercises:
  • Though dataload is used for inputting or updating the data in Oracle, the first two exercises are used to deal with querying the data. It is just to familiarize the user how F11 and Ctrl+F11 are done in Data Load
  • Exercise-3 deals with creating a new item based on an existing item
  • Exercise-4 is an attempt to use dataload on an OA page that performs Move Immediate functionality



Exercise-1: To query for ‘57ER%’ in “OPM Item Master” using dataload file
In Oracle Apps,
  • we open “OPM Item Master”,
  • do ‘F11’ and
  • then type “57ER%’ in Item field and
  • then do ‘Ctrl+F11’

In Data Load file,

  • *QE is for “Query Enter” or F11
  • *QR is for “Query Run” or ‘Ctrl+F11’
  • In case we need to sleep, use *SL(N) where N is number of seconds. For example, to sleep for 5 secs, we use *SL(5)

Exercise-2: To query for all FGLM items in “OPM Item Master” using dataload file
In Oracle Apps,
  • we open “OPM Item Master”,
  • do ‘F11’ and
  • then type ‘FGLM’ in Warehouse Item field and
  • then do ‘Ctrl+F11’

In Data Load file,

  • *QE is for “Query Enter” or F11
  • *QR is for “Query Run” or ‘Ctrl+F11’
  • In case we need to sleep, use *SL(N) where N is number of seconds. For example, to sleep for 5 secs, we use *SL(5)
  • TAB is used for going to the next field


Exercise-3: To create a new record in “OPM Item Master” by copying from “57ER%A” record
In Oracle Apps,
  • we open “OPM Item Master”,
  • do ‘F11’ and
  • then type ‘57ER%A’ in Item field and
  • then do ‘Ctrl+F11’
  • then File->New or click on the green plus button on the Buttons Bar
  • Go to Edit->Duplicate->Record Above
  • Change the item number and its description
  • And finally Save it
  • The UOM conversions page automatically opens and we close that window

In Data Load file,

  • *QE is for “Query Enter” or F11
  • *QR is for “Query Run” or ‘Ctrl+F11’
  • In case we need to sleep, use *SL(N) where N is number of seconds. For example, to sleep for 5 secs, we use *SL(5)
  • TAB is used for going to the next field
  • *IR is to insert a new record
  • *DN is for pressing DOWN Arrow
  • *UP is for pressing UP Arrow
  • *RT is for pressing RIGHT arrow
  • ENT is for hitting the ENTER key
  • *SAVE is for saving. (*SP is for SAVE and PROCEED. This command saves the record and clear all the fields for entering new record)
  • *AE is for Alt+E, *AF is for Alt+F
  • TAB is for tabbing to the nest field

Exercise-4: To move the sublots in QCH to SCL using Inspection Disposition form (Tempel Steel Project) through Data Loader

In Inspection Disposition OA page,

  • By default, the cursor is in the “Scan Sublot” field
  • The “ADD” button has shortcut “Alt+A”
  • The “SUBMIT” button has shortcut “Alt+S”
  • When we enter sublot and do “Alt+A”, the sublot gets added to the table region
  • Now we need to change the Location to SCL, lot status to GOOD and let the quantity remain as it is and remove the reason code. To delete the reason code, we simply enter a single-space and tab out
  • Finally, we need to hit “Alt+S” or SUBMIT button to do the Move Immediate
In Data Load File,
  • *AA is for “Alt+A”
  • *AS is for “Alt+S”
  • *SP is for single space
  • TAB is for tabbing out to the next field
  • *SL(7) is to sleep for 7secs

More exercises are in the making...! Happy Data Loading! :)