Database concepts

Oracle links

Log Files

A better method (FOR WHAT GUYS) is to view the log file. This will tell you if any records were not loaded successfully. If this is the case a .bad file will be created that lists those records.

  1. To view the log file, open a file transfer window (SSH Secure File Transfer or WinSCP) and refresh the view. The log file(s) will then appear.
    Log File
  2. Drag the log file on to your computer to open it. These log files are formatted text and are best viewed with WordPad or TextPad not Notepad.

The invoiceitem.log file is reproduced here with line numbers for explanation. See the annotations for lines we need to know about.

Log file