Something must not be formed correctly in your SQL for the FullCalendar Region Source.
Could you post the full SQL you're using?
I would recommend your URL column look like this:
, 'f?p=' || :APP_ID || ':7:' || :APP_SESSION || '::::P7_MISSION_ID:'||MISSION_ID as url
I'm using bind variables instead of substitution strings. That wouldn't explain the behavior you're explaining, but I just like that approach much better in SQL.
Thanks for your response. I figured out what I did. The SQL was not the problem. I have two ways to connect to this application. First: EBG (Embedded Gate Way). Second: Through APEX listener on a Weblogic server. I was coming in using the Weblogic server but the url in the SQL string was using the EBG. That's why I was prompted to login again and the Session ID was changed. From there I was able to continue working.
Now, the question I have is there a way I can get the current url (like: APP_SESSION) and put it in the SQL string that creates the url.
Well that was strange. Why would you do that?... but that's a rhetorical question for a different time...
Build the string as I suggested and your application WILL use the current APP_SESSION and it will remain connected to whatever server you are using (EPG or APEX Listener). All you need to do is start your URL form the f?= forward.