My Oracle Support Banner

GLPPOS Posting Log File Shows APP-01564: ORACLE error 4031 in begin ad_ddl.do_ddl (Doc ID 110962.1)

Last updated on AUGUST 14, 2023

Applies to:

Oracle General Ledger - Version 11.0 to 11.5.10.2 [Release 11 to 11.5.10]
Information in this document applies to any platform. Form:GLXJEPST.FMB - Post Journals
Executable:GLPPOS - Posting

Symptoms

Posting fails and the log file returns the following errors:

  APP-01564: ORACLE error 4031 in begin ad_ddl.do_ddl(:schema, :sn, ad_ddl.
  drop_table , :stmt, :obj); end;

  ...
  -- gluddl Message Dictionary End
  SHRD0187: Encountered the following error in routine gluddl():
  ORA-06550: line 1, column 31:
  PLS-00201: identifier 'WEBSERV.FND_INSTALLATION' must be declared
  ORA-06550: line 1, column 26:
  PL/SQL: Statement ignored
  ORA-06512: at "SYSTEM.AD_DDL", line 130
  ORA-06512: at line 1
  SHRD0030: glpmpi() encountered an error returning from err_gluddl:

  <x glpmpi() 08-APR-2000 11:08:19
  SHRD0042: Error in ROUTINE: glpmpi, status: 0
  SHRD0043: ERROR:

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!

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