Processing Reconciliations
This topic discusses how to select and run the reconciliation processes.
|
Page Name |
Definition Name |
Usage |
|---|---|---|
|
BANK_RECON_REQUEST |
Create a reconciliation run control for a specified bank and account. This run control contains the following three reconciliation methods:
|
Use the Process Bank Reconciliation page (BANK_RECON_REQUEST) to create a reconciliation run control for a specified bank and account.
Navigation:
The Process Scheduler Request page displays three reconciliation process methods:
Select Bank Reconciliation to run the Bank Reconciliation (BNK_RECON) Application Engine process.
Select the BRCN_SAC PSJob for Reconciliation and Statement Accounting to run the BNK_RECON and TR_STMTACCTG Application Engine processes serially.
Select the BNRCNBSP PSJob for the Reconciliation and Bank Statement Process to run BNK_RECON and AR_BNKSTMT serially.
Oracle’s PeopleSoft recommends that you select only one method to run at a time instead of selecting multiple methods to run concurrently.
This example illustrates the fields and controls on the Process Reconciliation page. You can find definitions for the fields and controls later on this page.
Field or Control |
Description |
|---|---|
Process All Accounts |
Select the check box to submit the bank reconciliation process for all bank accounts to which the user has access. The access to bank accounts can be granted using the Financial Gateway security feature. Note: When you select this option and saves the component, a row is written into the PS_RECON_REQ_RUN table. When the reconciliation process is submitted, application deletes the rows on PS_RECON_REQUEST table corresponding to the Run Control ID. Then, the table is populated with the Bank Account details and the reconciliation process is run. Since a delete happens in the PS_RECON_REQUEST table, all the saved data for the Run Control ID is lost and new data will be fetched based on the Financial Gateway security. Bank Reconciliation (BNK_RECON), Statement Accounting (TR_STMTACCTG) and Load Bank Statements (AR_BNKSTMT) processes share the same run control record. If the user has created one Run Control ID for all three processes and then selects the Process All Accounts check box, the data in PS_RECON_REQUEST table will be rewritten every time the Bank Reconciliation process is run. Hence, it is recommended to use separate Run Control IDs if you intend to run Bank Reconciliation (BNK_RECON), Statement Accounting (TR_STMTACCTG) and Load Bank Statements (AR_BNKSTMT) processes for separate Bank Accounts with Process All Accounts option selected. |
Process Frequency and Request Number |
Enter your process frequency and request parameters. |
Statement ID |
You can enter a specific statement ID or you can leave the Statement ID field blank. The system runs the selected process for all statements that are not marked complete (C). |
Select any combination of the three reconciliation methods to process the defined transactions, and click OK.
The reconciliation methods are:
Bank Reconciliation (BNK_RECON) Application Engine process.
This Application Engine program processes the specified bank account transactions with the defined reconciliation parameters for the bank account.
Recon and Statement Accounting (reconciliation and statement accounting) (BRCN_SAC) PSJob.
This multi-process job runs both reconciliation and Cash Management Bank Statement Accounting reconciliation parameters on the specified bank account transactions.
Recon and Bank Statement Process (reconciliation and bank statement process) (BNRCNBSP) PSJob.
This multi-process job runs both the Bank Reconciliation process and the Bank Stmt Processing (bank statement processing) process (AR_BNKSTMT), which loads payments into the Receivables tables.