GLPURGE: After Archive Process Is Completed Should Table GL_ARCHIVE_SEGMENT_VALS Be Dropped? (Doc ID 2822643.1)

Last updated on FEBRUARY 21, 2023

Applies to:

Goal

As referenced in the User's Guide:

Oracle® General Ledger
User's Guide
Release 12.2
Part No. E48748-05
Page 7-26
https://docs.oracle.com/cd/E26401_01/doc.122/e48748.pdf

Once completing the Archive and Purge cycle for a ledger and specific periods:

In order to archive the next period you need to drop the Archive tables.
To drop your GL_ARCHIVE_BALANCES table run the following SQL
command, substituting GL_ARCHIVE_BATCHES, GL_ARCHIVE_HEADERS,
GL_ARCHIVE_LINES, or GL_ARCHIVE_REFERENCES for the table name:

Table GL_ARCHIVE_SEGMENT_VALS is not mentioned, does this also need to be dropped?

 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.