Application Express :: 4.2 New Database Sessions Per Report Region?

Nov 22, 2012

Does version 4.2 create a new db session for each report run on a page?

The reason I ask is we have a page with 4 report regions, each querying a global temporary table that is populated in a 'Before Regions' page process. The first report displays the correct data, but the others return 'No Data Found' and it is because the Global Temporary Table has been cleared out following the first report. This did not happen in 4.1.

I know we should be using Apex Collections, and we will in future, but time is at a premium to get this live

View 3 Replies


ADVERTISEMENT

Application Express :: Region Of Interactive Report

Oct 31, 2013

I've created a interactive report, and i have more items than my window behaves. So, i want to separate in two regions, and put in one region a scroll bar. How i can do this?

View 3 Replies View Related

Application Express :: Display Row Number In Report Region

Feb 6, 2013

I would like to display the row number in the report region at the beginning of each row for each page (based on the number of rows to display per page).

So if the number of rows per page is 15, I would want to show each row from 1 to 15. When going to the next page (16 - 31) I would like to show row 1 to 15 again next to each row. And if the number of rows per page is 20, I want to see row numbers 1 to 20 on each page.

Since I believe an Update button only processes the current page, I would like to then use this row numbers (1 - 15) to get the values of the displayed column for each row to perform an insert to another table.

View 1 Replies View Related

Application Express :: Cell Padding In SQL Report Region

Aug 23, 2013

I have what I hope is a simple question. I have a SQL Report region and I want to add more padding to the left and right sides of the table cell.  I don't want to change the style sheet because I don't want to affect other pages.  But I tried adding style attributes on the "Region HTML table cell attributes" field but I still can't get it to work. give me an example of how I can do this?

View 9 Replies View Related

Application Express :: Report Columns Duplicated When Region Is Copied

May 15, 2013

Re: Report Columns duplicated when region is copied.

When I copy a region which I have created via master-detail form, the report columns are duplicated. I'm actually copying the whole page but I have had other cases where I just copying the desired region and the columns were duplicated there as well. And, of course, there is no way that I know to delete columns from the form. But I doubt because -- in at least some cases I've tried -- the columns seems to be "linked" in that a change to one copy of the column was duplicated in the other when changes were applied.

In the example (below), there are three regions on the page and the problem occurs in region 2. (I think I will likely delete the first region.) It's been agonizing trying to get the report of region 2 and the tabular formish edits of region 3 on the same page. I made this in Oracle 11.2 in our APEX 4.1 and imported it to 4.2. You can see it here:

WS apex_examples_01
demo
demo
Appl. 991204

Page 57 is the original page created in 4.1 and imported
Page 58 is the page copied from 57 under 4.1 and imported
Page 59 is the page copied from 57 under 4.2 (Same result as in 4.1.)

If you want to try the page, select DSD01 from the DSD LOV, click "Query Process" and then click the edit icon. Ignore the region 1 errors -- I'll probably delete this region. The data is region 3 is for Run Date 12-May-13.

Is there some setting that allows this region to be copied without duplicating columns?

P.S. I think I know why it happens: APEX hates me!

View 3 Replies View Related

Application Express :: Add Button On Report Region Named As Send Email

Dec 28, 2012

I want to add button on report region Named as "Send E-mail" that should be on each row

so how can i do?

View 8 Replies View Related

Application Express :: How To Present A Report From BI Publisher To Inside HTML Region

Feb 12, 2013

how to present a report from BI publisher to inside a HTML region ?

View 1 Replies View Related

Application Express :: Image Stored In Table Is Not Showing In HTML Or Report Region

Aug 22, 2012

I am using apex 4.1 and database as oracle 11g. I uploaded images and stored in table structure as shown below

>>CREATE TABLE "HR_EMPLOYEE_DETAILS"
>> (     "ID" NUMBER,
>>     "HR_ID" NUMBER NOT NULL ENABLE,
>>     "PHOTO_BLOB" BLOB,
>>     "MIME_TYPE" VARCHAR2(64),
>>     PRIMARY KEY ("ID") ENABLE
>> )

My Requirement is to show the image in a report region as well as in a html region. I followed the methods in the URL links mentioned below.

[URL].......

[URL]........

But the image is not getting populated in the region, I tried with display_item with image i am able to view the image using this item.

View 19 Replies View Related

Application Express :: Dynamic Action In Report Region In Master Detail Form

Nov 7, 2013

I have created a master detail form , in which many validation etc is done ,the MASTER is a FORM  and DETAIL is a REPORTNow I am stuck up with the detail region .i.e reportI have Line Detail where there are ITEMS such as SL NO:

,ITEM_ID , UOM ( Unit of measuremnt ) etcNow here is where

