How to Run FUPLOAD Process

The baseline process, FUPLOAD, electronically feeds journal voucher documents into the Banner Finance tables from a macro-enabled spreadsheet as a prerequisite to the Finance feed process, FURFEED, resulting in these transactions being posted into the Banner Finance Module.

The baseline process, FUPLOAD, electronically feeds journal voucher documents into the Banner Finance tables from a macro-enabled spreadsheet as a prerequisite to the Finance feed process, FURFEED, resulting in these transactions being posted into the Banner Finance Module.

1. You must have access or request access to FUPLOAD and GJAJFLU.
2. If you haven’t already, create a “TEMP” folder on your c drive (C:\TEMP).  One time set up
3. Open the Excel spreadsheet template and run the embedded macros as follows:

To enable Macros in Excel, go to > File > Options > Trust Center > Trust Center Settings > Macro Settings > Enable all macros...

If you get this message when opening the spreadsheet, click on” Enable content”:

Click on the “SHOW CONTROLS” box in the upper left-hand corner…

to see this box:

2. Click on 
   to run and wait until it’s finished.  Your computer may flicker or act strange while this process runs.

 

3. Click on 
   to run and wait until it’s finished.  Your computer may flicker or act strange while this process runs.

 

Note:         Depending on the size of the file,  Consolidate Records can take 5+ minutes to run, causing all Office products to lock and cause Excel to flicker and flash until it finishes. 

 

4. Click on
      and click “No” to creating multiple files. This step will create the “DL_FUPLOAD_MMDDYY_HHMMSS.txt” file in C:\TEMP.

1. Navigate to your TEMP folder to retrieve the finished file.
2. Open in notepad++ to confirm the below Notes.
3. Save once validated.

 

     NOTE: If SYSTEM_ID is ‘DATALOAD’, replace it with ‘FUPLOAD ’, making sure there is a [space] after FUPLOAD to ensure the fields remain in their proper positions.

 

Note: If you use GJAJFLU with FUPLOAD then input files may need to be converted to the correct format using Unix end of line (EOL) characters rather than DOS.  In the file there will be [CR][LF] at the end of each line.  There should only be [LF] when using GJAJFLU.  In Notepad++ go to View/Show Symbol/Show End of Line.

4. Move the file to the server using GJAJFLU.
   1. Log into banner and go to GJAJFLU
   2. In the Job field type FUPLOAD

3. Click select file icon to select your fupload file from your desktop

4. Check the “Save in Product Data Home Directory” check box

5. Click save in the lower right corner – Job submission interface box will run
6. Note that the File Path will populate

5. First, run FUPLOAD in “Audit” mode and review output.
   1. Parameters 1,2,4 should be defaulted – you should only have to insert parameter 3 – File Name

 

Note:         Before running any Banner job, note the job number after you run it so that you can check the job output afterward.

 

If you get the expected results i.e. the number of lines in FUPLOAD matches the actual number of lines in the …” file, continue on.

        Note:         The “Line” value [2,690] in the FUPLOAD output must match the last line number in the “DL_FUPLOAD_121018_112628.txt” text file.

The Error/Warning: “*Warning* - No text records were associated with this document” is an acceptable warning if there are no text records and it doesn't stop the processing. You can continue with that warning.  Text records are additional text data that goes into the FOBTEXT table and is completely optional for a journal entry.

 

6. Next, run FUPLOAD in “Update” mode and review output.

       NOTE        Make sure the number of records and “DOCUMENT TRANS_TOT” value in the FUPLOAD output matches the number of records and the total in the provided Excel spreadsheet. Also, make note of the “Doc Code:” in the FUPLOAD output.

The FUPLOAD process loads records into the GURFEED (Finance Transaction Input Table) table.

        Note:         When FUPLOAD runs in ‘Update’ mode, the ‘.txt’ extension of the original ‘DL_FUPLOAD…’ file is replaced with a ‘. processed’ extension, so if you have to re-run the process, you’ll need to FTP another copy of the original file, delete the ‘. processed’ file, and run the process again.

 

For example:

‘DL_FUPLOAD_082018_124550.txt’ becomes ‘DL_FUPLOAD_082018_124550.processed’

 

7. Second, run FURFEED (Finance Feed Sweep Process) in ‘V’ - View mode and review job output to ensure the total “Amount” on FURFEED matches the total amount of all items in the FUPLOAD source spreadsheet.

 

• (Audit)

01 Report Mode V

02 System ID/Time Stamp = FUPLOAD

If total “Amount” on FURFEED matches the spreadsheet total, continue on; otherwise, stop.

8. Next, run FURFEED in ‘S’ – Select mode and review job output.
9. (Update)

01 Report Mode: S

02 System ID/Time Stamp = FUPLOAD

FURFEED moves data from GURFEED table to FGBTRNI table.

If FURFEED runs successfully in “Update” mode, continue on.

 

9. Third, run FGRTRNI (Interface Process) and check output.
10.  

01 System ID = ALL

02 Disposition [Leave Blank]

“A” for Approval or “I” for Incomplete or “C” (or blank) for Complete

*Note: Parameter value entered at run time will not override the FTMSDAT setting.

 

*Legend: JVC – Complete; C – Complete; JVA – Approval; A – Approval, JVI – Incomplete; I- Incomplete

If FGRTRINI does not produce any errors, continue to FGRTRNR.

 

10. Lastly, run FGRTRNR (Transaction Error Report).

This job has no parameters.

Review job output for errors.