Reviewing Bank Statement Files

This topic discusses how to review bank statement files, statement event log information, and statement transmittal information.

Page Name

Definition Name

Usage

Review Bank Statement Files Page

BSP_FILE_INQUIRY

Review summary and detail information about the import status of bank files.

View Bank Statement File Log Page

BSP_FILE_INFO

View event log information for a bank statement file.

See the Review Bank Statement Files Page for more information.

View Bank Statement File Page

BSP_FILEDATA_SP

View bank statement file transmittal information.

See the Review Bank Statement Files Page for more information.

The Review Bank Statement Files page enables you to review the staging status of the imported bank statement files. You can see if the system successfully loads a file. If a file does not successfully load, use the View Bank Statement File Log page to determine exactly where the system encounters a file loading error.

Important! Any user with access to these pages can view the file details. Restrict user access by using PeopleTools Security functionality.

See the product documentation for PeopleTools: Security Administration.

Use the Review Bank Statement Files page (BSP_FILE_INQUIRY) to review summary and detail information about the import status of bank files.

Navigation:

Banking > Bank Statements > Review Bank Statement Files

This example illustrates the fields and controls on the Review Bank Statement Files page. You can find definitions for the fields and controls later on this page.

 Review Bank Statement Files page

Enter the search parameters and click Search.

Field or Control

Description

File Status

Options are:

  • (none)

  • Error: Appears if the file is not successfully loaded. A red square also appears next to the file name. You must correct the error, then reimport the file.

  • Formatting: Appears if the system is still transforming the file to a PeopleSoft readable format.

  • Reading: Appears if the system is still reading the file data before loading the data to the staging tables.

  • Staged: Appears if the system has loaded the transformed data to the staging tables. A green circle also appears next to the file name.

  • Warning: Appears if the file is loaded with errors. A yellow inverted triangle also appears next to the file name.

View File

Click to access the View Bank Statement File page (BSP_FILEDATA_SP), where you can review bank statement file transmittal information.

View Event Log

Click to access the View Bank Statement File Log page (BSP_FILE_INFO), where you can review event log information for a bank statement file.