Using POP UP LOV i have managed to fetch in LOV for the item "ITEM_ID",---

i can select an item name using the pop up LOV ,Now all that I want is when I select an item name from the pop up lov , an Item Id is displayed or fetched in that particular place , now i want the corresponding UOM to be diaplayed  ( i.e the UOM for that particular Item Id which has been selected by me from the pop up lov ). 

In order to resolve this I created a Dynamic action where in I get the UOM . Bt the problem is that the ITEMS displayed for selecting in the WHEN section (DYNAMIC action-IDENTIFICATION section-WHEN section----- items (  here i am not listed with ITEMS of the REPORT region instead ITEMS of the MASTER is available )-TRUE ACTION section etc is only theITEMS of the MASTER region ..

View 1 Replies View Related

Application Express :: Error When Refreshing Report Region / ORA-20876 - Stop APEX Engine

Mar 26, 2013

I'm using Apex 4.2. On click of a button, I refresh 2 Standard Region Reports with a Dynamic Action. This dynamic action has been working without problems for WEEKS and all of a sudden i'm getting the ORA-20876: Stop APEX Engine error when I click the button.

In the dynamic action, I removed the refresh of the second report and now the error does not occur. If I add the second refresh action back in, it throws the above error. I've even tried making the second report identical to the first and the refresh action fails. why this is failing on the second refresh action since the second report & region is IDENTICAL to the first report now.

View 3 Replies View Related

Application Express :: Pivot XML In Region

Jul 12, 2012

I tried to follow Pivot query using XML option in APEX

I can get the data into the xml serialized state, but how do I display the actual values in a region? See my example app below. I want the two far right columns in the Pivot XML region to duplicate what is in the original version.

[URL].......

View 3 Replies View Related

Application Express :: Items Align In Region?

Dec 18, 2012

I have 2 regions in my application one is html form region and another is tabular form .I created 6 items in html region and created DA for the items to hide according to the value of items and then created tabular form

find below the sample link

[URL]...

user name: aneesmohamed.m@gmail.com
psswd: symphony

once i select the first item(declaration letter) it will show the second item (applicacable) perfectly,but when i select applicable as yes and discrepancy then all the items become misplaced,

View 7 Replies View Related

Application Express :: How To Decrease The Width Of A Region

Oct 10, 2013

11gxe , apex 4.0 , firefox 24 ,i want to decrease width of a specific region , how ?

View 3 Replies View Related

Application Express :: Display PDF In Apex Region?

Jul 11, 2012

I have a requirement to view the PDF content in the apex page region, I am using Apex 3.2 and Oracle 10 Enterprise edition. I Uploaded the PDF file in the shared component under static file. Now i need to view the content of the PDF file. method to view the PDF content.

I saw the link in denes blog here he shows how the PDF is getting displayed. but there is no steps of methods mentioned

[URL]...

View 20 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 :: Center A Button Within Region?

Feb 28, 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 1 Replies View Related

Application Express :: 4.2 - Where Is Flash Chart Region Source

Sep 4, 2012

I just noticed on apex.oracle.com (4.2) that I couldn't find the region source for flash charts. I expected to find it under the Region Definition tab.

Has this moved or will it be included in a later release?

View 12 Replies View Related

Application Express :: Region Button To Go To Back To Top Of Page

Oct 24, 2013

In Application Builder, when editing an item's properties there is a handy 'Up' arrow at the top right of each region which takes you back to the top of the page. Is there any way of adding something similar to an actual page region as this would be useful when creating particularly large pages (I know, we should design smaller pages but that's not always possible).

View 11 Replies View Related

Application Express :: How To Create Different Bodies In Single Region

Jul 12, 2012

How to create more than 1 body in a single region. E.g i created report region and under body tag in region all other charts reports are created.

i dont want that .. i want to create different bodies in a single region.

View 2 Replies View Related

Application Express :: No Navigation Region On Home Page?

Sep 21, 2012

I've created a new appliacation which has a home page and I've created a report page which updates a table. I want to add a link to my homepage, as a text line for example UpdateTable, and when I click the link, it goes to my report page. I've had a look in my Apex CookBook, and it says I do this by using the Navigation region in my home page. The problem is I don't seem to have a navigation region in my home page. I thought initially it meant the navigation bar, but I now realise this is the header bar. Do you know how I can create a navigation region in my home page..?

View 2 Replies View Related

Application Express :: Changing Icon In List Region?

Nov 23, 2012

I am new to apex , procedure to change the icon in List Region....... see the below link

