My Oracle Support Banner

GLPURGE: GL Archive and Purge Errors: ORA-00955: name is already used by an existing object / URGE0072: There is data in table GL_ARCHIVE_BALANCES / URGE0053: Unable to archive balances. (Doc ID 1291088.1)

Last updated on SEPTEMBER 23, 2024

Applies to:

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



Symptoms

GLPURGE program ends with error on attempting to archive and purge balances from General Ledger(GL) module. This may reproduce for archiving balances or other areas (headers, lines, references). When running the concurrent, it shows error in the log file.


ERROR:
ORA-00955: name is already used by an existing object
ORA-06512: at "S
 
-- gluddl Message Dictionary End
[21-MAR-2023 06:09:58]:
<x gluddl()
URGE0072: There is data in table GL_ARCHIVE_BALANCES. Please export the table, then truncate it, then resubmit this request.


[21-MAR-2023 06:09:58]:
<x glgarc()
URGE0053: Unable to archive balances.
SHRD0014: glgmai: main - process exiting with failure.

STEPS TO REPRODUCE:

  1. System Administrator > Attempt to archive and purge GL balances therefore run the concurrent GLPURGE: GL Archive and Purge
  2. View the log file, this shows error

Changes

 None

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.