APEX

Hi,

We are facing issues after getting our APEX application registered with SSO.
When I send the request for my apex application from browser, it shows the message 'Redirecting it to the login Server for authentication...' and then it throws 500 Internal server error.

I don't see any error message logged in the error log. ($ORACLE_HOME/Apache/Apache/logs). Please let me know if I have missed something and how should I go about solving this.
Here are the steps we followed for the configuration:

Data base version: 11.1.0.6.0
Oracle AS version: 10.1.3.1
APEX version : 3.0.1

Step 1. Creating partner application

Here are the details we got after getting the Application registered as Partner application.

Site ID: 1C5BF6A3
Site Token: DV7U0Z5Y1C5BF6A3
Encryption Key: D9391B85DE6EFB5C
Single Sign-On URL: https://login-stage.oracle.com/pls/orasso/orasso.wwsso_app_admin.ls_login
Single Sign-Off URL: https://login-stage.oracle.com/pls/orasso/orasso.wwsso_app_admin.ls_logout

Here is the request send for getting our application registered as partner application:

Partner Application Request Form
*********************
SR Number: 14200701
Helpdesk: This is an auto-generated ticket.
Requestor: anas.x.perwez
Instance: stage
Protocol: https
Application Name: BPO
Application Home URL: https://techbpo-stage.oracle.com:4443/pls/apex
Application Success URL: https://techbpo-stage.oracle.com:4443/osso_login_success
Application Logout URL: https://techbpo-stage.oracle.com:4443/osso_logout_success
Administrator Email: pooja.sharma@oracle.com


Step 2. Installing sdk. I got the ssosdk902.zip from Oracle AS -10.1.2.0.1, since the zip is missing from Oracle AS 10.1.3.1
*2.1* Logged into the database as FLOWS_030100
*2.2* Executed loadsdk.sql present in ssosdk902\packages
*2.3* Executed regapp.sql present in the same folder as mentioned in the step above. It prompted for certain parameter:
Enter value for listener_token: HTML_DB:stbp3.oracle.com:4443
Enter value for site_id:1C5BF6A3
Enter value for site_token:DV7U0Z5Y1C5BF6A3
Enter value for login_url: https://login-stage.oracle.com/pls/orasso/orasso.wwsso_app_admin.ls_login
Enter value for encryption_key: D9391B85DE6EFB5C
Enter value for ip_check: N
*2.4* Executed custom_auth_sso_902.sql and custom_auth_sso_902.plb from APEX distribution directory “core”
*2.5* Executed this command: grant execute on wwv_flow_custom_auth_sso to APEX_PUBLIC_USER;
Step 3. Configured Authentication scheme for my APEX application as SSO



Regards,
Pooja