GLPURGE GL Archive And Purge Fails With APP-FND-01564 URGE0072
(Doc ID 272586.1)
Last updated on JUNE 07, 2021
Applies to:
Oracle General Ledger - Version 10.7 to 12.2 [Release 10.7 to 12.2]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 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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |