Migrating Bank Reconciliation Application and Configuration Data

PeopleSoft delivers two Application Data Set (ADS) definitions to support bank reconciliation rules and reconciliation rules for bank accounts. Because bank reconciliation relies heavily on bank statement data that can vary from bank to bank, PeopleSoft recommends configuring reconciliation rules in a test database, validating the rules, and using ADS definitions to migrate the rules to a production environment.

For introductory information about the Data Migration Workbench and using ADS, see this documentation:

The following table lists the ADS definitions delivered in Data Set Designer that support the migration of PeopleSoft Bank Reconciliation data:

ADS Definition ADS Usage Records in the Data Set

TR_BANK_ACCT_RCN_RULE

This data set is used to migrate or move reconciliation rules associated with a bank account from one environment to another environment. This data set is built on the component BANK_ACCT_RCN_RULE.

Note: Before migrating reconciliation rules associated with a bank account, ensure that the bank account is defined in target environment

This data set includes the records used for bank account reconciliation rules:

  • BANK_ACCT_RCN_SC

  • BNK_ACCT_RCN_RL

TR_BANK_RECON_RULE

This data set is used to migrate or move bank reconciliation rules from one environment to another environment. This data set is built on the component BANK_RECON_RULE.

This data set includes the records used for bank reconciliation rules:

  • BANK_RECON_RULE

  • BANK_RECON_AGG

  • BANK_RECON_FLTR

  • BANK_RECON_MAT

  • BANK_RECON_MSQL

  • BANK_RECON_FSQL

You can find complete information about setting up and using ADS definitions for data migration in the documentation for PeopleTools: Lifecycle Management Guide. The PeopleTools documentation covers the following topics:

  • Using the Data Set Designer.

  • Copying and comparing projects.

  • Validating data sets.

  • Implementing data set security.