Application Express :: Multiple Application Setup Using Session Sharing Within Workspace
Jan 24, 2013
I have multiple application set-up using session sharing within the workspace.Technically all works fine, however it does not play nice with user behaviour.
Example:
Users logs into APP_ID:100. Since he isn't authenticated yet, he provides user/pass and the APP_SESSION is authenticated.
Now if the user switches using to another application (using a link provided in application 100) he gets redirect to APP_ID:101:APP_SESSION all is fine.
The session is already authenticated, the application shares the session and the user gains access to app 101 without having to authenticate again. All's fine!
However users don't behave they way. Instead of using an easy link in the application. They will use their own bookmark or type in the url for app 101 manually. That way the next application is either called with f?p=101:1:[SOME OLD SESSIONID FROM BOOMARK] or f?p=101 (with no further page or session info) In both cases instead of using the already authenticated session apex spawns a new session, which of course isn't authenticated yet thus forcing the user to authenticate and come complaining they have to login again.
Similar behaviour problems exists when the user opens a browser and tries to open both applications in each in a tab next to each other.Both tabs fetch there own initial session id and start writing it to the same cookie each in turn invalidating the other tab's session.These can lead to some fanatic ping pong actions. Thus it's impossible to open 2 applications sharing session in the same browser.
Is there any remedy for these situations?Can apex be as smart as for instance first trying to resume the session stored in the cookie and only if that session is invalid, start a new session?
View 2 Replies
ADVERTISEMENT
Jun 6, 2012
APEX 4.0.2.00.07
Oracle 10.1.2.0.0
I have 2 workspaces, the one regard as Dev env, another regard as Pro. env. When the change need to be migrated, the some page of Dev workspace should be copy to Pro. one. I export the pages what I want to move from Dev., then try to import it into Pro. but I get the error as below:
Page Origin: This page was exported from a different application or from an application in different workspace. Page cannot be installed in this application. I don't want to copy the page one by one.
View 16 Replies
View Related
Jul 5, 2013
APEX 4.0 Sometimes, I am getting the below error when I tried to logging into APEX workspace (after giving workspace name, User name and password), Expecting p_company or wwv_flow_company cookie to contain security group id of application owner.
ErrorERR-7621 Could not determine workspace for application (:) on application accept. I found some threads related to this but in different way not exactly when I am getting this error.
After 2 or 3 times, this error will not come and I can able to logging into workspace What is the cause for this issue??
View 1 Replies
View Related
Oct 12, 2013
What can I do if I want to delete read only application from a workspace?
View 1 Replies
View Related
Jul 3, 2012
There are two applications in the work space. Both the application have a link to navigation back and forth to the each other. have created a DB authentication to both the application.
My Requirement is if user log's into one application and navigate to other it must not ask for username and password
View 3 Replies
View Related
Mar 19, 2013
I am trying to export a workspace from apex 3.2 to apex 4.2. After the workspace has been imported into apex 4.2, do I have to export and import the applications too? Don't applications reside on workspace and therefore if a workspace is imported, all the applications should have been imported by default?
View 3 Replies
View Related
Nov 24, 2012
I need to export my whole workspace/application from Oracle Application Express so if i was to move onto a new pc and install oracle again. I can import this file and everything will be as it was without need of editing anything.
Is this possible if so how? - Preferably export into 1 big file so importing will be with 1 mouse click instead of exporting to seperate database files etc.
View 2 Replies
View Related
Nov 7, 2013
I support an APEX app that has one workspace for Development and one for the live Production application. When I originally created the Dev instance I was able to copy tables and data by granting select privileges between the two workspaces (I did this one table at a time).
The development workspace data needs to be refreshed from production since it's been a long time since the initial refresh and is very out of date. I would like to do a couple things:
1) execute SQL to compare the tables in the two workspaces to ensure they're structurally identical
2) execute SQL to truncate Dev tables and refresh from Prod Is there a way to do this?
View 3 Replies
View Related
Jun 25, 2012
I tried to create my EA workspace for APEX 4.2 and got the following Error.
ORA-20987: APEX - GET_BLOCK Error. - ORA-20001: Execution of the statement was unsuccessful. ORA-01653: unable to extend table APEX_040200.WWV_FLOW_PAGE_PLUGS by 1024 in tablespace APEX_REL42 <pre>declare s varchar2(32767) := null; l_clob clob; l_length number := 1; begin s := null; wwv_flow_api.create_page_plug ( p_id=> 6594522669003504543 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_page_id=> 0, p_plug_name=> 'Menu', p_region_name=&g
View 14 Replies
View Related
Aug 24, 2012
Is there a way to make a button conditional on the existence of another app in the same workspace. What I am trying to do is have a MAIN app and several other MODULE apps in the same workspace. Then a button on a form in the MAIN app that will redirect to a specific page in one of the MODULE apps. If the MODULE app does not exist, meaning not installed, then the button would be invisible.
View 1 Replies
View Related
Apr 17, 2013
Our apex currently has LDAP authentication scheme. We have many applications within the workspace. We are looking for a way to have one authentication scheme defined for all the applications so that user doesn't have to enter username/password for each application. How can I share my LDAP authentication scheme for multiple applications.
View 4 Replies
View Related
Nov 19, 2012
I have an urgent requirement to kill an existing session if a new session starts for the same user. I have been reading lot of blogs and posts on the above topic, but could clearly tell me how to do it.
I thought of putting a process in 101 page when login button is pressed to catch this and kill the old session.
View 7 Replies
View Related
Jul 23, 2013
I would like to change the printing settings in my workspace Instance settings. But, I can't find the "Manage Instance" option mentioned in the tutorials.
View 4 Replies
View Related
Oct 23, 2012
We are using Apex 4.0/Oracle 10gR2/ Hp-Ux, We noticed that there is a process Running in Two Sessions that seems running since 3 Hours using 60% CPU,** 30% given below sql it executes in two Sessions!
declare function x return boolean is begin -- if instr(upper(:F4000_P4651_PLUG_SOURCE),'ORDER BY')>0 then
declare
l_position number := 0;
begin
loop
l_position := instr(upper(:F4000_P4651_PLUG_SOURCE),'ORDER BY ',l_position + 1) ;
exit when instr(upper(:F4000_P4651_PLUG_SOURCE),'ORDER BY ',l_position + 1) = 0 ;
[code]....
View 4 Replies
View Related
Oct 18, 2013
I have created a workspace to use oracle apex, after a while I tried to run a script, the following message has been displayed to me, The script output reached the maximum workspace result size limit. Delete existing results or contact your administrator to increase the maximum workspace result size.
View 3 Replies
View Related
Feb 14, 2013
I have an internal linux server running 11i and APEX4 with HTTP server all apps work perfectly internally I have a server in the DMZ with modplsql configured to link to one of the apps in my internal network The problem I am getting is that although the external web server returns the home page, it does not render properly. as if all the images and styles and templates don't get passed through. (including buttons)
Dropdown lists all work but the dynamic actions on them don't, also the submit function does nothing when pressed.
View 1 Replies
View Related
Jan 8, 2013
I tried my DBA hat today in an effort to set up the Apache FOP to allow users to download interactive reports as PDF. This was working previously - although I'm not sure how since there was no report printing infrastructure set up.We have APEX 4.1.1 using Apache on Windows server 2003.
It started because we saw one of two errors in the generated PDF
ORA-20001: The printing engine could not be reached because either the URL specified is incorrect or a proxy URL needs to be specified.or
ORA-06502: PL/SQL: numeric or value error: character string buffer too smallAs much of the documentation indicates, the first suggests a problem with ACL. I had a little trouble finding documentation stating specifically which acl should be defined for IR PDF printing, but we did ensure the listings in the dba_network_acl* views were current with
[code]...
/I'm still unable to identify where the second error (ORA-06502) is coming up - which is apparently new. So I attempted to deploy the fop.war file using EM, adapting instructions from [URL]...though I think I may have missed a mark since these instructions differ from using the OC4J EM - but I guessed there was fair correlation.
From the EM home on our app server, I created a new OC4J instance called "APEX_Reports"I then went to deploy the fop.war file using "fop" as application name, and "/fop/" as the map to url.
Back in APEX instance management, I set up
Print Server: External (Apache FOP)Protocal: http
Print server address: dev.ouractualdomain.com.au
print server port: 18100
Print server script: /fop/apex_fop.jsp>
I used the same port as that in the EM address. I've also tried variations usinglocalhost8888fop/fop/apex_fop.jsp
The reason for the /fop/fop/ attempt was because I located the jsp file in
C:Ora10gFRShomej2eeAPEX_Reportsapplicationsfopfop
(I've been trying everything)
Other port numbers attempted include those types (JMS,RMI,AJP) listed for the APEX_Reports component.Do we need to restart anything or re-login to APEX before testing modifications?
View 0 Replies
View Related
Dec 20, 2012
I want to translate my application into multiple language,I did this by using translate application option available in shared component.This is working fine for me but ,the messages which is inside PL/SQL procedures are not getting converted.how can I translate those messages.
View 2 Replies
View Related
May 20, 2013
I am getting issue with passing a value in different session.I have pl sql procedure where i am passing value in hyperlink tag to oracle apex page.When i clicked on hyper link value is lost between session. how to send value between different session state.
<a href = "f?p=&APP_ID.:6:'||:app_session||'::P6_BACKUP_TIME:'||radio_value||' ">Select</a>
I have tried that but getting bad bind variable error. I am not understanding this issue.
View 8 Replies
View Related
Feb 18, 2013
I am to trying to fetch session id of a previously submitted process of a search button......so that i can display the search results in a different page.....so is there any sql query or pl/sql procedure to fetch the session id.
View 1 Replies
View Related
Nov 7, 2013
I'm hitting a restriction or security feature(?) of Safari in iOS. One of our Apex applications is a page that runs in an iframe on a site. Apex is installed on a server inside our own network and is accessible via dns: office.ourcorp.com (fake name, just to clarify the situation).
We have a couple of different brands, that all have their own domains: brand1.com, brand2.com etc. All of these sites open the apex page inside an iframe. That all works beautifully in all browsers, except in Safari in iOS. in iOS, the apex page isn't showing. It seams it's because of the session cookie Apex sets. Safari can't set an cookie from another domain (a cross domain cookie). Is there a possibility to turn off the session cookie?(ORA_WWV_APP_xxx)? I also tried to set the 'cookie domain' option inside the authentication scheme to one of the domain names for our brands, but it still doesn't show up.
View 0 Replies
View Related
Jul 17, 2012
I have an application where I use the zero session ID for public users. The problem is, I have a region that contains a report linking to PDF files contained in a BLOB and I use GET_BLOB_FILE_SRC to link to the PDFs. I've included the report in my global content (page 0) and want it to be available to all visitors. The problem is, it only works when a user has authenticated. It throws a PAGE NOT FOUND error for public users.
View 1 Replies
View Related
Dec 6, 2012
I was making some page validation to APEX_ITEM manual tabular form. When every a validation executes it will clear all the data what user enters. What is the best method to hold the session values in APEX_ITEM.
View 4 Replies
View Related
Feb 27, 2013
I need to filter a SQL statement with an application item value retrieved from session state. I am assuming I could do this using a Dynamic Action on a Page Load event but I'm not sure where to go from here. How could I append the filter to an existing report page SQL statement?
View 7 Replies
View Related
Mar 24, 2013
I have some troubles with a "Set Value" Dynamic Action. What I want to do is set a Page Item with a specific variable derived from javascript. So basically I have a javascript variable 'test' that is being changed in javascript code. I am using a dynamic Action "Set Value" to set this value into a page item. As source, Im using "Javascript Expression". It is working, however, the Set Value Dynamic Action with JAvascript expression does not reflect this change in the session, so the page item is not updated.
I tried:
$s -> does not work
apex.submit -> does work, however submits the page. I need to submit only the Page item.
View 3 Replies
View Related
Sep 9, 2013
I have made Horizontal Wizard Progress List over 3 pages.I also made those 3 pages with some simple text fields, checkboxes and so on.On the last page I did the INSERT Process (session variables P100_Date ect).It worked fine! But now I tried a different approach
On each of the 3 pages I made a "Form on a Table or View" and on each pageI hide some of the form. (the advantage of this situation is, that apex gives you a visaul hint about the null fields and so on).But on the last page I cant do the INSERT with the session variables.(I can do the INSERT without session variable, with static values)...
View 5 Replies
View Related
Nov 21, 2012
I have upgraded from APEX 4.1 to 4.2.all read only items with dynamic action are arising below error:
session state protection violation: this may caused by manual alteration of protected item P2_IDACCSET.
View 16 Replies
View Related
Jan 15, 2013
Using apex 4.2. I have created form item on page and item attribute DISABLES IN SETTINGS , set value as YES and SESSION STATE value as YES.
SETTINGS->DISABLES-> SESSION STATE
by doing this i am getting the error. Error is
Session state protection violation: This may be caused by manual alteration of protected page item P98_CHECK_AMOUNT. If you are unsure what caused this error, please contact the application administrator for assistance.
View 8 Replies
View Related
Sep 20, 2013
I have searched for comment on this, but could'n find. So problem is ... not all of the page items are showing in SESSION STATE.
View 4 Replies
View Related
Nov 15, 2012
I am facing this problem, not sure how to solve this. Basically, the default value of the "items" on the page don't get set when the session is cleared and I visit the page for the first time.
So when I check the session for the first time, all page items are null. But when I revisit the page, the page items gets set sometimes.
View 6 Replies
View Related