Solved

apex database question

Posted on 2008-10-29
9
2,213 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
[X]
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
9 Comments
 
LVL 20

Expert Comment

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

Author Comment

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

Expert Comment

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

0
Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

 

Author Comment

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

Accepted Solution

by:
gatorvip earned 500 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.

0
 

Author Comment

by:BillyH-1
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
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
ID: 22894092
Resolved by using Internet Explorer 6 instead of IE7.
0
 
LVL 20

Assisted Solution

by:gatorvip
gatorvip earned 500 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.
0
 

Author Closing Comment

by:BillyH-1
ID: 31511420
Thanks for the help.
0

Featured Post

Technology Partners: 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!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Create file system directory from Oracle 10g 4 46
oracle forms question 22 61
Oracle SQL Developer - SubString 2 51
Age Calculation from specific date 19 58
Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

734 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