GLPPOS GLOOAP GLBBSU Fail with ORA-20000 APPS_DDL/APPS_ARRAY_DDL Missing or Invalid in Schema GL (Doc ID 141131.1)

Last updated on AUGUST 14, 2023

Applies to:

Symptoms

Post Journals, Open Period, or Upload Budget Amounts programs fail with the following error :-

Error
-------
ORA-20000:APPS_DDL/APPS_ARRAY_DDL package(s) missing or invalid in schema


Example of a log file showing the error:

+---------------------------------------------------------------------------+
Oracle General Ledger: Version : 11.5.0 - Development
GLPPOS module:Posting
+---------------------------------------------------------------------------+
-- gluddl ad.do_ddl error buffer begin
do_ddl(APPLSYS, SQLGL, 12,$statement$, gl_posting_interim_130):
private_do_ddl(APPS, APPLSYS, GL, 12,$statement$, GL_POSTING_INTERIM_130): :
check_for_apps_ddl(GL): :substr($statement$,1,255)='
drop table gl_posting_interim_130 '
-- gluddlad.do_ddl error buffer end
-- gluddl Message Dictionary Start:
do_ddl(APPLSYS,SQLGL, 12, $statement$, gl_posting_interim_130):
private_do_ddl(APPS, APPLSYS, GL, 12, $statement$, GL_POSTING_INTERIM_130): :
check_for_apps_ddl(GL): :substr($statement$,1,255)='
drop table gl_posting_interim_130 '
APP-FND-01564:ORACLE error 20000 in begin ad_ddl.do_ddl(:schema, :sn,
ad_ddl.drop_table ,:stmt, :obj); end;
cause: begin ad_ddl.do_ddl(:schema, :sn, ad_ddl.drop_table ,:stmt, :obj);
end; failed due to ORA-20000: APPS_DDL/APPS_ARRAY_DDL package(s) missing
or
invalid in schema GL
ORA-06512: at "SYSTEM.AD_DDL", line130
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.drop_table , :stmt, :obj); end;
and was
executed from the file &ERRFILE.
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 ACCOUNT_CATEGORY_BALANCING
in routine &ROUTINE.

-- gluddl Message Dictionary End
SHRD0187: Encountered the following error in routine gluddl():
ORA-20000:APPS_DDL/APPS_ARRAY_DDL package(s) missing or invalid in schema GL
ORA-06512: at"SYSTEM.AD_DDL", line 130
ORA-06512: at line 1
SHRD0030: glpmpi() encountered an error returning from err_gluddl:

Changes

Usually occurs after a patch has been applied

Cause