After you import a bank statement into Oracle Cash Management, you can purge its information from the Bank Statement Open Interface tables. After you reconcile the bank statement, you can purge its information from the Bank Statement tables. To save a copy of your bank statement, you can archive the information before you purge it. You can also archive or purge intra-day bank statement information from the Bank Statement Open Interface tables and the Intra-Day Bank Statement tables.
You can run the Archive/Purge Bank Statements program to archive and purge. When the program completes, it automatically prints the Archive/Purge Bank Statements Report to display the number of headers and lines that were archived or purged.
The purge process deletes all statement header and line information from the open interface tables or the bank statement tables, or both, nothing is retained. When you purge a bank statement, you must also purge any system transactions reconciled to the bank statement.
We recommend that you periodically archive and purge your bank statement interface and bank statement tables. If you do not periodically purge your bank statement interface and bank statement tables, the retained information will continue to occupy valuable disk space.
Warning: If you use Oracle Cash Management to reconcile journal entries in General Ledger, you should run the Oracle Cash Management Purge program before you purge journals in General Ledger. See: Archiving and Purging.
With archiving, you can save copies of your bank statement information.
You cannot archive without purging.
When you archive, Oracle Cash Management copies all header and statement line information from either the open interface tables or the bank statement tables into special archive tables the system maintains.
To save your archived information to a file, you must use the Oracle Database Utilities Export feature. Contact your Database Administrator or System Administrator for further information.
To restore information from a saved archive file, you must first use the Oracle Database Utilities Import feature to populate the special archive tables. Then, you must run a custom SQL*Loader script to transfer the information from the archive tables to the bank statement or open interface tables. Contact your Database Administrator or System Administrator for further information.
See: Oracle Database Utilities 11g Release 2 (11.2) Guide for further information.
If you set the Archive and Purge options in the System Parameters window, you can automatically archive or purge bank statement information from the Bank Statement Open Interface tables after the bank statements have been successfully imported into Oracle Cash Management. You can also automatically archive or purge imported intra-day bank statement information from the Bank Statement Open Interface tables. To archive or purge information from the Bank Statement tables or Intra-Day Bank Statement tables, however, you must run the Archive/Purge Bank Statements program. See: System Parameters.
The Restore Bank Statements concurrent program reads the archived data and restores to the original tables from where it has been archived.
The program deletes the archived data once it is successfully restored.
If restore process fails, the errors are reported on the execution report.
While Restoring Bank Statements at interface level, if user provides only bank branch as input parameter and the bank account number is defined for multiple for the given branch. The bank account name at the execution report displays "Multiple Accounts Found" on the report.
Other Sources
Oracle Database Utilities 11g Release 2 (11.2) Guide
Load your bank statement file into the bank statement interface tables.
Import the bank statement information into Oracle Cash Management.
Navigate to the Submit Request window.
Select the List of Values button to see a list of available programs and reports.
Select Archive/Purge Bank Statements program. The Parameters window appears.
Select what do you want to archive and/or purge. You can choose Statement tables, Interface tables, or Both. The default option is Both.
Select the Statement Type that you want to archive or purge. You can choose Intra-Day Statements, Previous-Day Statements, or Both. The default option is Both.
Select Interface Statement Status. You can choose Corrected, Error, New, Transferred, or All. The default is All.
Select the Archive/Purge Option. You can choose Archive/Purge or Purge.
Select the Archive Option that you want the program to perform:
Append: append archive data to any existing archive data. This is the default option.
Delete: delete existing data in interface before saving new archive data
Choose the Bank Branch Name whose statements tables will be archived and/or purged.
Optionally, choose a Bank Account Number. If you do not choose a bank account number, all statements for the bank branch name are processed.
Choose a Statement From and Statement To Date. All statements within the period will be archived and/or purged.
Choose whether you want to purge only unreconciled statements or not. The default option is Yes.
Choose OK to save your work. The Submit Request window appears again.
Complete the Print Options and Run Options regions of the window, then choose Submit to begin running the program.
Review the Archive/Purge Bank Statements Execution Report. If there were errors, investigate and correct them, then rerun the Archive/Purge Bank Statements program.
Set the Archive and Purge options on the System Parameters window.
Import the bank statement information into Oracle Cash Management.
Navigate to the Submit Request window.
Select the List of Values button to see a list of available programs and reports.
Select Restore Bank Statements program. The Parameters window appears.
Select what do you want to restore. You can choose Interface tables, Statement tables, or Both. The default option is Statement.
Select the Statement Type that you want to restore. You can choose Intra-Day Statements, Previous-Day Statements, or Both. The default option is Previous-Day.
Select Interface Statement Status. You can choose Corrected, Error, New, Transferred, or All. The default is All.
Choose the Bank Branch Name whose statements tables will be restored.
Optionally, choose a Bank Account Number. If you do not choose a bank account number, all statements for the bank branch name are processed.
Choose a Statement From and Statement To Date. All statements within the period will be restored.
Choose OK to save your work. The Submit Request window appears again.
Complete the Print Options and Run Options regions of the window, then choose Submit to begin running the program.
Review the Restore Bank Statements Execution Report. If there were errors, investigate and correct them, then rerun the Restore Bank Statements program.