Application Express :: 2 Trees On The Same Page?

Feb 6, 2013

I'm using Apex Version: 4.2.1.00.08

I created a page with 2 tree regions. Both trees use different items and different queries. The first tree is displayed correctly. But the second one just contains the first item, if I don't display the first on via customizing the page or if I change the order of the trees the previoulsy invalid tree is shown correctly, but I didn't find a way to display both correct at the same time.

View 1 Replies


ADVERTISEMENT

Application Express :: Can Open Page 306 As Modal Window But Page Closes Immediately

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

Application Express :: Add Field In Page Title Or Repeat Header On Each Print Page

Jun 4, 2013

We are using Application Express 4.1.0.00.32 on Wondows XP and Oracle version is 10g. I've created a report in APEX and the user is insisting on putting a header on each page in PRINT of the report which should contain the "from date" and "to date", which are present on the select criteria on top.

Can I somehow add from_date and to_date items in Title so that when they print the report, they'll see the from and to dates in the title?Or is there someother way to do this. The report is an interactive report with a control break and user prints the report with file->print.

View 1 Replies View Related

Application Express :: How To Create A Text That Links To Another Page From The Login Page

May 21, 2013

In the login page, I want to add a text "Register" that when clicked will send the user to another page to register.

With a button, its simple because its inbuilt there,but I do not want a button,just this: Register

I want also to have the text in color not black.

View 6 Replies View Related

Application Express :: Passing Item Value To Another Page Via Button Set To Redirect To Page

Jul 16, 2013

I am new to APEX and I am developing an application to manage Oracle database user accounts.  I have a page (8) that has text items for the username and the database name.  I have a submit button (this works fine) that will issue the ALTER USER... statement to reset the user's password and unlock the account.  I have another button that should:

get the value of the username - P8_USERNAMEassign it to an application item - FIND_USER_IN_DBredirect to page in application - to page 11

The issue is that FIND_USER_IN_DB does not get populated and page 11

which is a simple report with the following query:

SELECT *FROM valid_dbWHERE username = :FIND_USER_IN_DB; 

How do I accomplish this?

View 8 Replies View Related

Application Express :: Navigate To Authorized User Page 5 - Keeps On Going To Page 1

Aug 17, 2012

I have different public page (page1) and different page for authorized user(page5).Upon successful login after process validation ,computation it should navigate to authorized user page 5 but the branching does work it keeps on going to page 1 .

View 8 Replies View Related

Application Express :: Reset Data Picker Page Item By Selection Page Item

Aug 23, 2012

Need to create a report based on date ranges and for this created a interactive report and two page item datepicker fields P15_fromdate and p15_todate. Report works fine with this criteria.But user wants one more field quarter(P15_quarter), When they select the quarter the range values has to get reset and as to get applied to report.

Issue here is unable to find a way to set the page range item values based on the quarter field selection

how to reset the page item fields.

View 0 Replies View Related

Application Express :: Display List Of All Users On Page / Accessing Or Using Application

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

Application Express :: JSON Error When Trying To Redirect To Another Page In Same Application?

Jul 23, 2013

I'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. 

View 2 Replies View Related

Application Express :: Button Placement On APEX Application Page?

Mar 6, 2013

How do I center a button within a region? I tried 'align="center"' but this seemed to be ignored. The button is at the left of the screen. Also, what are the 'display points' (Page Template Region Position 1-8) used for, and why is there a specification for column position of 1-9? Could these be attributes that will allow my button to be centered on the window instead of on the left?

View 3 Replies View Related

Application Express :: Go To A Specific Page

Nov 13, 2013

I have "After header" process (with PL/SQL code) in "Page Rendering" section and want to navigate to some page after this process has been completed. I created a branch (On Submit: After Processing) with Target Type: URL. But this branch is executed only after "Page Processing", not after "Page Rendering". Maybe ,  there is any APEX API functions for pages navigating..

View 2 Replies View Related

Application Express :: Page Zero - Option Not Available

Sep 5, 2012

Trying to create a "page zero". Usually in previous releases this is done executing the following:

1. On the Workspace home page, click Application Builder.

2. Select an application.

3. The Application home page appears.

4. Click the Create Page button.

5. For Select a page type, select Page Zero.

Note that the Page Zero option only appears if the application does not have a page zero.

6. Click Finish.

