MattsBits
MattsBits

MattsBits

Oracle APEX Error ERR-7620 Caused by Application Alias  

by Matt Hawkins, 21/09/2011
Categories : APEX

I was using an Oracle APEX application recently and got this error message :

Expecting p_company or wwv_flow_company cookie to contain security group id of application owner.
Error ERR-7620 Could not determine workspace for application ().


The application had been working fine and it puzzled me why the link wasn't working. A direct link to the application worked but when using an alias in the URL it failed.

If I changed the alias the error went away ... but I didn't want to change the alias because it meant I would have to find all the links that used it. Which sort of defeats the point of using an alias in the first place!

The solution was to find out if any other applications were using the same alias. So I ran the following query against the main APEX tables in my FLOWS schema :

SELECT * FROM
      (SELECT COUNT(ALIAS) "COUNT",ALIAS FROM APEX_APPLICATIONS GROUP BY ALIAS)
 WHERE COUNT>1 ORDER BY COUNT DESC;


This highlighted another application in a different workspace that was using the same application alias.

An Oracle developer had cloned my application for development purposes and it ended up with the same alias as the live application. Once I changed the alias in the copy my application links started working again!

Author : Matt Hawkins  Last Edit By : Matt Hawkins
PHP Powered  MySQL Powered  Valid XHTML 1.0  Valid CSS  Firefox - Take Back The Web  EUKHost - Recommended Webhosting Solutions

MattHawkins CMS v3.0 - Copyright 2009-2017