Application Express :: Authenticating With Multiple Domains
Sep 11, 2013We are using APEX 4.1.1 with an LDAP authentication scheme. We now have a requirement to authenticate users from two different domains.
View 1 Replies
ADVERTISEMENT
Application Express :: Multiple Application Setup Using Session Sharing Within Workspace
Jan 24, 2013I 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?
Application Express :: Translate Application Into Multiple Language
Dec 20, 2012I 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 RelatedApplication Express :: Process Inserting Multiple Row
Feb 22, 2013I have a process on my page which inserting some tables. one table may have more than one row. say
id1, id2, attr1, desc
1 1001, 1, abc
2, 1001, 4, xyz
3, 1001, 5, hhh
so on. id2 is a fk key in this table. for same id2 it may have more than one row. I have process and following is part of it but getting error that is PLS-00224: object 'P30_QUES' must be of type function or array to be used this way .
declare
v_count number;
v_code number;
begin
select count(*) into vv_count from table1; -- it may have 7 or 8 questions
FOR i IN 1 .. v_count LOOP
select code into v_code from table1 where code = :p30_ques(i);
if :p30_ques(i) is not null then
INSERT INTO table2 (id1, id2, attr1, desc)
values (null,fk_value, v_code,nvl(:p30_ques(i),null));
end if;
commit;
end loop;
end;
Application Express :: Fetch Multiple Value Using Ajax
Aug 17, 2012i am using apex4.1 and i am trying to fetch multiple value using Ajax code.i am using the following link
[URL]....
NOthis is based on select list . when i choose particular value in select list corresponding values are displayed in items.
my select list is too long. so i replace select list with pop lov of values item then this code do not work. what changes i have to do so that this code work.
Application Express :: How To Create Multiple PDF Files
Jan 12, 2013I have two tables, one with the customer address and another one with a note. May I know how to create a separate PDF file (for each customer) that should start with the customer name/address (from customer table) and followed by a note (from the note table)
View 35 Replies View RelatedApplication Express :: Chart With Multiple Y-axis?
Mar 28, 2013I am using the build-in flash Apex chart which I understand to be a subset of the Anychart.
I have the following problem, I have two series, which I am displaying in a 3D Bar Chart on a horizontal view with two Y-Axis. This works well, the problem is that each Y -Axis has a different scale. I am not setting the min or max value range for either of the y-axis as I do not know what this value range may be at the time of rendering the chart to the application user.
So as it turns out, the left y-axis has a value range from zero to 100 and the right y-axis has a value range from zero to 50 and the application users are finding this difficult and confusing as they are only looking at the bars represented in the chart and assuming that as the two bars, i.e. one form each series look similar in size, they have the same value and this can not be further from the true, as one y-axis is showing a value range twice as big as the other y-axis.
So my question is how do you customise the chart so that the value range on both y-axis is the same. i.e., the largest of the two?
Application Express :: Oracle Apex 5 SOD - Multiple Regions
May 24, 2013In Oracle Apex 5 SOD it says it will have the following feature:
"New Multi-Row Edit Region Type – Define a new region type with a modern UI for updating multiple rows of data and allow multiple regions on one page"
[URL].......
If so, how likely it will allow dynamic query (PL/SQL) in addition to simple query? Also, how likely it will include advanced features like frozen columns with group headers, subgrid, etc.? It will be nice if the grid will adjust itself based on the width of the screen.
Application Express :: Retrieve All Data From One Multiple Checkbox To Another?
Jul 11, 2012How do you retrieve all data from one multiple checkbox to another? The method I'm using returns one choice even though multiple have been chosen.
View 2 Replies View RelatedApplication Express :: Multiple Overlapping Series In Charts
Oct 11, 2012whether the overlapping Multiple series charts are possible in Oracle APEX or not .
I am trying to create two graphs for two data sets , one as marker and another as line , but its giving me issues such as
1) X axis is taking all the points of the first series suppose(
1,5,10,180) itsplotting these first . and its then starting labeling
the x-axis for another one which has values like
(20,50,100,1000,15000)
so my X-axis is now ---> 1,5,10,180, 20,50,100,10000,150000
In case i make my marker chart series as the 2nd sequence , then its drawing all the markers on the right side of the chart .
[URL].........
Workspace:- NR_WORKSPACE
Username:-user1
password:- H123$
whether this thing is achievable in oracle apex or not , is there any work around ?
Application Express :: Creating Tree With Multiple Tables?
Jun 20, 2012I want to do a tree view based on the following tables in APEX:
create table plattform (
id number,
name varchar2(200))
create table environment (
id number,
plattform_id number,
name varchar2(200))
[code].....
Application Express :: Report With Multiple Values For A Single Parameter
Oct 4, 2012I have a user requirement where they want to be able to select multiple values for a single parameter that will act as a filter for a report. The possible values for a parameter can come from almost any master data Oracle eBusiness table. I don't want to just present the user with a LOV where they search down a list selecting what they want. That wouldn't be very practical for selecting part numbers from 1000's of rows. I also want the user to easily see what values they have selected. I thought about providing a button that would navigate to a multi-row form where they could record their values and use those values in the where clause of the SQL for the report, but that is a somewhat complex solution I have never tried before. how to do this. I'm working in the latest version 4 of APEX.
View 1 Replies View RelatedApplication Express :: How To Order X-axis In Multiple Series Chart
Aug 17, 2012I am using apex 4.1, i created a chart with 4 series in each series i am calculating sum of the no.of students joining in different classes of a institute for every year.
example my table is like this
date_of_join class student_id
'07/22/2012' 8 1
'07/22/2011' 8 2
'07/22/2009' 8 3
'07/22/2012' 7 4
'07/22/2010' 7 5
'07/22/2011' 6 6i wrote query like
series1
select null as link,UNISTR('�0A0') || to_char(date_of_join,'YYYY'),count(student_id) "class 8" from stdent_record where class=8 group by to_char(date_of_join,'YYYY') order by to_char(date_of_join,'YYYY')
series2
select null as link,UNISTR('�0A0') || to_char(date_of_join,'YYYY'),count(student_id) "class 7" from stdent_record where class=8 group by to_char(date_of_join,'YYYY') order by to_char(date_of_join,'YYYY')but what happened is the x-axis is coming in order like
2009 2011 2012 2010because the series1 no student is joined in 2010 so its taking the series1 order but i need the years in normal order.
Application Express :: Get Nested Case Statement To Evaluate One Result / Instead Of Multiple?
Mar 26, 2013OK, Now that the syntax has been corrected with "Chanchal Wankhade" I have an entirely new issue. I am sure this issue has to do with my case statement logic. I am getting multiple rows, when I am only looking for one. Here is my code:
SELECT
CASE
WHEN EP.PHYSICAL_DATE IS NULL
THEN
CASE
WHEN EC.ORIGINAL_CONTRACT_START < ((SYSDATE) - 365)
THEN 'NEEDS PHYSICAL'
[code].....
However, only one of these rows should be the output, which is "No". How do you get a nested case statement to evaluate to one result, instead of multiple? I'm quite sure it is in the logic. To spell it out, this is what I am trying to accomplish with the above code: If the "EP.PHYSICAL_DATE" is null, then use these sets of formula's to evaluate the output, BUT if the "EP.PHYSICAL_DATE" is not null, then use these set's of formula's to evaluate the output.
As it stands now, it appears as if my nested case statement is doing exactly what I told it to do, which is to evaluate both conditions, and output both.
Application Express :: Displaying Multiple Values In Auto-complete Item
Aug 15, 2013I am creating multiple entries for auto populate item as shown in this jquery plugin link below but i am trying to change this so values come from table query. how can i achieve this even using web services in apex 4.1.1 but i am trying NOT to use remote url or external file?
[URL]......
Application Express :: Removing Text Messages Using Wwv_flow_api Or Multiple Delete Function?
Oct 8, 2012I am currently using APEX 4.1 on oracle 11g XE.
By now I only know one way to delete text messages (globalization) and that is click them one-by-one and hitting the delete button.
To delete 100 messages this is really a pain, so I thought, there must be a way to multi-delete them, or just flush them out!
I searched all over the internet but I can't seem to find a way.
Is there a way to delete all text messages? For example by using wwv_flow_api or any other way?
Application Express :: Separate Link For Each Series On Multiple Series Bar Chart From One Query
May 13, 2013I have a query that selects multiple series for a bar chart (I have defined only one chart series, and have 3 columns selected to represent 3 series). The series display on Bar Chart is fine. Now I want to create a separate link target depending on which series is clicked on the chart. I am not able to do this.
View 1 Replies View RelatedSecurity :: Authenticating Oracle User Based On Windows User ID?
Mar 11, 2011We are trying to implement the following security to our database.
As of now, the access rights are same for all the windows users logging into the Oracle application with the same Oracle user Id.
But now, we want to improve our security by granting different levels of rights to the users based on their Network Id even though they use the same Oracle User Id to log into the application.
We are not looking for the users to be identified externally.
(CREATE USER "OPS$ORACLE-BASE.COMTIM_HALL" IDENTIFIED EXTERNALLY;
GRANT CONNECT TO "OPS$ORACLE-BASE.COMTIM_HALL";
)
Application Express :: Pass Header Variable From OAM To Apex And Read It In Application?
Mar 4, 2013We have integrated Oracle Access Manager 11gR1 with Oracle Apex 4.1. The OAM-Apex integration is working fine. Now we want an additional header variable to be passed from OAM to the Apex application. This new header variable will be user's sAMAccountName in Active Directory. OAM is integrated with AD and the AD users are successfully able to access the Apex applications.
The three header variables which are configure in OAM right now are:
Header variable name Value
1. OAM_REMOTE_USER $user.userid
2. OAM_REMOTE_USER_EMAIL $user.attr.mail
3. OAM_REMOTE_USER_GROUPS $user.groups
We need an additional header variable as mentioned below:
Header variable name: OAM_SAMACCOUNTNAME
Value: $user.attr.samaccountname
The new header variable was added in the OHS server's dads.conf file like shown below:
=========== dads.conf =============
...
PlsqlCGIEnvironmentList HTTP_OAM_REMOTE_USER
PlsqlCGIEnvironmentList HTTP_OAM_REMOTE_USER_GROUPS
PlsqlCGIEnvironmentList HTTP_OAM_REMOTE_USER_EMAIL
PlsqlCGIEnvironmentList HTTP_OAM_SAMACCOUNTNAME
But we are not able to read the value of this attribute in the Apex application.On the Apex application, we have a text box which shows the value of this header variable. This textbox is attached with the following stored procedure call to fetch the header variable:
===================
begin
:P1_HEADER_VALUE := owa_util.get_cgi_env( 'HTTP_OAM_SAMACCOUNTNAME' );
end;
The textbox shows the correct value if HTTP_OAM_REMOTE_USER is passed to the get_cgi_env method but does not shows anything when HTTP_OAM_SAMACCOUNTNAME is passed to the same method. if I am missing some configuration to pass the HTTP_OAM_SAMACCOUNTNAME haeder variable from OAM to Apex.
Application Express :: Get Checked Options Values Via Application Global Arrays?
Apr 26, 2013how to use checkbox item, and trying to get checked options values via application global arrays. So, this may be quite simple question, but I'm completely stuck here...
When I was looking through various threads and guides, I've encountered checkbox corresponding array names like "g_f01" - "g_f50". And so far i saw that these names are derived from item name in generated HTML code, for example:
<input type="checkbox" name="*f10*" value="3" />
And this one stands for array name "g_*f10*".However, when I tried to do the same thing - i receive item name which looks like "*p_v04*", and therefore, I can't figure out, which array name should I choose to adress it properly.
My generated HTML snippet:
<input type="checkbox" id="P6_ANSWER_0" name="*p_v04*" value="3"/>
Application Express :: Display List Of All Users On Page / Accessing Or Using Application
Mar 23, 2013i want to display a list of all users on a page those currently accessing or using the application. How do i accomplish this requirement?
View 1 Replies View RelatedApplication Express :: Login Error 7621 - Determine Workspace For Application?
Jul 5, 2013APEX 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??
Application Express :: ORA-02291 / Constraint Wwv_flows_fk Violated While Application Import
Nov 4, 2013Each time when I import an application into my workspace in local 10g XE using the APEX 4.2 Application Builder, I get the "ORA-02291, constraint wwv_flows_fk violated..". The application I whant to import was originally exported from [URL]. I found out, that it has to to with wwv_flow_application_install.get_workspace_id in the installation script, which obviously returns NULL and not my current workspace id as I suppose it should. I replaced wwv_flow_application_install.get_workspace_id by '<my worskspace id>' and then the import does work.
View 0 Replies View RelatedApplication Express :: Application Locking - Force Logout All Current Users And Prevent Login
Jun 12, 2012I have an application that I'd like to prevent activity in after a certain time of day, say 3pm. Is there any way I can force logout of all current users and then prevent re-login until 9am the next day (short of deleting all of their login credentials and then recreating them the next morning)?
View 7 Replies View RelatedApplication Express :: How To Protect Oracle Application From Code Edit On Client Side Installation
Sep 12, 2013We have developed an application for our clients,planning to deploy it in client server soon. we have plans to support the application in future,so we want to restrict the clients from any modifications. By Doubt is, 'build_status=Run only' alone,cannot protect our application from client developers to edit our application,
Because though we install our application as 'Run Only' at the time of installation in client instance,we can still import the original application and change the type to 'Build and Run Application',and run the new application as 'Build and Run'.(which is not supposed to) we want to make sure,if there is any way we can protect our application from modifications after client side installation.
Application Express :: Obtaining Custom HTTP GET / POST Parameters Of Variable Length In Application Process
Sep 5, 2013I'm trying to connect a javascript UI control within my page to an APEX Application Process. The control calls the application process via AJAX and appends a variable number of GET / POST parameters to its URL.What is the best way to obtain these parameters from within the PLSQL procedure of the process? Or is there a better way to connect my javascript AJAX control to the Database behind my APEX app?
View 4 Replies View RelatedApplication Express :: Tree View On Application Builder Not Showing
Jul 16, 2012I have some applications on Apex public workspace (apex.oracle.com), and suddenly the Tree View, on Application Builder stopped showing any content. If I select "Component View", I see the page components, but if I switch to tree view, it shows me only some empty frames.
View 2 Replies View RelatedApplication Express :: JSON Error When Trying To Redirect To Another Page In Same Application?
Jul 23, 2013I'm trying to set up a PL/SQL dynamic action that is triggered by clicking on a button. The dynamic action sets two values in a table and then I would like to redirect to another page. Setting the values works fine. The code is below:
declarel_information varchar2(255) := :P94_FILENAME;BEGINcommit;UPDATE VDI_METADATASET CREATEUSERLISTNAME = l_information, CREATEUSERLISTON = sysdate();commit;htp.init;owa_util.redirect_url('f?p=&APP_ID.:81:&APP_SESSION.::NO:::');END; The redirect fails with the following eror: "Error: parseerror: JSON.parse: unexpected non-whitespace character after JSON data"
how to redirect to a page from within PL/SQL . None of them result in success.
Application Express :: 4.2.0.00.27 Mobile Themes - Add Virtual Keyboard To Application?
Feb 12, 2013I'm doing a small application in Apex 4.2.0.00.27 mobile themes.
Application is used to search for books.Will work on a PC Windows with touchscreen.
How do I add a virtual keyboard to my application?
Application Express :: Error Importing Existing Application Into Production?
Aug 6, 2012version 4.0.2.00.07
I had an error importing an application into Production that was exported from Development. The application exists and I was trying to replace it.
The error I received was:
ORA-20001: GET_BLOCK Error. ORA-20001: Execution of the statement was unsuccessful.
ORA-20001: Error creating dynamic action sub-action name="NATIVE_JAVASCRIPT_CODE" id="9503820976918886"
ORA-02291: integrity constraint (APEX_040000.WWV_FLOW_PAGE_DA_A_AR_FK) violated - parent key not found<pre>
begin wwv_flow_api.create_page_da_event ( p_id => 9504132415918888 + wwv_flow_api.g_id_offset ,p_flow_id => wwv_flow.g_flow_id ,p_page_id =>I
opened the SQL that was created from the export utility and this is where it errored:
begin
wwv_flow_api.create_page_da_event (
p_id => 9503820976918886 + wwv_flow_api.g_id_offset
,p_flow_id => wwv_flow.g_flow_id
,p_page_id => 6
,p_name => 'Add tooltip to Numeric filter operators'
,p_event_sequence => 40
[code]....
Unless I'm not understanding this error it means that it can find the ACTION part that is attached to the WHAT part of this Dynamic Action? The Dynamic Action does work when the application is run (in Development)also, there are 3 others that are similar to this one. The export was created by the export utility in the Application Builder.
If I export only the page and import that into Production the import is successful and the page runs correctly. This is error is happening only when I try to import the entire Application.There are many other changes made which is why I was trying to do an Application export/import instead of individual pages.