Since the upgrade to 4.2 this option is not available or has move. (I do not have a page zero already created.)

View 2 Replies View Related

Application Express :: CSS In Global Page

Mar 20, 2013

I wanted to apply some CSS throughout my application by adding it in Global Page in APex 4.2

And I used

<style>
#t18InlineError {
color: rgb(243, 12, 12);
}
</style>

It doesn't work.

View 4 Replies View Related

Application Express :: Creating A New Page Template

Oct 19, 2012

I have a requirement to create an applications with company standard layout,logo and colors.

What is the best way to start. Should I change Page Template or Region template.

There are some standard .css files.

View 3 Replies View Related

Application Express :: Bug While Copying Items On A Page?

Oct 4, 2012

When I create a new page item via copying from existing page item it fails with the below error code, if there is > or < character in the source of the existing item.Error Source contains <, > or " which are invalid characters. It works fine if I create new item using wizard and then have the same source. I use div tags in the source of my display only items.

View 3 Replies View Related

Application Express :: Two Validations On One Page Item?

Jun 13, 2013

it is possible to have two Validations one Page Item. Also I need to execute them one by one. If one is passed then go to the other and validate that one. 

Example:P20_FORM_ACTIONP20_REOPENP20_REASON Validation 1: P20_REASON  != 0 with condition P20_FORM_ACTION = CLOSEIf Validation 1 is passed then go to Validation 2Validation 2: P20_REASON  != 0 with condition P20_REOPEN = YES

If Validation 2 is passed, then submit the form otherwise get error.  is possible in Application Express 4.2.2.00.11. I tried to put the validations as described above into my application, but it did not work. Only one Validation was executed. 

View 6 Replies View Related

Application Express :: Page To Submit Not Found

Nov 29, 2012

I am using Oracle Application Express 11g

I don't have a option for "Page item to submit" in Chart Region

View 5 Replies View Related

Application Express :: JavaScript Code In Page Zero?

Sep 27, 2012

I have javascript code i want to move from standard report page to page zero, well page 0 doesn't have html header/page attribute section so how to i achieve this?

View 7 Replies View Related

Application Express :: How To Secure A Single Page

Oct 17, 2012

I have no authentication required for my application, but want to secure a few pages.

On the page I wish to secure I have specified that user should not be a public user.

When I click a link to the page I do get a login box, but I seem to be able to enter any old rubbish and still proceed to the page.

How do I secure an individual page without a general authentication scheme at application level, so an Apex user account is needed.

View 5 Replies View Related

Application Express :: How To Submit Page On Load

Oct 4, 2012

i m using apex 4.1, and want to submit page when page load. i tried dynamic action but it continuously refreshing page. is there any other javascript or anything else from which i submit page on load

dynamic action used, event on load and action submit page but it continuously submitting page.

View 5 Replies View Related

Application Express :: Logging On Using Portal Page?

Sep 24, 2012

We have our own portal page. We are trying to pass username and password so they do not have to log in twice. This worked in version 4.1 but when we put in patch p13331096 to get to version 4.11.00.23 the form stopped working. Users have to log into our portal page an then into APEX. That does not make them happy.

<form action="http://dashboard.reliv.com/pls/dwprod/wwv_flow.accept"
method="post" name="wwv_flow" >
<input type="hidden" name="p_flow_id" value="106" />

[Code]....

View 1 Replies View Related

Application Express :: Use Javascript.addrow() In A New Page?

Oct 5, 2012

In a normal tabular form, with the add, delete, submit option, Under the add button we have the javascript.addrow() call which creates a new row. However, in my case the rows in the tabular form have some columns as display type. So when the user clicks on the add button, he cannot enter all the fields. Is there a way

1. Either to enable all columns of a new row only so that users can add all values and save

2. Or atleast open a new page where the new row is open with all editable fields?

Version:4.1.0
11g

View 1 Replies View Related

Application Express :: From Cursor Variable How To Get Into Page

Feb 15, 2013

i am creating an apex page where i have 2 regions. From the Top region stores all fields entered into the bottom region Text fields like first name and last name and address fields are in region 2(bottom).After region 2, i have a add person button.

Once i click add person, that person will get into top i.e region 1.

Now, Region 1 got person1 first name ,last name
person2, first name,last name
etc..

