PeopleSoft Enterprise Financial Gateway 9.1 PeopleBook

Working with Payments in Financial Gateway

This chapter provides an overview of the payment process in Financial Gateway and discusses how to:

Import Payment Files from Third-Party Applications into Financial Gateway.
Review the payment load process.
Review payments in Financial Gateway.
Dispatch payments in Financial Gateway.
Review payment files.
Import bank acknowledgments.

Understanding the Payment Process in Financial Gateway

This diagram illustrates the steps involved in payment and payment acknowledgment processing using Financial Gateway. PeopleSoft Treasury Management, PeopleSoft Receivables, PeopleSoft Payables, and certain 3rd Party Applications import payment requests to the Financial Gateway system, where users can review the payment requests and load any payment exceptions on the Payment Load Exceptions page. Financial Gateway users review the payments and payment details and the Financial Gateway system dispatches the payments to the bank, which in turn reviews and sends acknowledgement of the receipt and contents of the payment files to the Financial Gateway system.

Financial Gateway System process flow for transmitting system source payment data to the bank and receiving bank acknowledgements.

In the diagram above, the payment path is represented by the arrows with the dash/dot lines. The payment-acknowledgment-file path is represented by the arrows with the continuous dotted lines.

Payments are loaded into Financial Gateway from:
- PeopleSoft source applications using the delivered integration, which involves the application class component. This method can be modified to include the use of a BPEL process server .
  
  See Understanding the Financial Gateway Integration Process.
- Third-party applications using a component interface.
- Third-party applications using Integration Broker.
- Third-party applications sending payments in flat-file format using the Import Payment Flat Files page.
- SQL staging tables using the Import Staged Payments page. Users can use a variety of technologies to insert the data into the SQL staging tables.
Regardless of the method used to import payments, the Payment Load Application Engine (PMT_LOAD) process loads payments from source applications into Financial Gateway. If the payments originated from a source application for which financial sanctions validation is required, the system compares the Name and Address fields from the To Account on the payment against the Financial Sanctions list. If a potential match is found, the payment status changes to "Flagged for Hold."

Note. The financial sanctions validation service is enabled at the source application level by selecting Require Payee Validation on the Source Registration page

See Registering Source Applications with Financial Gateway.
You can view results of the payment load process on the Review Payment Request page. Details of errors that are encountered during the payment load process can be viewed on the Payment Load Exceptions page.
When the payments are in the Financial Gateway tables, you can review them using the Review Payment pages. Here payments can be approved for or held from further processing. Payments flagged by the financial-sanctions, data search are designated as a "Potential Sanction Violation" on the Payment Notes page. Administrators can perform a manual search of the financial sanctions data to verify the accuracy of the held payment, after which they can either cancel the payment or clear the flag on the payment thereby changing the status to "Awaiting Dispatch."

See Pages Used to Search the Financial Sanctions Data.
After the optional review process, payments are sent to the bank as payment files using the Dispatch Payment Application Engine. This process can be run manually from the Dispatch Payments page or set up to run automatically using the Schedule Payment Dispatch page.
You can obtain a variety of information using the Payment Files page.
Depending on the bank and whether your system is set up appropriately, you can download files acknowledging that the payment was received, processed, and completed, or that the payment file contained errors that must be corrected. Importing payment acknowledgment files can also be set up to run automatically using the Integration Broker. After the acknowledgment files have been downloaded, they can be reviewed for pertinent information.
If the payment files were imported using flat files, you can import a flat file for payment cancellation and cancel a payment file using the layout file, PAYCANEIP.

See Understanding Electronic Banking.

See Understanding the Financial Gateway Integration Process.

Integration Points

This table lists the integration points that are used in the payment process.

