Now login as PLAY_USER from any windows client and open the specific Form i.e. the form in which you want to load the data. As soon as you open the specific Form Oracle will start playing the file. Sometimes you will not see the actual fields getting populated but you can see the progress on the status bar of Oracle Forms. This is perfectly normal as Oracle is doing the load in background.
Note:
Steps 1, 2, 3 are one time steps only. Later on you will be just performing Steps 5 to 9 only. That is recording into file myrec.fdl and then opening this file in Forms Data Loader and populating it with data and then transferring it back to oracle server by renaming it as play.fdl and then playing it by logging as PLAY_USER.
And if you have to load the data into the same form regularly say once or twice a week, then there is no need to record the file again and again. You can save the myrec.fdl file as template and open this file in Forms Data Loader and populate it with new data and then transfer it to Oracle Apps Server by renaming it to play.fdl file.
You can also change the directory location for record and playback files. For this you have to edit FORMS_TRACE_DIR settings in Oracle Application Context file and running Auto Config utility. Please ask your APPS DBA or Sys Admin to do this if required.
Please delete the files myrec.fdl and play.fdl before you attempt to record a new file or finished playback.
If you are facing any issues then please view
Data Loader FAQ page
If still the issue is not
resolved then please do contact us at
support@formsdataloader.com
© Interface Computers All Rights Reserved