Oracle How to refresh page #0 item?

2012-05-15  Source: Original Site  Category:Oracle  Views:0 


I have an application with some LOVs on top region page #0. While the user navigating the application, the LOV may be set to some value. The application has also side bar list. When the user click one of the links in the side bar link, I would like to set the value of LOV on page #0 to '%'. I have set the LOV item to '%' in side bar list entry and it's setting the value correctly. But the problem is the top LOV still shows old value and session value is '%', because page #0 is not refreshed. is there a way I can refresh the top LOV on page #0 with the latest value when side bar list entry link clicked?. any ideas are appreciated.

Related articles
  • Oracle How to refresh Page, Region, Item 2012-07-03

    Two very simple questions but something which I don't know how to do. 1. I have a Popup LOV returning a value. A valid record has been selected but form is not yet submitted. How do I get the key value currently in that item? scenario: I choose a Pro

  • Oracle How to refresh page #0 item? 2012-05-15

    I have an application with some LOVs on top region page #0. While the user navigating the application, the LOV may be set to some value. The application has also side bar list. When the user click one of the links in the side bar link, I would like t

  • Oracle How to refresh page 2013-02-02

    I created tree. When ever i visit the tree page need to refresh page with this link [code] pls/apex/f?p=112:6:3438142066758732:CONTRACT,1 [code] This link specify the tree in collapse state. How to set this link in process.

  • Oracle How to refresh page after selecting value from LOV item , in a tabular form 2013-06-12

    I have a tabular form, which contains 2 items(columns), of type "Select List - named LoV". Now, couple of issues here. 1. 2nd item(column) in tabular form, that LoV should get populated based user's selection value in first item LoV. So how do i refe

  • Oracle How to Refresh page after custom popup closes 2012-11-16

    Question 1: I have three pages 1,2,3. The page 2 is a custom popup window and returns a variable ex. p1_search to page 1. I want to use the value of p1_search and re-query my page1. I am able to return value from page2 using JS(passback function). Pl

  • Oracle How to set page items from stored procedure? 2013-12-22

    I would like to load the page items for my report criteria from the database where I have saved the user's last selections. I know I can access page items via pl/sql using v('page item'), but how can I set an item? I want to keep as much of my code i

  • Oracle How can I compare two items on a page 2014-01-19

    I have a page with two items. The value of both have to be the same. At the moment I use the Item leven validation -> Item String Comparison -> Item in Expression 1 equals string literal in Expression 2. (Exp 1 is P102_PSW - Exp2 is :P102_PSWCH

  • Oracle How to change a text item to have a link that opens a different page? 2014-05-03

    How to change a text item to have a link that opens a different page?

  • Oracle How to set Page Item value to value of another Page's Item 2015-05-09

    I have two primary key fields on a Form. I want to set the value of those page items to what a User previously entered on a previous form. I can do this by changing source type from Database Column to Item, and entering the previous page's item name.

  • Oracle How to submit page and show a report without submit a form within same pag 2012-01-08

    I have have a page as follow, 1- HTML region contains two search items and a submit (GO) button. 2- Form region contains the items and the create button (CREATE). 3- report region filtered based on search items in HTML region. The problem is, How can

  • Oracle How to show page loading icon? 2012-07-07

    Anyone have idea on how to show page loading icon while waiting to retrieve the data from Ajax into apex item? I have created a report manually by using application processes and using Ajax to retrieve the data. My report consists over 700 rows data,

  • Oracle How do you use the "Item Containing Start/End Date" in a Calendar? 2012-10-30

    Hi I want to do a calendar where the days shown will be conditional to a certain interval. Now I though I could achieve that using the Item Containing Start Date of a calendar. But it doesn't seem to work. In the help it says : Enter an item in the a

  • Oracle Session state protection - page and item level 2012-12-11

    can someone explain me the differences between page and item security. Also I don't understand these restrictions: Case 1: If the page access protection of page 300 is set to unrestricted, I can still set an page item's session state protection on pa

  • Oracle How do I combine 2 items and insert them as one into the database 2014-03-15

    Hi I have a form with 2 items "P1_Start_Date" and "P1_Hours". Where and how on the page definition would I put code to add the "Hours" to the Hours part of the date upon insertion into the database.

  • Oracle quotes in a page level item not showing up as " when used in a hyper link 2014-03-22

    In my app, I need to hyper link to a crystal report application with parameters from my page. I have a page level item that puts my parameter in quotes, but when the item is utilized in the hyperlink, the quotes come across as & q u o t ; (spaces

  • Oracle How to Refresh Hide & Show Region 2014-03-31

    I would like to know, How to refresh the Hide and Show Region without resubmitting the Page. Let me explain the scenario - I have 2 Apex Pages (Parent and Popup), When user clicks the link (customized link) in Parent Window, I am taking user to popup

  • Oracle How to set an Application Item from PL/SQL 2014-07-24

    I am attempting to set an Application Item After login to my app, I want to retrieve a row from my SETTINGS table and populate some Application Items with the settings information so that I can display some of that settings information on every page.

  • Oracle how to compare two collection items? 2012-05-08

    I use 9i and I can't use MULTISET operations ... so I thought of implementing myself a kind of union but how can i compare two items that are not of a primary type (varchar,number ...) declare type emp is record( nume varchar2(64), prenume varchar2(6

  • Oracle How to refresh a Materialised view(MV)? 2013-01-26

    I am in a plan to develop MV in my database where I can point my user applications to run some reports.These MV is located completely on a different server to illustrate in more detailed way A and B are my production databases server and C is the one

  • Oracle How to retrieve Page name? 2013-02-21

    I have a select: select step_id Page , count(step_id) Hits from wwv_flow_user_activity_log where flow_id = &APP_ID. and (time_stamp >= (sysdate - 7)) group by step_id order by count(step_id) DESC Where I show most frequent pages. How to retrie