Integration Point	Purpose	Method of Integration
PAYMENT_REQUEST	Used to send payments to Financial Gateway.	Used by all source applications that can integrate with Financial Gateway.
PAYMENT_STATUS_REQUEST	Used to request the status of payments.	Used by all source applications that can integrate with Financial Gateway. Message uses the payment ID as defined by the source application or Financial Gateway depending on how it is defined on the Source Registration page.
PAYMENT_RESPONSE	Used to send the status of payments from Financial Gateway to the source application.	Can be used by Cash Management, Receivables, Payables, and third-party source applications that use Integration Broker to integrate with Financial Gateway.
PAYMENT_CANCEL	Used by Financial Gateway to cancel payments in the source application. Also used when associated with the PAYCANEIP layout to import a flat file for payment cancellation and to perform the cancel action. payment.	Can be used by Cash Management, Receivables, Payables, and third-party source applications that use Integration Broker to integrate with Financial Gateway.

ACH Prenotes and Returns

An ACH prenote is a zero-dollar, payment sent to a debtor's bank to test if payments may be made to a creditor's bank account. If no response is sent back to the debtor, within a reasonable amount of time, it is assumed that payments can be made. If an ACH Return file is received from the creditor's bank, it will contain information that the prenote had errors that must be corrected before the creditor will accept payments from the debtor. The creditor should send a new, corrected prenote.

Financial Gateway processes prenotes similar to other ACH payments. However, tracking the status of prenotes between a debtor's bank account and a particular creditor is the responsibility of the source system.

This diagram illustrates the steps involved in the ACH prenote process in which the source system, such as PeopleSoft Payables or Receivables, sends a zero-dollar payment file (prenote) as a test to the Financial Gateway system. The Financial Gateway system dispatches the prenote file to the debtor's Financial Institution. Financial Institution sends acknowledgement that can be imported into the Financial Gateway system. The Financial Gateway system then sends this acknowledgement of payment status to the source system.

These steps correspond to the prenotification process illustrated in the above diagram:

The source system sends a prenote request to Financial Gateway.
Financial Gateway imports the prenote and creates a payment file.
The payment file is dispatched to the bank using the Dispatch Payment Application Engine.
Financial Institution sends an acknowledgement file.
Financial Gateway imports the acknowledgment files.
Financial Gateway transmits the payment status based on acknowledgment file back to the source system. The source system updates the status of the prenote. If the prenote was rejected, the source system can make the changes and resend another prenote.

Note. For prenotes, Financial Gateway only tracks the status of the payment transaction. Financial Gateway does not track the status of a prenote for a customer or vendor. That is the responsibility of the source system.

Payment Statuses

This table lists the various statuses that a payment can have as it moves through the Financial Gateway payment process:

Payments Status	Details
Canceled	Payment was canceled in Financial Gateway. Can be resent from source application.
Error	An error was encountered when Financial Gateway attempted to process the payment. Details of the error can be viewed on the Payment Load Exceptions page.
Flagged for Hold	Payment is being held for review and cannot be dispatched.
Awaiting Dispatch	Payment is loaded into Financial Gateway. If selected, the payment will be dispatched to the bank the next time the Dispatch Payment Application Engine is run.
In Process	The Dispatch Payment Application Engine is processing the payment.
Dispatched to Bank	The payment has been sent to the bank by the Dispatch Payment Application Engine.
Received by Bank	The bank has received the payment and has sent an acknowledgment.
Paid	The bank has received the payment, processed it, and sent a payment acknowledgment file back to Financial Gateway.
Pending Cancellation	When the Accounts Payable subsystem sends a transaction to Financial Gateway, the payment status will be Awaiting Dispatch. Financial Gateway will dispatch this transaction and set the payment status to Paid. If Account Payable wants to cancel this transaction , the Accounts Payable subsystem uses the Payables Payment Cancellation process to cancel this transaction and set the payment status to Pending Cancellation in Financial Gateway.
Cancelled with Message	Once the status is changed to Pending Cancellation in Financial Gateway, Financial Gateway will execute the Payment Cancellation process for this Accounts Payable transaction and set the payment status to Cancelled with Message. Financial Gateway will send cancellation message in compliance with SEPA to the bank.
Pending Reversal	Similarly when the Accounts Receivable subsystem sends a transaction to Financial Gateway, the payment status will be Awaiting Dispatch. Financial Gateway will dispatch this transaction to the bank and set the payment status is set to Paid in Accounts Receivable. If the Accounts Receivable subsystem reverses this transaction, it sets the payment status to Pending Reversal in Financial Gateway.
Reversed with Message	Using the Payment Dispatch process, Financial Gateway will execute the Reversal Process for this transaction, generate a reversal message in compliance with SEPA to the bank and set the payment status to Reversed with Message.

