Oracle Apex 19.2 Session Sharing not working

Question

I have a bunch of apps e.g. App1, App2 ,App3 and so on. Each app is independent from others but all of them use the LDAPS authentication scheme so the "account" used to login is the same.

I set up a db table (tblUserApps) in which I match each app with the users that is allowed to use it and join with the apex view apex_applications. I modify the value of home_link field (f?p=&APP_ID.:1:&SESSION.) replacing the &APP_ID. part with the appID in tblUserApps.

The link in apex page is like this:

User | AppID ---> home_link used in apex
------------
UsrA | 101   ---> f?p=101:1:&SESSION.
UsrA | 102   ---> f?p=102:1:&SESSION.
UsrB | 101   ---> f?p=101:1:&SESSION.
UsrB | 103   ---> f?p=103:1:&SESSION.
UsrC | 102   ---> f?p=102:1:&SESSION.
...  | ...

For each app in apex I set the auth scheme with the same cookie name for custom session sharing but every app I access requests the login.

I found a solution here but after setting the same cookie name for each app the login page is shown every time I try to pass to a different app.

1) What do you mean by "lists all the applications enabled for a logged user"? You control which apps share sessions as the developer. Just show a list of apps, no? 2) What do you mean by "after setting the same name for each app"? Do you mean the Cookie Name? — Dan McGhan
@DanMcGhan : your questions are correct so I rewrite my post in a (I hope) clear way — AlexMI
How did you configure the link in the "app directory" app to the other apps? Are you passing the session id, that's necessary? — Dan McGhan
@DanMcGhan : I join the apex_applications view and "build" the URL passing the session — AlexMI
If you'd like to meet online so that I can see the app and offer suggestions, please DM me on Twitter (twitter.com/dmcghan) or contact me via my blog (jsao.io/contact). If you do reach out, please include the URL to this Stack Overflow question. — Dan McGhan

AlexMI AlexMI · Accepted Answer · 2020-06-03T10:21:05

Due to the comments received I realized that I was missing something obvious, and it was just like that.

The configuration of auth scheme is correct as described in grassroot-oracle post. The error was in the way I build the applications home_link.

I build the URL not in Apex but in db (view) and I use the syntax &SESSION. that result in a string and the final URL was exactly f?p=101:1:&SESSION. Using the syntax V('SESSION') the final url becomes f?p=101:1:123456789 and all wark correctly as expected.

Useful links:

Understanding URL Syntax

Referencing Session State

Oracle Apex 19.2 Session Sharing not working

1 Answers