Archiving and Purging Imported Bank Statements
After you import a bank statement into Cash Management, you can purge its information from the bank statement open interface tables. You can also archive the information before you purge it. Purge and archive can also be run against the bank statement tables.
Purging
The purge process deletes all header and statement line information from either the open interface tables or the bank statement tables--nothing is retained.
- If you do not periodically purge your open interface and bank statement tables, the retained information will continue to occupy valuable disk space.
- You can purge bank statement information without archiving it first.
Warning: If you use Cash Management to reconcile journal entries in General Ledger, you should run the Cash Management Purge program before you purge journals in General Ledger. See: Archiving and Purging (Oracle General Ledger User's Guide).
Archiving
With archiving, you can save copies of your bank statement information.
- You cannot archive without also purging.
- When you archive, 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.
- You must empty your archive tables before archiving.
- To save your archived information to a file you must use the ORACLE RDBMS Export utility. Contact your Database Administrator or System Administrator for further information.
- To restore information from a saved archive file, you must first use the ORACLE RDBMS Import utility 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.
AutoReconciliation
You can choose to have Cash Management automatically archive and purge the bank statement open interface tables during the bank statement import process. To do this you must set the Archive and Purge Automatic Reconciliation options on the System Parameters window. See: System Parameters.
- Automatic archive and purge applies only to the open interface tables, not to the bank statement tables.
- Information is only archived and purged following the successful transfer of the bank statement information from the open interface tables to the bank statement tables. This occurs before any automatic reconciling takes place.
Prerequisites
Load your bank statement file into the bank statement interface tables.
Use the Bank Statement Import program to import the bank statement information into Cash Management.
To archive and/or purge imported bank statements:
1. Navigate to the Submit Request window.
2. Select the List of Values button to see a list of available programs and reports.
3. Select Archive/Purge Bank Statements program. The Parameters window appears.
4. Select the Archive/Purge Objects. You can choose Statement tables, Interface tables, or Both.
5. Select the Archive/Purge Option. You can choose Archive/Purge or Purge.
6. Choose the Bank Branch Name whose statements tables will be archived and/or purged.
7. Optionally, choose a Bank Account Number. If you do not choose a bank account number, all bank accounts for the bank branch name are processed.
8. Choose a Statement Date. All statements with this date or an earlier date will be archived and/or purged.
9. Choose OK to save your work. The Submit Request window appears again.
10. Complete the Print Options and Run Options regions of the window, then choose Submit to begin running the program.
11. Review the Archive/Purge Bank Statements Execution Report. If there were errors, investigate and correct them, then rerun the Archive/Purge Bank Statements program.
To archive and/or purge imported bank statements automatically:
1. Set the Archive and Purge options on the System Parameters window.
2. Run the Bank Statement Import program.
See Also
System Parameters
Importing Bank Statements
Reconciling Bank Statements Automatically
Overview of Setting Up
About Bank Statement Open Interface
Archiving and Purging (Oracle General Ledger User's Guide).
ORACLE RDBMS Utilities User's Guide