Note. When a layout is not set up to support acknowledgements, the payment status is set to paid when the payment is dispatched.

Importing Payments and Payment Cancellations as Flat Files from Third-Party Applications

This section presents an overview and discusses how to import payment and payment cancellation flat files from third-party applications.

Note. This section provides information that is necessary for importing payments and payment cancellations into Financial Gateway from third-party applications only in flat file format.

Understanding Importing Payments and Payment Cancellations as Flat Files from Third-Party Applications

You can load third-party cancel payments into Financial Gateway by using the Import Payment Flat Files component functionality. When you load cancelled payments from a third-party flat file into Financial Gateway, the payment status in Financial Gateway is Pending Cancellation. Once the cancel file is loaded, using the PMT_DISP_BT process, Financial Gateway executes the Payment Cancellations process, generates a cancellation message in compliance with SEPA, and sets the payment status to Cancelled with Message.

Pages Used to Import Payment and Payment Cancellation Flat Files

Page Name	Definition Name	Navigation	Usage
Import Payment Flat Files	BSP_IMPORT	Financial Gateway, Import Payments, Import Payment Flat Files	Download payments and payment cancellations as flat files from third-party applications into Financial Gateway.

Importing Payment and Payment Cancellation Flat Files from Third-Party Applications

Access the Import Payment Flat Files page (Financial Gateway, Import Payments, Import Payment Flat Files).

Parameters

Import Type	Select from the following options: FTP: Select if you are importing the file by using file transfer protocol, and enter a bank node through which to transfer the data. File: Select if you are importing a file, and complete the File Path and File Name fields. HTTP: Select if you are importing an XML file using a URL that is included as part of the node configuration. No file path or file name is required.
Bank Node	Enter the bank node that was used to transfer the data. This field appears only if FTP or HTTP is selected as the import type.
View Bank Node Details	Click to access the Bank Node Details page and review property details of the selected node. This link appears only if FTP or HTTP is selected as the import type.
File Path	Enter the complete file path location. To select files by using the Select File button, you must include a trailing backslash (\) in the file path. You can you can also load all files in a given directory by using the . notation or search for files of a specific type by entering an asterisk and the extension suffix. For example, to search all files with a .txt suffix, enter: \*.txt
File Selection Help	Click to view help information about specifying file paths and file names.
File Name	Select the specific file to import. If you want to import multiple files based on extension, leave this field blank.
Layout	Select: PAYREQEIP As the layout that is used to request a payment file. PAYCANEIP As the layout used to request a payment cancellation.
View Layout Details	Click this link to access the details of the selected layout catalog on the Layout Catalog page. See Defining Layout Properties.

Advanced Options

Encryption Profile	Select an encryption profile to decrypt bank statements. Encryption profiles contain both encryption and decryption information.
Use Integration Broker	Select to format the files and publish the formatted document to PeopleSoft Integration Broker. Integration Broker then processes the formatted file accordingly. You select this option if you want to use the bank statement information as a trigger to Integration Broker, as an indication to perform other processes, or to integrate with other systems.
Post Process File Action	Select what action, if any, to perform on bank statement files after the data has been processed. The options are: Copy: Copy the file to the directory that is entered in the Post Precess File Directory field. Delete: Delete the file after the data in it is processed. Move: Move the file to the directory that is entered in the Post Precess File Directory field. None: Take no action.
Post Process File Directory	Enter a file path to the directory to which the file will be moved or copied if either option is selected as the post process file action.

Layout Properties

Value

Specify the type of flat file to be imported. Enter:

CSV: For comma-separated values.
Fixed: For fixed-length field values.

Reviewing the Results of the Payment Load Process

The Payment Load Application Engine (PAYMENT_LOAD) process loads payments from source applications into Financial Gateway, regardless of the method that is used to import payments. This section discusses how to review payment requests.

Pages Used to Review the Results of the Payment Load Process

Page Name	Definition Name	Navigation	Usage
Review Payment Requests	PMT_REQUEST_LOG	Financial Gateway, Import Payments, Review Payment Requests	Review payment requests that were downloaded from source applications. This page is used primarily as an administration page to view payment requests residing in the staging tables.
Payment Load Exceptions	PMT_EXCEPTION_LOG	Click the View Payment Load Exceptions icon on the Review Payment Requests page.	View details of problems that occurred during attempts to load payment requests from source applications.

Reviewing Payment Requests

Access the Review Payment Requests page (Financial Gateway, Import Payments, Review Payment Requests).

Use this page to view a listing and the status of payment requests that were made from source applications. The fields that appear in the Payments group section are source-specific key fields that were specified on the Source Registration page to appear here.

Reviewing and Changing Payments in Financial Gateway

This section presents an overview and discusses how to:

Review payments.
Configure the payment page.
Review payment details.
Change payment status.

Understanding Payment Status Changes in Financial Gateway

Financial Gateway has an option to change the payment status to different values using the Override Payment Status component. This component enables you to change the payment status values for accounts payable, accounts receivable, and third-party transactions.

See Changing Payment Status.

Pages Used to Review Payments in Financial Gateway

Page Name	Definition Name	Navigation	Usage
Payments	PMT_INQUIRY	Financial Gateway, Review Payments, Payments	Inquire on payments that were received by Financial Gateway from source applications.
Payment Preferences	PMT_PREFERENCE	Click the Edit User Preferences link on the Payments page.	Define the search criteria and information to be displayed on the Payments page.
Save Search As	PMT_SEARCH	Click the Save Search link on the Payments page.	Define and save a transaction query using predefined search criteria for future use.
Delete Saved Search	PMT_SRCH_DEL	Click Delete Search on the Payments page.	Delete a defined set of transaction search criteria.
Payment Notes	PMT_NOTES	Click the Payment Notes icon for a specific payment in the grid on Payment Information tab of the Payments page.	View events and add comments regarding a particular transaction. This is useful for such things as describing reason transactions that are in hold status. Notes that you add here appear in the Events for Current Payment grid at the bottom of the page and are also replicated in the Events grid of the Review Payment Details page.
Review Payment Details	PMT_LIFE_CYCLE_INQ	Click the Review Payment Details icon on the Payments page, the Dispatch Payments page, or the Payment File Data page.	View a payment's details and progress through the payment life cycle, and drill down to application pages that are related to payment events.
Override Payment Status	PMT_STAT_OVR	Financial Gateway, Administration, Override Payment Status	Change the status of payments.

Reviewing Payments

Access the Payments page (Financial Gateway, Review Payments, Payments).

Edit User Preferences

Click to access the Payment Preferences page, which you use to define the search criteria and information that is displayed on the Payments page.

Note. Edit User Preferences link appears in the upper far right corner of the page.

Search Fields

Use these field to narrow your search for specific payments, or leave them blank to view all payments that were sent to Financial Gateway.

Note. If Financial Gateway security is enabled, user will see only the payments that meet their access criteria based on the specified security rules.

See Setting Up Payment Security.

Saved Searches	Displays a list of previously saved search criteria (if any).
Save Search	Click to access the Save Search As page to save the search parameters for future inquiries.

Payment Analytics

This group box provides a graphic representation of the criteria that is listed in the Select a Chart field. Use the Payment Preferences page to enable this functionality as well as to define the default chart to be displayed. The chart can display:

Total Payments by Method: A graph of the total number of payments by payment method for the current date.
Payments on Hold by Source: A graph of the total number of payments that were put on hold, grouped by source applications.
Payment Aging: A graph of the total number of payments within Financial Gateway that were sent within the last five days.
Payments by Bank: A graph of all payments by bank for the current day.
Payments in Error: A graph of all payments within Financial Gateway that contain erroneous data.
Payments Awaiting Response: A graph of all payments within Financial Gateway that have been sent to the bank, but have not yet been acknowledged.

Note. The chart may not display data properly if a large amount of data is selected. Because of size constraints within the page the labels will be truncated.

Payment Totals

