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

Last updated on AUGUST 14, 2013

Applies to:

Oracle General Ledger - Version 10.7 to 12.1 [Release 10.7 to 12.1]
Information in this document applies to any platform.
***Checked for relevance on 16-NOV-2012***
Executable:GLPURGE - GL Archive and Purge

Symptoms

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

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 hundreds of Community platforms