GLPURGE GL Archive And Purge Fails With APP-FND-01564 URGE0072
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
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms