This documentation shows the user how to load data for GL Interface.
Step 1: The data file provided by the analyst can either be a .CSV file or a .DAT file.
Step 2: Rename the data file to a name without spaces e.g. datafilename.dat.
Step 3: Copy the data file to the project folder, into folder GLDataLoadElvis.
Step 4: Load on to oracleserver (128.1.2.213) via VNC.
Step 5: Load Command Prompt.
Step 6: Change to D:PRODprodappl. Run APPSORA.cmd.
Step 7: Change to folder D:PROJECT FOLDERGLDataLoadElvis
Step 8: At the Command Prompt, run SQL Loader:
sqlldr80 apps/apps control=elvis.ctl data=datafilename.dat
Step 9: If only about 50-60 lines load, the data was incorrect (the load process fails after 50 lines have failed). Check the log file elvis.log for more information.
0 Comments.