Application Express :: Adding Checksum To URL For Popup Window
Oct 18, 2012
Using Apex 4.1.1
I have button which opens up a pop-up showing a report passing some parameter in URL. The button calls the javascript function defined below:
<script language="JavaScript" type="text/javascript">
function newReport()
{
url = 'f?
[Code]...
It all works well but for security I would like to add checksum to arguments in URL. I had a look at the Javascrpt API for Apex and couldn't find any for creating a checksum I can append to the URL.
Is there one that I missed or is it possible to do it by other means?.
View 2 Replies
ADVERTISEMENT
Aug 20, 2012
today I stepped upon an issue regarding popup windows.I have created an application with popup windows for editing and inserting new records.I left the item label templates to "Optional with Help".When I now click upon an item label the help - popup window appears but it is hidden behind the popup window I am working in.
Is there a workaround for that.Is there a possibility to modify the z-order either of the help popup or of the modal window ?
View 6 Replies
View Related
Sep 3, 2013
I use APEX 4.2.2 and in my page I call a Modal Region to insert a new customer using AIAX and OnDemand PL/SQL process, then I need to set the inserted value into the Popup LOV from javascript. I used the code
:$('dialog').dialog('close');$('P20_CUSTOMER').trigger('apexrefresh');$('P20_CUSTOMER').one('apexafterrefresh', function() { apex.item('P20_CUSTOMER').setValue(ajaxResult, $v('P20_DESCRIPTION'));}
where P20_CUSTOMER is the Popup LOV, ajaxResult is the PK returning from the OnDemand PL/SQL process and P20_DESCRIPTION is an APEX Item of the Modal Region. The new customer is inserted successfully into the table and the PK value returned to javascript code, but the new value is not displayed into the LOV.
View 1 Replies
View Related
Apr 30, 2013
I have an IR report and want to add another column such as complete_date. I want to add as a link so when user click it then should display the popup window or javascript popup for date selection. i don't want to use apex_item.date_popup or apex_item.date_popup2. On date selection popup user can choose only two dates such as yesterday or today all other date should be disabled?
View 2 Replies
View Related
Dec 27, 2012
i am using Apex 3.2,
i am display popup list of value item with out refresh when i select some value from Radio button. But Pop up item lable and element is Hide but in last image of popup list of value does not Hide .
How can i hide this image of popup list of values
i am using
<script>
function Show_On_Radio_Value_2(pThis, pThat, pValue, pLabel){
var rv = html_RadioValue(pThis);
var elm = document.getElementById(pThat);
[Code]...
View 0 Replies
View Related
Aug 23, 2012
this modal popup, it works correctly but not passing values from page page1 to my page3. How do i pass these paramater values to page3,
function modalWin() {
if (window.showModalDialog) {
window.showModalDialog("f?p=&APP_ID.:3:&SESSION.:POP:NO::P3_EMPNO:#P1_CUSTOMER_ID#::","name","dialogWidth:600px;dialogHeight:400px");
[Code].....
View 4 Replies
View Related
Feb 8, 2013
Ive created a tree structure and i want it to popup the called page.select case when connect_by_isleaf = 1 then 0
when level = 1 then 1
else -1
end as status,
level,
'<SPAN style="color:red;">' || "ENAME" || '</SPAN>' as title,
(case when level = 1 then '#IMAGE_PREFIX#Fndtre11.gif'
[code]....
View 6 Replies
View Related
Oct 12, 2012
I am having a problem with a popup lov. When I click on the "popup icon" I can select a supplier and it is stored in the field. But when I leave the form and return later, it shows the return value instead of the display value. For example: you select "supplier A" from the popup list with ID 12. "Supplier A" is shown in the text field, when you save the form, it stores ID 12 in it. But when you return to the form, it fetches ID 12 and shows "12" in the text field instead of "Supplier A".
I tried setting the "source" of the popup lov field as an SQL query, but that didn't work for me.
View 5 Replies
View Related
Apr 11, 2013
APEX 4.1.1.00.23 on 11gR2 - browser independent issue.
We are converting all of our applications to use a standard centralised theme (23). This is fine and seems to work for all templates except for Popup LOV. When you choose the master template it shows as subscribed from within the template detail page, but in the apex_application_templates view and in Shared Components/Templates it is the only item showing as not subscribed.
My guess is simply that the apex_application_templates view does not cover popup LOVs perfectly for some reason but it
View 0 Replies
View Related
Aug 17, 2012
I need to refresh my main page after closing the popup page displayed by skillbuilder plugin
apex 4.1.0/Oracle 11g Ent.
View 9 Replies
View Related
Feb 12, 2013
how to combine APEX 4.2 with jquery mobile componentsOn one page with a hole bunch of components there is also a popup-div<div id="myPopup" data-role="popup">
<!-- close button, safe button, input field and short list... -->
</div>It gets opened with js: $( "#myPopup" ).popup( "open" );
This all works fine, besides the face that it only works after refreshing the page! The page gets loaded via js: $.mobile.changePage('f?p='+ $v('pFlowId') +':20:' + $v('pInstance') { transition:"slide", reloadPage:true });...
which also works fine so far. That same problem I had before when I was using a dialog instead of the popup. - only showing after refreshing the page.
This certainly must have something to do with how JQM loads and renders the page (besides the APEX-job) - a rather basic issue. I have also tried different ways of calling the page, with no difference to that problem.
View 6 Replies
View Related
Jan 3, 2013
Iam facing another issue with Skillbuilder modal page(for those who have used this plugins). Ive the CREATE part working well the problem is with EDIT part to edit records via the link i applied all the steps and clicking the edit link pops up the page but the issue is for any clicked row the parameter is not being passed and seleceted record doesnt show on the pop up page where could the problem be? though if i set it back to normal link created by the wizard the edit link works well and shows that record on the editable page.
Apex 4.1.1/oracle 11gR2 ; issue happens in FF & IE
View 3 Replies
View Related
Jan 31, 2013
I have this Query in a tree page (apex 4.2), but i need open a .pdf file in a new window. It's possible?
select case when connect_by_isleaf = 1 then 0
when level = 1 then 1
else -1
end as status,
level,
[code].......
View 1 Replies
View Related
Jun 5, 2013
How to make an item as a mandatory field dynamically with the change of another item in different regions
View 8 Replies
View Related
Jul 25, 2013
I have a tree region, surrounded by <div>, the height of which is set on page load by a dynamic action so that it is 200px smaller than the window.innerHeight. I have set overflow:auto in the style so that the full free can still be viewed. I now want a dynamic action which fires when the window is resized, which automatically adjusts the size of the region accordingly, so that the region always remains 200px smaller than the innerHeight of the window. I can get the dynamic action to fire by setting the event to resize, however it does not change the size of the region.
View 1 Replies
View Related
Nov 7, 2013
I have an application that I am adding users to as end users. How do I assign them to a particular application? I am using Apex 4.1, Oracle 11g.
View 10 Replies
View Related
Oct 22, 2013
I need to recreate my table in order to change the column order. When I use the SQL Commands window and run the SQL, it runs successfully, creates the new table, but doesn't reorder the columns. Is this expected behavior?
View 2 Replies
View Related
Nov 8, 2013
I have an instruction like this in a pluggin: begin ...
htp.p('<font size="3" color="FireBrick">
Cannot find? Search on </font>' || '<
[URL]....
<font size="4" color="FireBrick"><b>Google</b></a>'); ...
end;
It displys the Google page in another window. How can size the wiindow? For example adding width=200, height=100 to the href tag doesn't work.... Do I need to use JavaSvript?If yes, any example?.
View 1 Replies
View Related
Aug 8, 2012
I am trying to create a report parameter using an lov. You be able to pick one item or return All
The source for my lov is
SELECT l.extkey||' - '||l.longdescr a, l.clocid b
from udm_cloc l, udm_cust c, udm_lde lde
where l.custid = c.custid
and c.ldeid = lde.ldeid
[code].......
But I keep getting an error
'LOV query is invalid, a display and a return value are needed, the column names need to be different. If your query contains an in-line query, the first FROM clause in the SQL statement must not belong to the in-line query.
View 6 Replies
View Related
May 10, 2013
I need to add the calculation of the amount in an invoice line.
I write the item description, the price, the quantity and the tax. Which is the best solution to calculate the total price of the line. I think to add a SQL function after the button “Add line” is clicked.
View 5 Replies
View Related
Jul 16, 2012
Oracle 11g r2, APEX 4.1.1.00.23.
I have some classic reports.
I go to Report Attributes, then I click Add Column Link in the "Tasks" right menu, it adds me a column link, I just add some text for the link and a page to go to. Then I run the report and I get :
report error: ORA-01403: no data foundTested with several classic reports on multiple pages.
Debug mode shows me :
0.43816 0.00240 ...Execute Statement: select distinct [...] order by 3,11 ,4
0.44056 0.00162 print column headings
0.44218 0.04816 rows loop: 25 row(s)
0.49037 0.00141 report error: ORA-01403: aucune donnée trouvée
0.49175 0.00078 Computation point: After Box BodyWhen I run the query in my favorite tool, I get expected results.
Did I missed something ?
View 9 Replies
View Related
Nov 13, 2012
i have a html button. With the following attributes: onclick="return false" class="upd_description" A dynamic Action is listening on this button.
Event: Click
Selection-Type: jQuery Selector
JQuery Selector: .upd_description
static_URL: f?p=&APP_ID.:306:&SESSION.::&DEBUG.:306:P306_SER_SK:&P305_SER_SK.
as defined in my button attributes.
Button and dynamic action are on page 305. I can now open Page 306 as modal window but the page will close immediately.
View 3 Replies
View Related
Feb 17, 2011
dear all
i installed oracle database 10g
and iconnectthrowsql and it workfine but when i connect from client it give me this error
TNS: packet checksum failure
i try tnsping on the database serverit gives me the same error
View 17 Replies
View Related
Oct 15, 2012
I am facing some problems in recovery on oracle 9.2.0.1.0 Standard Edition.
Quote:
ORA-00283: recovery session canceled due to errors
ORA-00368: checksum error in redo log block
ORA-00353: log corruption near block 43200 change 1021681146 time 10/11/2012 18:25:25
ORA-00334: archived log: '/oradb/odb/archivedata/ARCH0000002343.ARC'
View 3 Replies
View Related
Jan 4, 2013
how can i create and customize a sign in popup when running an oracle form?
View 1 Replies
View Related
Mar 2, 2010
I created Main Menu form and in this form I attached popup menu in picture's property problem is that when i right click on this picture then show the popup menu .I want when I click left click then it should show the popup menu.
View 2 Replies
View Related
Mar 4, 2013
We 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.
View 1 Replies
View Related
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
View Related
Apr 26, 2013
how 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"/>
View 2 Replies
View Related
Mar 23, 2013
i 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 Related
