How to check the number of records to be deleted by GL:Archive & Purge
Hi
We are using R12.1.2 We want to run "GL:Archive & Purge". I know , this program purges data from
- GL_JE_BATCHES
- GL_JE_HEADERS
- GL_JE_LINES
- GL_IMPORT_REFERENCES
I want to make sure
"the number records to be deleted from these source tables" matches "the number of records to be archived".
How can I check with a SQL script. For example:
The number of records in the GL_JE_BATCHES to be archived/purged for period=&periodname
-----------------------------------------------------------------------------------
select period_name,ledger_id, actual_flag , count(distinct je_batch_id)
from gl_je_headers
WHERE period_name=&periodname