My Oracle Support Banner

Installing APEX on 12.2c Migrated DB get error: 'IDENTITY_ COLUMN' Must Be Declaraded (Doc ID 2503515.1)

Last updated on FEBRUARY 18, 2021

Applies to:

Oracle Application Express (APEX) - Version 5.1 to 18.2.0.00.12
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.

Symptoms


When attempting to Install APEX (5.1,18.1 or 18.2)  on a 12.2 Standard migrated DB
the following error occurs for several procedures

ERROR
-----------------------
ORA-00904: "IDENTITY_COLUMN":  invalid identifier


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

  1. Upgrade the database from 11g to 12c
    2. Install APEX
    3. Several procedures fail compile due to "Identity_Column" not declared
        i.e WWV_FLOW_CREATE_MODEL_APP, Line 4450 , APEX_180200.WWV_FLOW_DML, Line 221/1, APEX_180100.WWV_FLOW_CREATE_MODEL_APP

Changes

 The Database was upgraded from 11g to 12.2c

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


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