Home » Applications » Oracle Fusion Apps & E-Business Suite » Purge GL : Journal , error -- gluddl ad.do_ddl error buffer end
icon5.gif  Purge GL : Journal , error -- gluddl ad.do_ddl error buffer end [message #179123] Sun, 25 June 2006 21:49 Go to next message
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 Go to previous message
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?
Previous Topic: Blanket PO - Setup and Implementation
Next Topic: Documents management
Goto Forum:
  


Current Time: Mon Dec 23 14:32:32 CST 2024