This group box displays the number of payments that were sent to Financial Gateway grouped by currency type. If more than one type of currency is displayed, the total for each currency appears as a link. Clicking a link regenerates the rows in the Review Payments grid to display only transactions belonging to that specific currency type.

Payments – Payment Information

Select	Use this box to select transactions: With a status of Awaiting Dispatch to be held for approval. After you have selected transactions, click the Flag for Hold button to assign a hold status to the selected transactions. With a status of Hold to be cleared for further processing. After you have selected transactions, click the Clear Flag button to clear the hold status on the selected transactions, freeing them for further processing.
Flagged for Hold	Indicates that the transaction is on hold status pending further approval.
Source ID	The unique identifier that is assigned to the transaction by the source application.
Transaction ID	The unique identifier that is assigned to the transaction by Financial Gateway. Settlement ID nomenclature is defined on the Source Registration page.
Payment Notes	Click to access the Payment Notes page, which you use to add and view comments about the specified transaction.
Transfer to Source	Click to access the source application to view detailed information about the specified transaction.
Dispatch Payment	Click to access the Dispatch Payment run control page to manually send the payment to the bank.
Review Payment Details	Click to access the Review Payment Details page to view the payment progress, events, and detailed information on the transaction.

View Payment File

Click to access the Payment Files page to view payment-file, transmittal information.

Bank Details

Cutoff Time and Cutoff Date

Payments arriving by this time and date are processed by the bank that day. Payments arriving afterwards are processed on the next business day.

Configuring the Payments Page

Access the Payment Preferences page (Click the Edit User Preferences link on the Payments page).

Use this page to define search criteria for the Payments page.

Default Saved Search	Select a previously defined set of search criteria to be designated as the default search settings on the Payments page.
Execute Search on Load	Select to automatically query the database for the data matching the default search criteria for the current day.
Display Totals	Select to display the number of payments that were sent to Financial Gateway categorized by currency or by bank depending on which radio button you select.

Reviewing Payment Details

Access the Review Payment Details page (Click the Review Payment Details icon on the Payments page, the Dispatch Payments page, or the Payment File Data page).

This page provides a graphical representation of the current payment's progress through the payment life cycle. The icons at the top of the page—Awaiting Dispatch, Dispatched to Bank, Acknowledged by Bank, Payment Processed, and Payment Completed—change from black and white to color as each specific event occurs, and they become enabled buttons that act as links to application pages that are related to the payment and the event. Click a button to access the associated page and view the indicated lifecycle information.

Awaiting Dispatch	The transaction is ready to be dispatched to bank. Click to access the Dispatch Payments page.
Dispatched to Bank	The transaction has been dispatched to the bank. Click to access the Dispatch page to view more details about when and how this transaction was dispatched, and the payment file that was created and dispatched.
Acknowledged by Bank	The acknowledgement of payment has been received from the bank and downloaded to your system. Click to view the downloaded acknowledgement file.
Payment Completed	The bank has paid the transaction. Click to view the paid file and acknowledgement.

Changing Payment Status

Access the Override Payment Status page (Financial Gateway, Administration, Override Payment Status).

Note. Access to this page and the ability to change the payment status is limited to users assigned to the administrator role.

The options for changing the status of a payment are limited and depend on the current status of the payment. This table lists the options that are available for each payment status.

Current Status	Available Status Options
Canceled	Awaiting Dispatch
Error	Canceled Paid Awaiting Dispatch
Flagged for Hold	Canceled
Awaiting Dispatch	Canceled
In Process	Can be changed to Awaiting Dispatch if the payment is still in the queue, and the Dispatch Payment Application Engine process has not been run. This may occur if Process Scheduler was set to run at a later time.
Dispatched to Bank	Error Paid
Acknowledged by Bank	Error Paid
Paid	Error Awaiting Dispatch
For Accounts Payable transactions: Pending Cancellation	Error Paid
For Accounts Payable transactions: Cancellation with Message	Pending Cancellation Error
For Accounts Receivable transactions: Reversal with Message	Error Paid
For Accounts Receivable transactions: Reversed with Message	Pending Reversal Error

Note. For prenotes, Financial Gateway only tracks the status of the actual transaction. Financial Gateway does not track the status of a prenote for a customer or vendor. That is the responsibility of the source system.

Dispatching Payments in Financial Gateway

This section discusses how to dispatch payments.

You dispatch payments in Financial Gateway by running the Payment Dispatch Application Engine process (PMT_DISPATCH). You can run this process manually or schedule it to run at a specified time using PeopleSoft Process Scheduler.

See PeopleTools PeopleBook: PeopleSoft Process Scheduler

Pages Used to Dispatch Payments

Page Name	Definition Name	Navigation	Usage
Schedule Payment Dispatch	PMT_BATCH_DISPATCH	Financial Gateway, Process Payments, Schedule Payment Dispatch	Use PeopleSoft Process Scheduler to automate the payment dispatch process by scheduling the Dispatch Payment process to run in batch mode as the payments arrive in Financial Gateway. Use the Parameter fields to define the payment batches.
Payment Dispatch	PMT_INQUIRY	Financial Gateway, Process Payments, Payment Dispatch	Manually send selected payments to a bank from Financial Gateway.
Payment Preferences	PMT_PREFERENCE	Click the Edit User Preferences link on the Dispatch Payments page.	Modify functionality and define how data is displayed on the Dispatch Payments page.
Addenda	PMT_ADDENDA_SP	Click the Addenda Information icon on the Payment Dispatch page.	Add instructional information that will appear in the actual payment file for a specified payment.
Payment Dispatch Results	PMT_DISP_RESULT	Financial Gateway, Process Payments, Payment Dispatch Click the Results button in the Dispatch Results grid.	View details of a particular payment dispatch.

Dispatching Payments

Access the Payment Dispatch page (Financial Gateway, Process Payments, Payment Dispatch).

Edit User Preferences

Click to access the Payment Preferences page, which you use to define how certain elements of the Dispatch Payments page are displayed and function.

Search Fields

Use these fields to query the tables in Financial Gateway for specific payment transactions.

Payment Totals

Displays the number of payments and the monetary total for each currency type.

Payments

Select	Select the payments to be dispatched or flagged for hold. This field is unavailable for entry for payments that have already been dispatched
Dispatch	Click to send selected payments to the banks.
Flagged for Hold	Click to hold selected payments for further review and approval.
Payments Selected	Displays the number of payment rows that have been selected for dispatching or placing on hold.
Flagged for Clear	Click to remove the hold on selected payments.
Payment Notes	Click to access the Payment Notes page, which you use to add and view comments about the specified transaction. Comments added here appear only online within the Financial Gateway system— including the event log—for the particular payment.
Addenda Information	Click to access the Addenda page, which you use to add additional instructions for the specified payment. Instructions here will appear within the actual payment file.
Transfer to Source	Click to access the source application to view detailed information about the specified transaction.
Review Payment Details	Click to access the Review Payment Details page to view the payment progress, events, and detailed information on the transaction. See Reviewing Payment Details.
Review Payment File	Click to access the Review Payment Files page to review payment file transmittal information. See Reviewing Payment Files.

Bank Details Tab

Cutoff Time and Cutoff Date

Payments arriving by this time and date are processed by the bank that day. Payments arriving afterwards are processed on the next business day.

Dispatching a Payment

To dispatch a payment:

Select a payment.
Click the Dispatch button.
If prompted, confirm that you are an authorized user by typing your system sign-in password on the Verify Identity page.

The system displays a message stating that the Payment Dispatch Application Engine is scheduled to process the payment. If the process is successful, a payment file is created.

Dispatch Results

This grid provides a view of payment dispatch processes.

Refresh	Click to update the grid and view the results of more recent dispatch processes.
Results	Click to access the Payment Dispatch Results page and view details of a particular payment dispatch.

Reviewing Payment Files

The Review Bank Payment Files pages enable you to review the status of the transmitted payment files. You can see whether the system successfully transmitted a file. And if a file was not successfully transferred, use the Payment File Events page to determine exactly where the system encountered a file transmittal error.

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

Note. The Process Monitor's message log will not provide the cause of an error that occurred as the result of a payment dispatch process involving XML-Publisher-template layouts. In such cases, you must inspect the content of the payment file for the cause of the error by accessing the Payment File Data page.

