My Oracle Support Banner

ORA-00942: Table or View Does Not Exist ORA-06512: at "APEX_180100.WWV_FLOW_DYNAMIC_EXEC" When Trying To Create A New Application with New Feature "Activity Reporting" Selected (Doc ID 2433050.1)

Last updated on FEBRUARY 03, 2022

Applies to:

Oracle Application Express (APEX) - Version and later
Information in this document applies to any platform.


On : APEX version,

When attempting to create a new application  IF Check ALL is clicked to include ALL Features or only "Activity Reporting"
the following error occurs.

1 error has occurred
ORA-00942: table or view does not exist ORA-06512: at "APEX_180100.WWV_FLOW_DYNAMIC_EXEC", line 843 ORA-06512: at "APEX_180100.WWV_FLOW_DYNAMIC_EXEC", line 897 ORA-06512: at "APEX_180100.WWV_FLOW_WIZARD_API", line 2442 ORA-06512: at "APEX_180100.WWV_FLOW_WIZARD_API", line 14169 ORA-06512: at "APEX_180100.WWV_FLOW_CREATE_APP_V3", line 1319 ORA-06512: at "APEX_180100.WWV_FLOW_APP_FEATURE_V3", line 2032 ORA-06512: at "APEX_180100.WWV_FLOW_APP_FEATURE_V3", line 2714 ORA-06512: at "APEX_180100.WWV_FLOW_APP_FEATURE_V3", line 5659 ORA-06512: at "APEX_180100.WWV_FLOW_CREATE_APP_V3", line 5291 ORA-06512: at line 37

1.  Create a new application in APEX 18.1.
2.  Click "Check ALL" to include ALL Features or even only "Activity Reporting". after have provided the application name.
3.  The error is returned.


New Installation/Upgrade of/to APEX 18.1.


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

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