[List Region Image[URL]....

View 0 Replies View Related

Application Express :: Partial Page Refresh PL/SQL Region

Aug 13, 2013

I have an APEX page with a master and a detail. The master is a classic report with a column link which sets an hidden item on my

page:javascript:$s('P280_DAK_ID','#DAK_ID#'); 

I have a dynamic action which reacts on change of the item P280_DAK_ID.It then refreshes the detail region which is a PL/SQL region with the following:

begin apex_p280.show_xml(p_dak_id => v('P280_DAK_ID'));end;

This prints a few pieces of text to the screen, nothing special. Everything works except the refresh of the detail region.This is due to the fact that the new value of P280_DAK_ID is not in the session state yet. So my question is: what would be a nice solution to set the item in the session state without a submit? With a normal region I could fill in 'Page items to submit', but with a pl/sql region I can't. 

View 1 Replies View Related

Application Express :: Edit Region Display Selector

Dec 7, 2012

Is possible to remove the "show all" of the Region Display Selector? How can i do this?

View 8 Replies View Related

Application Express :: Scrollable Content Region - Template?

Jul 31, 2013

I have just implemented a "Data Load" function which is the OOTB page type in apex 4.2 which allows the end user to go through a wizard and import csv data into a table.

 When the user is viewing the data to be imported - they have to scroll across the length of the screen (depending on how many columns you are loading). I noticed there is a Region template called "Scrollable Content Region". I tried applying this template to my region, and when this didn't work, to a container region. 

The scrollbars appear (horizontally and vertically) but they are greyed out as the region is still at max width and you have to use the browser to scroll instead.I think this looks untidy as the header colour-styling ends, as well as other regions being stretched.

View 3 Replies View Related

Application Express :: Move Interactive Search Bar To Another Region

Dec 4, 2012

I have an interactive report which needs a horizontal scroll bar as it holds too much information for the screen, the problem is when a user scrolls the search bar is lost

i wanted to know if this could be changed by moving the interactive search (the whole action bar) to another form which would sit above the report.

View 2 Replies View Related

Application Express :: Using A Variable Database Link For Interactive Report

Nov 5, 2013

I have a requirement where users will select an instance (db link) from an apex LOV and the data in an interactive report will query based on the db link selected. I can use a db link in an interactive report query but only if I provide the exact name of the link. If I do something link select * from foo@:P12_ DBLINK it doesn't work. It seems my only option is to use something like apex_collection.create_collection_from_query and then I can build my query with dynamic sql and use a variable for the dblink name. Then I just create an IRR based on my collection. Does that sound like that correct approach and/or am I missing anything?

View 8 Replies View Related

Application Express :: How To Populate Date Picker Value In Calendar Region

Jul 2, 2012

I have a calendar region based on a simple query from a table which has date and name columns. The calendar type is monthly with 3 buttons - previous, today & next. It works perfectly.

I have added a date picker in a calendar region now. If i choose any date, the calendar month should be refreshed accordingly. Ie... by default it would show July 2012 month. When i choose the month as March 2012 in the date picker, it should show March month data.

View 0 Replies View Related

Application Express :: HTML Text In Reports Sub-region Not Displaying

Nov 30, 2012

I have a number of reports subregions in a page . Each of reports sub-region has a HTML text and a cell (report with a single column ) having a count sql . Now , the problem is that the HTML text in some below sub-regions are not getting displayed .. Is there a limit on the no. of sub regions???? Can there be any alternative way to display all the HTML text and the corresponding count sql in a page .

View 1 Replies View Related

Application Express :: How To Display 4.2 Chart Region Title Dynamically

Aug 21, 2013

i I am using APEX4.2 and created

(1) a drop down list item called P38_DESK which contains a list of desks such as A, B, C

(2) a Chart region with region title: Chart Mvt by &P38_DESK.

(3) a dynamic action to "refresh" the Chart region if the value of P38_DESK is changed. 

I can see that everytime the desk is changed from the drop down list, the chart section/region gets refreshed accordingly but NOT the Chart's region title.

It only showed the first value I chose. e.g. Chart Mvt by A So in APEX4.2, how can the CHART's region title be changed dynamically ( without submitting the entire page ) to reflect the value from the drop down list P38_DESK ? 

View 7 Replies View Related

Application Express :: Possible To Detect Status Of Hide / Show Region

Nov 11, 2012

Is it possible to detect the status of Hide / Show Region.

I have three hide/show regions RX,RY,RZ. When an event EX happens, then region RX should expand and the rest of the region should collapse. When an event EY happens, then region RY should expand and the rest of the region should collapse.
........
...
We can use this JS on DA to change the status of a region:

$("RX.uRegionControl").click();
$("RY.uRegionControl").click();

.....But, first we need to detect the status to know where to apply that DA. ? I am working on apex 4.2. theme 25.

View 2 Replies View Related







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