My Oracle Support Banner

GLPURGE GL Archive Purge Program Is Not Purging The Data From GL_ARCHIVE_LINES Table (Doc ID 1502748.1)

Last updated on JANUARY 30, 2023

Applies to:

Oracle General Ledger - Version 12.1.3 and later
Information in this document applies to any platform.
Executable:GLPURGE - GL Archive and Purge


Symptoms

When run archive and then run purge, the records in GL_ARCHIVE_LINES do not get purged.

The report shows :-



                  Journal Batch Rows Purged    Journal Entry Rows Purged    Journal Line Rows Purged    Import Reference Rows Purged
                  ---------------------------     --------------------------    --------------------------    ------------------------------
Total                                                 12                                            12                                             0                                                     0

Note: the same may apply while purging other tables' data, such as GL_JE_LINES / GL_IMPORT_REFERENCES.

Changes

Attempting to purge data

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

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