Our current APEX setup is APEX 3.0.1 (using DAD file) on a Linux server. Because of browser security issues (unable to generate a certification on apex server) we are in the process up upgrading APEX to 4.2.6 on a Windows server on Oracle 11.2.0.4. I am using Glassfish and APEX Listener and have the server set up to the point that I was able to connect internal and setup a user (myself). I have two schemas associated with APEX - CORE and WEB_SEC. My WEB_SEC schema contains my APEX users/passwords connected with our custom authorization (all of this was set up before my time).
When I imported my authorization application to my new system it imported fine and I can see all the pages in my application. When I run the application I get my LOGIN page but after I enter my username and password I get the following error message:
Error processing authentication
ORA-06550: line 4, column 23: PLS-00201: identifier 'CUSTOM_AUTH_CORE' must be declared ORA-06550:line 4, column 1: PL/SQL: Statement ignored
URL shows https://"servername":8181/ords/wwv_flow.accept
This is my first time posting and am not sure if this is the correct place to post my issues. Thanks for any insight you can provide.