GLPURGE GL Archive And Purge Fails With APP-FND-01564 URGE0072 (Doc ID 272586.1)

Last updated on JUNE 07, 2021

Applies to:

Symptoms

The General ledger program, Archive/Purge is erroring when run. The error seen in the log file is: 
APP-FND-01564: ORACLE error 955 in begin ad_ddl.do_ddl(:schema, :sn, ad_ddl.create_table , :stmt, :obj); end;

This error is seen by taking the following Steps:

1. First run Archive/Purge
2. Select permanent closed periods, and run Archive
3. Archiving Process fails &Log file shows following errors

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.

The same error may occur with the GL_ARCHIVE_BALANCES table.

Cause