apex database question

Posted on 2008-10-29
Medium Priority
Last Modified: 2012-05-05
we have a apex page that uses a popup.  The popup works fine and refreshes the calling page.  however after the popup closes and we go to submit or choose another item on the page, the page closes and goes back to the login page.  Any clue as to why this would happen.  this only appears to happen on IE 7
Question by:BillyH-1
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 4
LVL 20

Expert Comment

ID: 22840066
How does the popup refresh the calling page? If you use a link, are you passing :APP_SESSION ? Or do you have an AFTER SUBMIT branch on the initial page that redirects to the login page?

You might want to post a sample app on apex.oracle.com or at least some code here...

Author Comment

ID: 22840375
The popup (change or add date:etc) all works until you click on Submit changes and redirects to the login page. I have found that this only happens with IE7. When I use with IE6 the problem is not happening.
I also should have posted that we are running this on Tablet pc 2005 edition of Windows xp on Panasonic Toughbooks.
The After Submit button works fine as long as there is no popup window data entered.
LVL 20

Expert Comment

ID: 22840548
i'm a little bit confused about the actual flow:
- page A launches popup
- popup refreshes calling page (how?)
- popup closes, then any further action on the calling page redirects to login
Is this right? Are you launching the popup via a button, something like this:

Button: redirect to URL
URL: javascript:popupURL('f?p=&APP_ID.:<your_page_id>:&SESSION.:::::')

If not, then how?

Where is the submit button? On the popup?
You haven't answered a couple of my questions: how does the popup refresh the calling page? And are you passing the session ID in your link(s)?

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!


Author Comment

ID: 22840940
The popup is generated by a datepicker on page A.  All the code to handle this is built-in by Apex.  The code behind the Submit button on page A is generated by Apex as well.  It is a "save" operation to the XE database.  I do not explicitly pass a session link as I am utilizing the Apex built-in choices.  
LVL 20

Accepted Solution

gatorvip earned 2000 total points
ID: 22841616
Again you are not answering this question: how does the popup refresh the calling page? The default action for the datepicker is to close the popup window and to populate the text field with the date/time selected, it doesn't do anything else.

Do you have any branches that already exist on the calling page (under the Page Processing section)? If yes, do you have one that goes to your login page?

My suspicion is that your session id is not being passed but there's no way to be sure without seeing an actual example. One way to test this is by checking the ID in both IE6 and IE7, before submit and after.

Another thing you can do is to create a brand new page. Drop a date picker on it as well as a submit button that redirects to another page in your app. See if the same issue occurs in that case.


Author Comment

ID: 22842286
To your paragraph 1, as to your question, your statement is correct.It populates the text fields with date/time and closes popup window. then when you click anythwhere else (Submit data or any other text box) it returns you to the login screen.

To your paragraph 2, I don't think there are any branches, but I will have to check.  I did not write the code.

To your paragraph 3, If the session id is not being passed, it is a bug in Apex.  It workins in IE6 and IE7 on my XP  Pro PC, but not on the tablet PCs using IE7.  But after being down graded to IE6, the tablets work as well.

To paragraph 4, we have tested the behavior after changing the definition of the trip date from a date picker to a text and the behavior clears up.  As we have said, it ONLY happens after a pop up has been  invoked.
I am not sure about the session ID.  I do not see it being shown on the address bar in the popup either on IE7 or IE6.  I did see some documentation about this possibly being the issue.  I am beginning to wonder if this is a issue with the IE7 specifically on these Win XP tablet PC versions.  I am going to try to reload IE7 and see that helps.

Author Comment

ID: 22894092
Resolved by using Internet Explorer 6 instead of IE7.
LVL 20

Assisted Solution

gatorvip earned 2000 total points
ID: 22894569
That is not really a solution but rather a workaround. I am unable to duplicate this issue on my end.

File a bug report at metalink.oracle.com if you have access to it, or post this in the APEX forum at http://forums.oracle.com/forums/forum.jspa?forumID=137 to see if anyone else is having this problem.

Author Closing Comment

ID: 31511420
Thanks for the help.

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.
Suggested Courses

801 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question