Loading Data Into GL Interface

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.

Leave a Comment


NOTE - You can use these HTML tags and attributes:
<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>


This site uses Akismet to reduce spam. Learn how your comment data is processed.