Understanding Financial Gateway Security for Bank Reconciliation

Businesses can leverage Financial Gateway security on many bank reconciliation components and pages to limit access to banking data. Financial Gateway security functionality limits the list of prompt values for secured fields to only those that meet the defined security rule criteria. The prompt values are determined based on the rule definitions that are assigned to a given user or role.

Note: Your system must have PeopleSoft Cash Management installed to leverage Financial Gateway security.

The setup involves an administrator enabling the functionality and creating security rules. Next, the administrator assigns rules to user IDs or roles so that when users attempt to query bank IDs and bank accounts, only those banks and accounts that comply with their assigned rules appear. Banking inquiries filter out banks or accounts that are based on the requesting user and the criteria that are specified for them based on their user ID or their role.

See the Financial Gateway documentation for setting up payment security: Understanding Payment Security and related topics.

The following components and pages have been updated to enforce security by leveraging Financial Gateway security:

Page Name

Definition Name

Navigation

Bank Statement Manager

BNK_STMT_MGR

Banking > Bank Statements > Bank Statement Manager

Enter Bank Statement

BANK_BALSTMT_ENTRY

Banking > Bank Statements > Enter Bank Statements

Enter Current Day Statement

BANK_SDBALSTMT_ENT

Banking > Bank Statements > Enter Current Day Statements

Enter Fee Statements

FA_BANK_STMT_ANYL

Banking > Bank Statements > Enter Fee Statements

Review Bank Balances

BNK_BAL_AAA_PNL

  • Banking > Bank Statements > Review Bank Balances

  • Select Review Bank Balances from the Go To list on the Bank Statement Manager page.

Review Bank Statements

BNK_RCN_STMT_GEN

  • Banking > Bank Statements > Review Bank Statements

  • Select Review Bank Statements from the Go To list on the Bank Statement Manager page.

Review Bank Statement Files

BSP_FILE_INQUIRY

Banking > Bank Statements > Review Bank Statement Files

Reconciliation Manager

BNK_RCN_MGR

Banking > Reconcile Statements > Reconciliation Manager

Parse Statement Addenda

ADDENDA_PARSE_REQ

Banking > Reconcile Statements > Parse Statement Addenda

Process Bank Reconciliation

BANK_RECON_REQUEST

Banking > Reconcile Statements > Process Bank Reconciliation

Process Statement Accounting

TR_STMTACCTG

Banking > Reconcile Statements > Process Statement Accounting

Automatic Reconciliation

BNK_RCN_CYC_STSA

Banking > Reconcile Statements > Automatic Reconciliation > Automatic Reconciliation

Semi Manual Reconciliation

BNK_RCN_SEMI_MAN

Banking > Reconcile Statements > Semi-Manual Reconciliation > Semi Manual Reconciliation

Manual Reconciliation

BNK_RCN_MAN_GEN

Banking > Reconcile Statements > Manual Reconciliation > Manual Reconciliation

External Transactions

GEN_TRAN_UPDT

Banking > Reconcile Statements > External Transactions

Schedule ID Reconciliation

BNK_RCN_MAN_TRE

Banking > Reconcile Statements > Schedule ID Reconciliation > Schedule ID Reconciliation

Reverse Schedule ID Recon

BNK_RCN_MAN_TRE

Banking > Reconcile Statements > Reverse Schedule ID Recon > Reverse Schedule ID Recon

Select Book to Bank Statements

BNK_BTB_STMT_SEL

Banking > Reconcile Statements > Select Book To Bank Statements > Select Book to Bank Statements

Book to Bank Reconciliation

BNK_BTB_REC_MGR

Banking > Reconcile Statements > Book to Bank Reconciliation

Override Book to Bank Status

BNK_BTB_REC_MGR

Banking > Reconcile Statements > Override Book to Bank Status

Automatic Reconciliation Exceptions

BNK_RCN_VUE_UNR

Banking > Analyze Exceptions > Auto Reconciliation Exceptions > Automatic Reconciliation Exceptions

Transactions by Account

BNK_RCN_ALL_GEN

Banking > Analyze Exceptions > Transactions by Account > Transactions by Account

Manual Account Register Report

FSX4004

  • Banking > Reconcile Statements > Schedule ID Reconciliation

  • Banking > Reconcile Statements > Reverse Schedule ID Recon

  • Banking, Analyzing Exceptions, Transactions by Account

  • BankingReconcile StatementsManual Reconciliation and select Reconciled or Unreconciled in the Status field.

Note: The following behavioral changes occur on these components and pages when leveraging Financial Gateway security on bank reconciliation components:

- Changes have been made to search functionality on Bank reconciliation components and pages that support Financial Gateway security. Users are required to enter search values to return results on search pages.

- Also, Bank and Bank Account for bank statements must be defined in the system to retrieve them on the inquiry page for the Enter Bank Statements page. However, without defining the bank and bank account, users can access query manager and build a query to retrieve bank statements data.