See Understanding the Layout Catalog.

See PeopleTools PeopleBook: Security Administration

This section discusses how to:

Review payment files.
Change payment file status

Pages Used to Review Payment Files

Page Name	Definition Name	Navigation	Usage
Payment Files	PMT_FILE_DEFN	Click the Review Payment Files link on the Payment Dispatch page. Financial Gateway, Review Payments, Payment Files	Review payment file transmittal information.
Payment File Details	PMT_FILE_DETAILS	Click the Payment File ID link for a specific payment file.	View summary information about the payments that are included in the specified payment file.
Payment File Events	PMT_FILE_EVENT	Click the View Event Log icon on the Review Payment Files page.	View summary information of system events that occurred to the payment file during transmittal. Colored icons indicate the transmittal status of the file. A green circle indicates that the file was successfully transmitted; a red square indicates that the file was not successfully transmitted.
Payment File Data	PMT_FILEDATA_SP	Click View File on the Review Payment Files page.	. View detailed payment file data that was transmitted to the bank. This page cannot be edited.
Override Payment File Status	PMT_FILE_DEFN	Financial Gateway, Administration, Override Payment File Status	Change the status of a payment file.

Reviewing Payment Files

Access the Payment Files page (Click the Review Payment Files link on the Payment Dispatch page) or (Financial Gateway, Review Payments, Payment Files).

Enter the search parameters and click Search.

File Status	Options are: (None.) Complete: Indicates that the payment process is complete. Canceled: Indicates that the settlement is canceled (or voided) by a user. You generally see this status displayed for files with a clerical error, such as an incorrectly entered amount. When you cancel files, the system resets the file's payments back to their original Loaded state on the Dispatch Payments page, where they can again be selected and dispatched. Error: Indicates that the payment dispatch process failed. A red square also appears next to the file name. You can either cancel the payment file or recreate it. In Process: Indicates that the system is still transforming the file. Received: Indicates that the payment file was received by bank. Sent: Indicates that the payment file was sent to bank.
Payment File Contents	Click this link (located in the Payment File ID column) to access the Payment File Data page, and review all payments that are included in this payment file.
Recreate File	This conditional field appears only if the payment has an error status. Use the functionality that is described in "Setting Up Electronic Banking in Financial Gateway" to correct the error. After making the corrections, click the Recreate File icon to recreate the selected payment file.
Cancel File	Click to cancel a selected payment file and reset its payments. This conditional field appears only if the payment has an error status.
View Event Log	Click to access the Payment File Events page and view summary event log information.
View File	Click to access the Payment File Data page, and view payment file data that is transmitted to the bank. The system encrypts stored payment file data.
Dispatch Payments	Click to access the Dispatch Payments page, and select payments for electronic transmittal to a financial institution. See Dispatching Payments.
Process Monitor	Click to access the Process List page, and review processing results for the Payment Dispatch Application Engine process (PMT_DISPATCH).

Changing Payment File Status

Access the Override Payment File Status page (Financial Gateway, Administration, Override Payment File Status).

Note. Access to this page and the ability to change the payment file status is limited to users who are assigned to the administrator role.

The options for changing the status of a payment file are limited and depend on the current status of the payment file. This table lists the options that are available for each payment file status.

Current Status	Available Status
Cancelled	No change allowed
Complete	Error
Complete with Errors	Complete Error
Error	Complete
Dispatched to Bank	Complete Error
In Process	No change allowed.
Received by Bank	Complete Error
Paid	Error Pending Cancellation
Pending Cancellation	Error Paid
Cancelled with Message	Pending Cancellation Error

Importing Bank Acknowledgments

This section discusses how to:

Import payment acknowledgement files.
View payment acknowledgement files.

Understanding Acknowledgments

Acknowledgment files are imported from financial institutions into Financial Gateway. They contain data that is used to:

Verify the receipt of a payment.
Acknowledge that a payment was processed successfully.
Notify the sender of problems with a payment.

PeopleSoft provides a variety of layouts designed specifically importing this type of payment data.

Pages Used to Import Bank Acknowledgments

