GLPPOS: Posting Errors with GL_POSTING_INTERIM Table ORA-08103: object no longer exists (Doc ID 434412.1)

Last updated on OCTOBER 10, 2022

Applies to:

Symptoms

Posting errors out with the following:

>> gluddl() 25-JAN-2007 20:00:13
-- gluddl ad.do_ddl error buffer begin
do_ddl(APPLSYS, SQLGL, 1, $statement$, gl_posting_interim_44432): private_do_ddl(APPS, APPLSYS,
GL, 1, $statement$, GL_POSTING_INTERIM_44432): do_cd_tab_cd_seq(0, APPS, GL, 1,
GL_POSTING_INTERIM_44432, $statement$): : do_apps_ddl(GL, $statement$): :
substr($statement$,1,255)='
create table gl_posting_interim_44432
(code_combination_id number(15) not null,
period_name varchar2(15) not null,
set_of_books_id number(15) not null,
currency_code varchar2(15) not null,
period_year number(15),
pe'
-- gluddl ad.do_ddl error buffer end
-- gluddl Message Dictionary Start:
do_ddl(APPLSYS, SQLGL, 1, $statement$, gl_posting_interim_44432): private_do_ddl(APPS, APPLSYS,
GL, 1, $statement$, GL_POSTING_INTERIM_44432): do_cd_tab_cd_seq(0, APPS, GL, 1,
GL_POSTING_INTERIM_44432, $statement$): : do_apps_ddl(GL, $statement$): :
substr($statement$,1,255)='
create table gl_posting_interim_44432
(code_combination_id number(15) not null,
period_name varchar2(15) not null,
set_of_books_id number(15) not null,
currency_code varchar2(15) not null,
period_year number(15),
pe'
ORA-08103: object no longer exists
ORA-06512: at "SYSTEM.AD_DDL", line
APP-FND-01388: Cannot read value for profile option MRC_MAX_DAYS_TO_ROLL_RATE in routine &ROUTINE.
APP-FND-01388: Cannot read value for profile option GL_DEBUG_MODE in routine &ROUTINE.

-- gluddl Message Dictionary End

<x gluddl() 25-JAN-2007 20:00:14
SHRD0187: Encountered the following error in routine gluddl():
ORA-08103: object no longer exists
ORA-06512: at "SYSTEM.AD_DDL", line
SHRD0030: glpmpi() encountered an error returning from err_gluddl:

<x glpmpi() 25-JAN-2007 20:00:14

>> gluerr() 25-JAN-2007 20:00:14
Error in ROUTINE: glpmpi, status: 0
SHRD0043: ERROR:

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.