Purge GL : Journal , error -- gluddl ad.do_ddl error buffer end [message #179123] |
Sun, 25 June 2006 21:49 |
voralux
Messages: 72 Registered: January 2006
|
Member |
|
|
After I Purge GL : Journal,
Concurrent Name : GL Archive and Purge (Completed , Error)
do_ddl(APPLSYS, SQLGL, 1, $statement$, GL_ARCHIVE_BATCHES): private_do_ddl(APPS, APPLSYS, GL, 1, $statement$, GL_ARCHIVE_BATCHES): do_cd_tab_cd_seq(0, APPS, GL, 1, GL_ARCHIVE_BATCHES, $statement$): : do_apps_ddl(GL, $statement$): : substr($statement$,1,255)='CREATE TABLE GL_ARCHIVE_BATCHES (
JE_BATCH_ID NUMBER(15) NOT NULL,
LAST_UPDATE_DATE DATE NOT NULL,
LAST_UPDATED_BY NUMBER(15) NOT NULL,
SET_OF_BOOKS_ID NUMBER(15) NOT NULL,
NAME VARCHAR2(100) NOT NULL,
STATUS VARCHAR2(1) NOT NULL,
STATUS_VERIFIED VARCHAR2'
-- gluddl ad.do_ddl error buffer end
-- gluddl Message Dictionary Start:
|
|
|
Re: Purge GL : Journal , error -- gluddl ad.do_ddl error buffer end [message #179175 is a reply to message #179123] |
Mon, 26 June 2006 03:43 |
agostino_neto
Messages: 180 Registered: July 2005
|
Senior Member |
|
|
May I suggest logging a TAR for this problem?
We don't know what release of eBusiness Suite you are using.
We don't know what the patch level for GL is.
We are not sure you are using the latest release of GL Archive and Purge.
Did you find error cause on metalink ?
-> Is GL_ARCHIVE_BATCHES empty? (You should not have rows in GL_ARCHIVE tables before running archive and purge)
-> Did you reach MAX EXTENT for GL_ARCHIVE_BATCHES?
-> Does gl have privileges to create a table?
|
|
|