Does anyone know if I can Archive/Purge Bank Statements from the base tables ?
Oracle R12.2.12
Cash Management
I have run the program 'Archive Purge Bank Statements' from Cash Management Superuser. However, the reports shows zero bank statements have been purged from the open interface tables (I wouldn't expect any statements to be here) and Bank statement tables. The tables affected are CE_STATEMENT_LINES, CE_STATEMENT_HEADERS and CE_STATEMENT_RECONCILS_ALL.
I have checked the following archive tables and they show no records.
CE_ARCH_HEADERS_ALL Archived CE_STATEMENT_HEADERS_ALL records
CE_ARCH_INTERFACE_HEADERS_ALL Archived CE_STATEMENT_HEADERS_INT_ALL records
CE_ARCH_INTERFACE_LINES Archived CE_STATEMENT_LINES_INTERFACE records