My Oracle Support Banner

GLXBDUPL When Upload Budget Get ORA-20000 APPS_DDL/APPS_ARRAY_DDL Missing Or Invalid In APPS Schema (Doc ID 1061704.6)

Last updated on OCTOBER 06, 2022

Applies to:

Oracle General Ledger - Version 10.7 to 11.0.3 [Release 10.7 to 11]
Oracle Applications Desktop Integrator - Version 10.7 to 11.0.3 [Release 10.7 to 11]
Information in this document applies to any platform.
Form:GLXBDUPL.FMB - Upload Budgets


You have either :-
- created a budget journal in GLDI/ADI and are trying to upload it to Oracle General Ledger
- you have populated the GL_BUDGET_INTERFACE with an external program and are trying to upload the records into Oracle General Ledger as follows:

Responsibility = General Ledger Super User GUI
GUI Navigation = Budget/Enter/Upload
GUI Form Name = GLXBDUPL (Upload Budgets)

1. Select a Budget and Budget Organization from the list of values (LOV).

2. Click on the [Upload] button.

This spawns a concurrent process. When you view your request (Navigation: Help/View My Request) you see the process completed with a status of "Error."

You click on the [Request Log] button to review the log.
You see the following errors in the log file:

ORA-20000: APPS_DDL/APPS_ARRAY_DDL package(s) missing or invalid in schema APPS
ORA-06512: at "SYSTEM.AD_DDL", line 94
ORA-06512 at line 1
SHRD0084: Deleting from table GL_BUDGET_INTERIM
ORA-20000:APPS_DDL/APPS_ARRAY_DDL package(s) missing or invalid in schema APPS
ORA-06512: at "SYSTEM.AD_DDL", line 94
ORA-06512: at line 1

<x glscbt() 16-NOV-1998 12:04:51
SHRD0043: ERROR: ORA-00942: table or view does not exist
SHRD0030: main() encountered an error returning from glscbt()
SHRD0134: Error detected creating table: GL_BUDGET_INTERIM

Other processes, such as Open Period or Posting could be ending with similar errors also.


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.