Page Name	Definition Name	Navigation	Usage
Import Acknowledgment Files	BSP_IMPORT	Financial Gateway, Process Payments, Import Acknowledgment Files	Import bank payment acknowledgments (or payment error messages) into the application tables.
Acknowledgment Files	PMT_FILE_ACK_DEFN	Financial Gateway, Review Payments, Acknowledgment Files	View a listing of imported payment acknowledgement files.
Acknowledgment File Contents	PMT_FILE_ACK_DTL	Click the Ack File ID link for a specific file.	View the details of a specific payment acknowledgment file.

Importing Payment Acknowledgment Files

Access the Import Acknowledgment Files page (Financial Gateway, Process Payments, Import Acknowledgment Files).

Parameters

Import Type	Select a method for importing the acknowledgment files. The options are: File: Select if you are importing a file, and complete the File Path and File Name fields. FTP: Select if you are importing the file by using file transfer protocol, and enter a bank node through which to transfer the data. HTTP: Select if you are importing an XML file using a URL that is included as part of the node configuration. No file path or file name is required.
Bank Node	Enter the node that will be used to relay the payment-acknowledgment files from the bank to your system. This field appears only if FTP or HTTP is selected as the import type.
View Bank Node Details	Click to access the Bank Node Details page and review property details of the selected node. This field appears only if FTP or HTTP is selected as the import type.
File Path	Enter the complete file path location. To select files using the Select File button, the file path must have a trailing backslash (\). You can also search for files of a specific type by entering an asterisk and the extension suffix. For example, to search all files with an .XXX suffix, enter: \.XXX Note.* Be sure that the application server and the Process Scheduler have access to the directory where the file(s) are stored.
File Selection Help	Click to view help information about specifying file paths and file names.
File Name	Select the specific file to import. If you want to import multiple files based on extension, leave this field blank.
Layout ID	Select an acknowledgment file layout.
View Layout Details	Click to access the Layout Catalog page to view details of the acknowledgment file layout.

Advanced Options

Encryption Profile	Select an encryption profile to decrypt payment acknowledgments. Encryption profiles contain both encryption and decryption information.
Use Integration Broker	Select to format the files and publish the formatted document to PeopleSoft Integration Broker. Integration Broker then processes the formatted file accordingly. You select this option if you want to use the payment acknowledgment information to trigger Integration Broker to perform other processes or integrate with other systems.
Post Process File Action	Select what action, if any, is to be performed on the payment acknowledgment files after the data has been processed. The options are: Copy: Copy the file to the directory that is entered in the Post Precess File Directory field. Delete: Delete the file after the data in it is processed. Move: Move the file to the directory that is entered in the Post Precess File Directory field. None: Take no action.
Post Process File Directory	Enter a file path to the directory to which the file will be moved or copied if either option is selected as the post process file action.

Layout Properties

Value

Property codes and values appear by default from values that are defined on the selected layout ID.

If you configure unique code mappings for a layout (on the Code Mappings page) you need to modify the displayed CODE_MAP_GROUP value with the appropriate unique map value.

See Defining Code Mappings for Bank Statements, Payments, and Payment Acknowledgments.

Note. If you are importing multiple files for a single run control ID, you must add requests (by using the Add button) for each file that is being requested. Do not enter a file name; run the import process, and then edit the file name and run the import process again. Doing this can result in duplicate acknowledgment loading errors.

Viewing Payment Acknowledgment Files

Access the Acknowledgment Files page (Financial Gateway, Review Payments, Acknowledgment Files)

Enter the search parameters and click Search.

File ID	Click to view the contents of the payment acknowledgment file.
File Status	Options are: Complete: Indicates that the Bank Acknowledgment Import process is complete. Error: Indicates that the Bank Acknowledgment Import process failed. A red square also appears next to the file name. You can either cancel the payment file or recreate it.
View Event Log	Click to access the Payment File Events page, and view summary event log information.
View File	Click to access the Payment File Data page, and view payment file data that is transmitted from the bank. The system encrypts stored payment-acknowledgment files.
Dispatch Payments	Click to access the Payment Dispatch page to search for, and dispatch, payments.