My Oracle Support Banner

GLPURGE GL Archive And Purge Fails With Error: APP-FND-01564: ORACLE error 955 in begin ad_ddl.do_ddl / ORA-06512 / URGE0072 / URGE0054 (Doc ID 272586.1)

Last updated on MAY 12, 2023

Applies to:

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


Symptoms

The General ledger program, Archive/Purge is erroring when run. The error is displayed in the log file.

ERROR:
APP-FND-01564: ORACLE error 955 in begin ad_ddl.do_ddl(:schema, :sn, ad_ddl.create_table , :stmt, :obj); end;

Cause: begin ad_ddl.do_ddl(:schema, :sn, ad_ddl.create_table, :stmt, :obj); end; failed due to ORA-00955: name is already used by an existing object
ORA-06512: at "SYSTEM.AD_DDL", line 130
ORA-06512: at line 1.

The SQL statement being executed at the time of the error was:
begin ad_ddl.do_ddl(:schema, :sn, ad_ddl.create_table , :stmt, :obj); end; and was executed from
the file &ERRFILE.
-- gluddl Message Dictionary End
URGE0072: There is data in table GL_ARCHIVE_BATCHES.
Please export the table, then truncate it, then resubmit this request.

URGE0054: Unable to create journal tables.
SHRD0014: glgmai: main - process exiting with failure.


STEPS TO REPRODUCE:

1. Under the General Ledger Responsibility > Run Archive/Purge
2. Select permanenly closed periods and run Archive
3. Note the process fails and the errors are displayed in the logfile. 

The same error may occur related to GL_ARCHIVE_BALANCES table.



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.