Solved

apex database question

Posted on 2008-10-29
9
2,204 Views
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
0
Comment
Question by:BillyH-1
  • 5
  • 4
9 Comments
 
LVL 20

Expert Comment

by:gatorvip
Comment Utility
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...
0
 

Author Comment

by:BillyH-1
Comment Utility
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.
0
 
LVL 20

Expert Comment

by:gatorvip
Comment Utility
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)?

0
 

Author Comment

by:BillyH-1
Comment Utility
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.  
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 20

Accepted Solution

by:
gatorvip earned 500 total points
Comment Utility
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.

0
 

Author Comment

by:BillyH-1
Comment Utility
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
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.
0
 

Author Comment

by:BillyH-1
Comment Utility
Resolved by using Internet Explorer 6 instead of IE7.
0
 
LVL 20

Assisted Solution

by:gatorvip
gatorvip earned 500 total points
Comment Utility
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.
0
 

Author Closing Comment

by:BillyH-1
Comment Utility
Thanks for the help.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.

728 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

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now