My Oracle Support Banner

Installing APEX on a 12.1 DB Get: ORA-64610: bad depth indicator & ORA-20001: WWV_FLOW_API.SGID_NOT_SET (Doc ID 2577831.1)

Last updated on NOVEMBER 09, 2019

Applies to:

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

Symptoms

Environment

 APEX 5.1+

Database (DB) 12.1+


When attempting to install a certified APEX version on a 12c DB
the following error occurs.

ERROR
-----------------------
begin
*
ERROR at line 1:
ORA-64610: bad depth indicator
ORA-06512: at "SYS.UTL_CALL_STACK", line 99
ORA-06512: at "APEX_180200.WWV_FLOW_SECURITY", line 4250
ORA-06512: at "APEX_180200.WWV_FLOW_API", line 29052
ORA-06512: at line 2


APPLICATION 4411 - Oracle APEX  System Messages and Native Types
--application/delete_application
begin
*
ERROR at line 1:
ORA-20001: WWV_FLOW_API.SGID_NOT_SET                                      <-- same report repeats multiple times for each application
ORA-06512: at "APEX_180200.WWV_FLOW_API", line 1812
ORA-06512: at "APEX_180200.WWV_FLOW_API", line 1847
ORA-06512: at "APEX_180200.WWV_FLOW_API", line 3303
ORA-06512: at line 2



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Install APEX 5.1 using apexins script
2. Check the log for errors


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
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.