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

Symptoms

You have either :-
- created a budget journal in GLDI/ADI and are trying to upload it to Oracle General Ledger
or
- 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.

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.