I am not able to display like p1_first_name,p1_laast_name as the list is not stable..it is growing and not showing the person who already got saved..I can retrieve them from DB using a cursor..But from cursor vairable how to get into page vairable..

View 1 Replies View Related

Application Express :: How To Use A Background Image For Page

Sep 4, 2013

How can I tell Apex to use an image as the background for a page?  This particular page needs to be more visually interesting due to the audience that will be viewing it. I'm using Apex 4.2.2 and Oracle 11g.

View 1 Replies View Related

Application Express :: 4.2 - 200 Page Items Limit

Jan 8, 2013

I have a master-detail form which was getting close to the 100 items per page limit in Apex 4.0 which I then scaled back and got to work properly. I had thought that I could start adding more columns to the detail part of the form since 4.2 was supposed to have increased that limit. I am finding that this does not seem to be true at least in the case of this particular form. I tried increasing and started getting 404 errors when trying to save data--same symptom I had had with 4.0. I am back nearly to the same # of columns I started with--and nowhere near the 200 limit. Columns are month by month projection data that I had hoped to extend with the increased page item limit.

I missing something required to take advantage of larger page items limit? Do I need to use one of the new templates?

View 4 Replies View Related

Application Express :: Dynamic Page Item Name

Nov 1, 2012

I have a from with some fields (VELD01, VELD02...VELD11) and a page process that fills that field. I want to make that more dynamic using a loop. Is it possible to use some 'dynamic SQL' like:

l_cnt := 1;
for r in c
loop
P1210_VELD0||l_cnt;
l_cnt := l_cnt + 1;
end loop;

Example above does not work of course...

View 3 Replies View Related

Application Express :: Calling A Page In A Different Region?

Sep 5, 2012

I am using Apex 4.0 with oracle 11g.I have a requirement where I need to call a page in a region in different page.

For example. I have 2 pages page1 and page2

I need to call the page1 in page2 region.

View 2 Replies View Related

Application Express :: Submitting A Page Via Tabs

Aug 13, 2012

Isn't it the case that clicking on a tab submits the current page, using the tab name as the request? I'm getting it to work some of the time but not always. In particular, it seems to work if the execution point is "On submission before computation" but not when the execution point is "After submission".

Here is what I did: I created a new application with two pages, each of which has a tab. Page 2 has nothing in it. Page 1 has an item, a button and two PL/SQL processes. Process 1 is unconditional, and sets the item to 10. Process 2 is conditional on the tab named "T_PAGE2", and increments the item by 5.

If both processes execute "on submission before computation" then everything works correctly:
-- If I click on the button, then the item is 10, indicating that only process 1 fired.
-- If I click on the tab to page 2, then the item is 15, indicating that both processes fired.

Now suppose I change them so that the processes execute "after submit". Then the button still works, but the tab doesn't:
-- If I click on the button, then the item is 10, as it should be.
-- If I reset the item value to 0 and click on the tab to page 2, then the item doesn't change, indicating that neither process fired.

Note that I have no computations or validations in my application. My only conclusion is that when you submit via a tab, there is some sort of internal validation occurring that keeps the processes from firing.

View 3 Replies View Related

Application Express :: Changing Parameters On Other Page

Aug 17, 2012

I have a page, Say page 1 ..and from that page 1 I go to a different page Say page 2 which is open like a modal window. Now what i need is i need to make a change in the first page that is page 1 ..from page 2 ..

I need to change a value of status field which is in  page 1  to Say p100_status ... I think i might have to use application items to accomplish this.. So i Use the following method..

APEX_UTIL.SET_SESSION_STATE('F148_STATUS','ACTIVE');

Now i need to transfer the value in apex item . i.e p200_status  should contain  the value of  : f148_status ..

View 4 Replies View Related

Application Express :: Fetch Row With / Without Refreshing Whole Page?

May 29, 2013

I would like to create a process that allows me to move from record to record without refreshing a whole page. Specifically, I'd like to use a tree object that allows the user to select items and then have the details for that item show up on the right side of the page. Is there a way to do this without doing a complete page refresh?

So far I've tried two different on-demand processes:

- first I created an "Automatic Row Fetch", but I read on the board that this actually won't work as an on-demand process;

- I also tried a PL/SQL process that sets the various variables (e.g. ":P7_NAME") based on a query. This updated the session state, but it didn't refresh the fields on the page. Is there a way to trigger this refresh?

View 0 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved