How to configure Single Sign-on for Apex 4.0.2 websheet application?
We have in our environment :
Apex 4.0.2 configured with APEX Listener
In schema APEX_040000:
Logged in SSO server administration console > Administer Partner Applications > Add Partner Application
I have noted the :
Site ID, Site TOKEN, Encryption Key, SSO URL (login and logout)
Went back to APEX_040000:
grant execute on wwv_flow_custom_auth_sso to apex_public_user;
grant execute on wwv_flow_custom_auth_sso to anonymous;
alter package wwv_flow_custom_auth_sso compile body;
create public synonym wwv_flow_custom_auth_sso for apex_040000.wwv_flow_custom_auth_sso;
grant execute on wwv_flow_custom_auth_sso to APEX_PUBLIC_USER;
Logged in APEX 4.0.2 and created a database application. I have changed the current authentication scheme for the one "Based on authentication scheme from gallery:Oracle Application Server Single Sign-On (Application Express as Partner Application)"
I have then tried creating a websheet application. Under Properties > Authentication > chose Single Sign-On. Before applying the changes, APEX had me create an ACL.
When accessing the database application, SSO works fine. With the websheet application, I get the following error:
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 (100).
I get the same message with Firefox too...
Did I miss a step ? I have tried looking for a complete Oracle documentation on how to properly implement SSO for a websheet application in APEX 4.0 but couldn't find any...
Any help would be really appreciated!