My Oracle Support Banner

ORA-936 Error Occurred When Executing AD_ZD_TABLE.UPGRADE on a Custom Table in R12.2. (Doc ID 2745433.1)

Last updated on JANUARY 20, 2021

Applies to:

Oracle E-Business Suite Technology Stack - Version 12.2.9 and later
Information in this document applies to any platform.

Symptoms

Create a custom table with a column name which uses a reserved word, eg. column, and when executing the commands in Doc ID:1577661.1 Section 1.4.3 Step2, AD_ZD_TABLE.UPGRADE('<schema name>', '<object_name>');
below error will be shown:

ERROR
-------
ORA-00936: missing expression
ORA-06512: "APPS.AD_ZD_TABLE", line 1035
ORA-06512: "APPS.AD_ZD",line 118
ORA-06512: "SYS.DBMS_SQL",line 1199
ORA-06512: "APPS.AD_ZD",line 91
ORA-06512: "APPS.AD_ZD_TABLE",line 37
ORA-06512: "APPS.AD_ZD_TABLE",line 1021
ORA-06512: "APPS.AD_ZD_TABLE",line 1154
ORA-06512: line 1

 

 

Changes

 

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!


In this Document
Symptoms
Changes
Cause
Solution
References


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