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: PeopleSoft Financial Gateway: 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, and then Bank Statements, and then Bank Statement Manager

Enter Bank Statement

BANK_BALSTMT_ENTRY

Banking, and then Bank Statements, and then Enter Bank Statements

Enter Current Day Statement

BANK_SDBALSTMT_ENT

Banking, and then Bank Statements, and then Enter Current Day Statements

Enter Fee Statements

FA_BANK_STMT_ANYL

Banking, and then Bank Statements, and then Enter Fee Statements

Review Bank Balances

BNK_BAL_AAA_PNL

  • Banking, and then Bank Statements, and then 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, and then Bank Statements, and then 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, and then Bank Statements, and then Review Bank Statement Files

Reconciliation Manager

BNK_RCN_MGR

Banking, and then Reconcile Statements, and then Reconciliation Manager

Parse Statement Addenda

ADDENDA_PARSE_REQ

Banking, and then Reconcile Statements, and then Parse Statement Addenda

Process Bank Reconciliation

BANK_RECON_REQUEST

Banking, and then Reconcile Statements, and then Process Bank Reconciliation

Process Statement Accounting

TR_STMTACCTG

Banking, and then Reconcile Statements, and then Process Statement Accounting

Automatic Reconciliation

BNK_RCN_CYC_STSA

Banking, and then Reconcile Statements, and then Automatic Reconciliation, and then Automatic Reconciliation

Semi Manual Reconciliation

BNK_RCN_SEMI_MAN

Banking, and then Reconcile Statements, and then Semi-Manual Reconciliation, and then Semi Manual Reconciliation

Manual Reconciliation

BNK_RCN_MAN_GEN

Banking, and then Reconcile Statements, and then Manual Reconciliation, and then Manual Reconciliation

External Transactions

GEN_TRAN_UPDT

Banking, and then Reconcile Statements, and then External Transactions

Schedule ID Reconciliation

BNK_RCN_MAN_TRE

Banking, and then Reconcile Statements, and then Schedule ID Reconciliation, and then Schedule ID Reconciliation

Reverse Schedule ID Recon

BNK_RCN_MAN_TRE

Banking, and then Reconcile Statements, and then Reverse Schedule ID Recon, and then Reverse Schedule ID Recon

Select Book to Bank Statements

BNK_BTB_STMT_SEL

Banking, and then Reconcile Statements, and then Select Book To Bank Statements, and then Select Book to Bank Statements

Book to Bank Reconciliation

BNK_BTB_REC_MGR

Banking, and then Reconcile Statements, and then Book to Bank Reconciliation

Override Book to Bank Status

BNK_BTB_REC_MGR

Banking, and then Reconcile Statements, and then Override Book to Bank Status

Automatic Reconciliation Exceptions

BNK_RCN_VUE_UNR

Banking, and then Analyze Exceptions, and then Auto Reconciliation Exceptions, and then Automatic Reconciliation Exceptions

Transactions by Account

BNK_RCN_ALL_GEN

Banking, and then Analyze Exceptions, and then Transactions by Account, and then Transactions by Account

Manual Account Register Report

FSX4004

  • Banking, and then Reconcile Statements, and then Schedule ID Reconciliation

  • Banking, and then Reconcile Statements, and then 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.