You can load, import, and reconcile bank statements containing bank-initiated sweep lines.
Prior to running the AutoReconciliation program, you can automatically create and settle transactions in Oracle Treasury or Oracle Cash Management corresponding to the sweep statement lines by running the Sweep Transactions Generation program. This program searches for treasury or cash management bank account transfer transactions that match the details in the sweep statement lines and the corresponding cash pool. If a match is not found, the program creates and settles a transaction in Oracle Treasury or Oracle Cash Management. For more information, see: Cash Management Programs.
You can then run the AutoReconciliation program to reconcile the bank-initiated Sweep statement lines.
Set up cash pools. For more information, see Creating Cash Pools in Cash Leveling.
Enter bank transaction codes corresponding to the sweep transactions. For more information, see: Bank Transaction Codes.
Create a bank statement mapping for sweep transactions by defining the BANK_ACCOUNT_TEXT field to match the free text field on your bank statement lines.
Example
Example: In the BAI2 bank file example below, a bank account sweep in transaction is identified by the text ZBA TRANSFER FROM: and a bank account sweep out transaction is identified by the text ZBA TRANSFER TO:.
You can create a bank statement mapping in the Lines tab of the Bank Statement Mappings window, defining the BANK_ACCOUNT_TEXT field to match the free text field (Rec ID: 16, Position: -1). In this example, the format will be ZBA TRANSFER FROM: (~), ZBA TRANSFER TO: (~). The (~) designates the characters to pick up following the ZBA TRANSFER FROM: or ZBA TRANSFER TO: and store in the BANK_ACCOUNT_TEXT field.
This bank account information is then used by the Sweep Transaction Generation program to search for transactions or to create new transactions in Oracle Treasury or Oracle Cash Management.
Sample BAI2 Bank File with Sweep Transactions
01,121000248,0060981,991105,0727,0727,80,1,2/
02,0060981,121000248,1,991104,0000,USD,/
03,4510001011,,,015,5000000,,,045,5000000,,,040,5000000,, 400,35789779,3,/
88,100,35789779,1,,072,0,,,050,5000000,,/
16,275,45592306,0,,,ZBA TRANSFER FROM: 4522020841
16,575,547940,,,ZBA TRANSFER TO: 4091214650
16,575,9432205,,,ZBA TRANSFER TO: 4091214668 49,163159116,8/
98,23032892911,21,161/
99,23032892911,1,163/
Run the Bank Statement Loader program to populate the interface tables with the bank statement file. For more information, see: Importing Bank Statements.
Run the Bank Statement Import program to transfer information from the interface tables to the bank statement tables. For more information, see: Importing Bank Statements.
Run the Sweep Transactions Generation concurrent program.
Run the AutoReconciliation program to reconcile the bank statement. For more information, see: Reconciling Bank Statements Automatically.
You can manually reconcile a sweep bank statement line if the corresponding transaction is available in Oracle Treasury or Oracle Cash Management. For more information, see: Reconciling Bank Statements Manually.
You can run the Unreconcile Bank Statement program to automatically unreconcile bank statement lines, including sweep in and sweep out transactions. The unreconciliation process will not delete any transactions that were generated by the Sweep Transactions Generation concurrent program.
Select Sweep Transactions Generation program from the Submit Request window.
Enter the following parameters:
Bank Branch Name (required)
Bank Account Number
Statement Number From
Statement Number To
Statement Date From
Statement Date To
Submit your request.
The concurrent program generates the Sweep Transactions Generation Execution Report, which lists the exceptions found during Sweep Transactions Generation program.