Application Express :: Modify Form Layout Of Existing Application?

Feb 22, 2013

I have to modify the Form layout of an existing application (Application Express 4.0.2.) where the data for each field is retrieved using SQL statements

Presently the form looks something like this and the Data for each field is rendered properly in this layout:

UNIT # :         123456
ADMISSION #: 2012101510         DISCHARGE DATE:                 ADMISSION DATE:
FIRST NAME:   JON                     LAST NAME: DOEFIRST NAME, LAST NAME and UNIT # are all "Display Only" item type.

What I'm trying to do is to move "FIRST NAME" underneath "LAST NAME" and "UNIT #" next to "LAST NAME" This part is very simple. However, the issue I'm having is as soon as the "UNIT #" is moved next to "FIRST NAME", the data for "FIRST NAME" and "LAST NAME" simply disappear

This is how it looks
ADMISSION #: 2012101510         DISCHARGE DATE:                 ADMISSION DATE:
FIRST NAME:                             UNIT #: 123456
LAST NAME:   

I have played around for hours and even created from scratch a new page with a new form using SQL statements to pull the data for each field, only to get the same result.

View 7 Replies


ADVERTISEMENT

Forms :: Modify Existing Form - Resize Canvas And Window?

Oct 30, 2010

I need to modify an existing form, thus I have to resize a canvas and a window for it. In windows, I run it and I got the right display. When I transfer it to dev server running in linux, then I compile and run it, it display the previous/unmodified size. I'm sure my form is the one that running, I placed some text there and it was displayed.

View 4 Replies View Related

Application Express :: Error Importing Existing Application Into Production?

Aug 6, 2012

version 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 =&gt; 9504132415918888 + wwv_flow_api.g_id_offset ,p_flow_id =&gt; wwv_flow.g_flow_id ,p_page_id =&gtI

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.

View 3 Replies View Related

Application Express :: Layout OK In 4.1 All Wrong In 4.2?

Nov 16, 2012

I have a show/hide region of type HTML with empty region source which I use to show/hide a subregion (tabular form)because I don't like the layout of a show/hide region when it is shownthis worked without a problem in APEX 4.1.1

however in 4.2 the tabular form is just a couple of pixels widehave been playing around with grids but can't seem to find the right combination of settingsthe layout is messed up

I put the app on apex.oracle.com :
workspace : xonixrs
login/password : demo/demo

View 2 Replies View Related

Application Express :: Pivot Table Layout?

Nov 5, 2012

in my application i have a requirement as follows

1) column 1 indicator
2) column 2 important.

and the other columns are target actual and current year, previous year and next year.the layout should be in pivot table lay out as follows here the three columns will be saved dynamically as 2012,2011,2013 and the respecitive percentage in target and actual column

current_year previous_year next_year
target 10% 12% 5%
actual 5% 8% 5%

View 1 Replies View Related

Application Express :: Bug Report - Conditional Regions Affect Grid Layout

Mar 20, 2013

I had a few regions on my page, the 2nd did not start a new row so it appeared horizontally where possible.During some experimentation, I created a new region with a sequence in between that started new row, but even when that region was conditionally never, my original 2nd region started on new row.

Original:
Region 1 - Region 2(empty) - Region 3 (new row/col no)>
New region added:
Region 1Region 1.5 (added, new row)
Region 2
Region 3>
Region 1.5 not shown:
Region 1Region 2
Region 3>

Let me know if you would like a test case for better visualisation.

View 3 Replies View Related

Application Express :: JQuery Mobile Layout Grid Not Working After 4.2 Upgrade

Nov 4, 2012

I'm running a mobile application on a hosted Apex environment which uses lots of jQuery mobile. The environment has been updated to 4.2 recently, and since that happened pages that I had setup to use the content grid, to show content in 3 columns no longer works, there only appears to be 1 column now.

Code as below: -
<div class="ui-grid-b">
<div class="ui-block-a">Block A</div>
<div class="ui-block-b">Block B</div>
<div class="ui-block-c">Block C</div>
[code]........

View 1 Replies View Related

Application Express :: How To Make Form With Report And Insert Form In Same Page

Dec 14, 2012

how to make a form with report and an insert form in the same page, these two forms are related to the same table. Our customer wants a user can add new row to the table in a form and see all of rows created by this user in a report, this report should provide edit link as well. the problem is: whenever I inserted a new row or edit a row or delete a row, and submitted, and return to this page, all of hidden items lost their values, so report is blank, and some display only items also lost their values.

View 6 Replies View Related

Application Express :: 4.1 - How To Add A Report Column To Existing Page

Oct 12, 2012

On a "Form on a table with report" page created with the wizard, I want to add a new report column from the underlying table (this is the multi-row page). If I try to add the column name to the query, Apex tells me:

"You have requested to change the Interactive Report query. If you added columns to the query, they will not be displayed when the report is run. You will need to use the actions menu and either select the columns or click Reset. If you removed any columns from the query, it will disable existing filters, highlight rules, and other report settings referencing those columns. Please confirm your request."

I sure don't want to start over and re-build the page, so where the heck is this "actions menu"?

I'm running Apex 4.1.

View 2 Replies View Related

Application Express :: Apply User Defaults To Existing Applications Pages Reports

Oct 30, 2013

Is it possible to apply a new created UI Defaults to an existing page or pages in the application.If so then how? 

View 0 Replies View Related

Application Express :: Unable To See Items Of Detail Form In Master Detail Form In Page Details?

Oct 31, 2013

I created a master-detail form using wizard in oracle apex 4.2 Now I want to attach an LOV to one of the items of detail form, which is visible on the same window as of master form. To do so, I need to first find the item in detail page, details of which are not available in page definitions. I can see all the items of master form but none for detail form in "Page Rendering" section. 

View 0 Replies View Related

Application Express :: Check Box In Tabular Form 4.1

Sep 14, 2012

How i can use check box in tabular form . working with 4.1 and am using simple check box (display as) .it creating the check box. how i can set value yes or no into it?

View 1 Replies View Related

Application Express :: Registration Form For Events?

Nov 6, 2012

registration forms for events (like Technology days and so on) with Apex? I want to build up something like that where customers can register for several events.

What is needed:

registration form with a limited registration (e. g. 80 customers) e. g. create a trigger?

show how many seats are still available

cancel of the registration

I´m using Apex 4.1

View 0 Replies View Related

Application Express :: Tabular Form With Updates In 4.1

Dec 5, 2012

This problem went away for me in 4.2, but I am limited to 4.1 in production. The problem is this: I have three editable columns in my Tabular Form

1) I make a change to column 3 and press submit. The values in columns 1 & 2 (that were not changed) are overwritten with null during the update (submit). Column 3 is saved correctly.

I deleted my tabular form and re-created it thinking that I may have trashed something. But it appears that is the way it works. How do I prevent the unchanged editable columns from being overwritten with nulls?

View 2 Replies View Related

Application Express :: Dynamic Tabular Form

Jul 9, 2012

I have one table that holds a list of People...

Another that holds Classifications

Another that holds Sub Classifications (linked to the Classification table)

Table(*Person*)
PersonID, PersonName
Table(*Classifications*)
ClassID, ClassName
Table(*SubClass*)
SubClassID, SubClassName

I need a form that will allow me to put Classifications and Sub Classifications against a Person. I want to be able to add new Classifications and SubClass Values which are dynamical added to the form...

I have a table that holds other data and links the People to the Assessment

Table(*Person2Assessment*)
AssessmentID, PersonID, Date, AssessorName, Notes

I have a table to hold the Values of the Assessment...

Table(*AssessmentValues*)
AValuesID, AssessmentID, ClassID, SubClassID
-----------------------------------------------------------------
A typical person may look like:
e.g.

Person1(Fred)
Class1(Programming C++)
SubClass1a(Expert)
Class2(Language)
SunClass2a(English-speaking)
Class3(Location)
SubClass3e(India)
-----------------------------------------------------------------

Now I have the data tables but how to create the table and save the values for the Assessment Values in one table the dynamically adds values based on the different classifications available...

View 2 Replies View Related

Application Express :: Form On A Table With Report

Apr 24, 2013

I have one question. Is possible export form to CSV (or PDF) for example? If it is, what is the process?

View 0 Replies View Related

Application Express :: Defaulting In Tabular Form

Jun 7, 2012

I got stuck in trying to add a simple fixed number (e.g. -1) to a field in case the database-fields is still null.

I supposed I could use report attributes > column attributes tabular form attributes, and then use Default Type and Default but nothing seems to work.

View 1 Replies View Related

Application Express :: DateTime Calculations On A Form

Jul 19, 2012

Version of the database you are using: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
Version of Application Express: 4.1.1.00.23

I have a requirement that is driving me stark raving bonkers.

I have a form that a user fills out, it sets the Status to 'Open' and I capture the Date Created On in a hidden field. When someone goes back in to the Form and sets the Status to 'Closed' I capture the Date Closed On in a hidden field. I need to calculate how many hours that it took to close the issue and display it on the form.

I found some javascript that does this

<Code>
<script type="text/javascript">
var msecPerMinute = 1000 * 60;
document.write("msecPerMinute -" + msecPerMinute + "<br />")
var msecPerHour = msecPerMinute * 60;
[code].......

While I can get it to work from dreamweaver I cannot get it to work from APEX. Both of my date fields in my database are defined as:

Type: TIMESTAMP
Fractional Precision: 6
Time Zone: LOCAL TIME ZONE

View 17 Replies View Related

Application Express :: 4.2 Tabular Form Number Of Rows Bug?

Oct 25, 2012

When I build simple tabular form in APEX 4.2 it displayed 10 rows per page by default. When I changed that number in Number of Rows field to 15 nothing happens. Again only 10 rows per page were displayed. Next field on the right to Number of Rows is Number of Rows (Item). Tabular form works as expected when I use this field and define number of rows with hidden page item. So workaround issue (bug?) is easy. Is this some kind of bug or I miss something obvious?

View 1 Replies View Related

Application Express :: How To Manipulate DML In Apex Form (not Tabular)

Aug 12, 2013

 I have one question I made a report and form in wizard with 1 table (Ex : EMP) and want to make a INSERT/UPDATE/DELETE process based on PL/SQL API. I think, mixing APEX_APPLICATION and APEX_ITEM pl/sql api can solve this question but not sure.... I have known the tabular form processing with PL/SQL via Oracle APEX book, but cannot find any samples on simple form processing. 

View 5 Replies View Related

Application Express :: Spinbox Plugin For Tabular Form?

Sep 19, 2012

have a spinbox plugin for tabular forms? I saw a plugin on jquery but I could not download it.

APEX 4.1
Oracle 10g Rel 2 DB

View 0 Replies View Related

Application Express :: Numeric Field In Tabular Form

Mar 25, 2013

I am using APEX 4.1 and Oracle 10g XE.

I want to restrict 3 digits after decimal in tabular form. Only three or less than three digits should be allowed after decimal and should be stopped automatically.

e.g. 34.543

View 6 Replies View Related

Application Express :: Disable Column In Tabular Form

Dec 28, 2012

How i can disable column in tabular form.working with 4.1 and i have wizard based tabular form.If i have entered value in one column second column should disable and vice versa?

View 5 Replies View Related

Application Express :: Duplicate Record Into Tabular Form

Oct 23, 2013

I have created tabular form using

SQLselect"LINE_ID","LINE_ID" LINE_ID_DISPLAY,"ALLOCATION_ID","SERVICE_ID","CATEGORY_CODE"from "HOTEL_ALLOCATION_DTL"WHERE SERVICE_ID=:P6_SERVICE_ID 

here line_id is primary key .here i don't want to enter duplicate category code when i submit rows.Here Allocation_id and service_id would be same for particular service_id .How can i create validation to enter duplicate category code .  

View 1 Replies View Related

Application Express :: Updating Fields On A Tabular Form

Oct 1, 2012

I have an application where I'm trying to match skillset supply to skillset demand. We have resources and we have work for resources to do. Resources possess a set of skills. Work requires a set of skills. Skillsets are described by three fields: Domain, Target, Skill. So, we are able to capture the supply of skills in a table:

RSRC_ID (FK to Resource table)
DOMAIN
TARGET
SKILL
PROFICIENCY  (this is the skill level 1 to 5)

The relationship of resources to skill supply is 1 to many. Conversely, work demands skills, and so we capture skill demand in a table:

WORK_ID (FK to Work table)
DOMAIN
TARGET
SKILL.

The relationship of work to skill demand is 1 to many also.

Users assign skills to resources using a master-detail form. It works fine
Users assign skills needed to work also using a master-detail form, and it works fine as well

A view then joins the skillset supply to skillset demand so that assignments can be made only where supply and demand match. This view is used in the LOV below.

I am using a mapping table to capture assignments of work to resources or resources to work. It is a many to many mapping of work and resources with matching skillsets, and it looks like this:

RSRC_ID  
WORK_ID
DOMAIN   (
TARGET   ( These are the skillsets where demand equals supply and are derived from the view and presented in the LOV )
SKILL      (I've created master-detail forms for the two types of assignments. An LOV in the detail form will present qualified resources or eligible work and then return the appropriate RSRC_ID or WORK_ID, but I must also populate the other three fields (DOMAIN, TARGET and SKILL) before I can insert or update the record. Here's the LOV from the form where resources are assigned to work:

SELECT sed.domain||'.'||
       sed.target||'.'||
       sed.skill||'/'||
       sed.skill_prof||'  '||
       r.first_name||' '||
       r.last_name "d",
       r.rsrc_id "r"
FROM   ri_resource r, ri_skill_supply_eq_demand sed
WHERE  r.rsrc_id = sed.rsrc_id
AND    sed.work_id = :P18_WORK_ID

order by 1It is not enough to just match the work to the resource, we must record for what skillset they are matched. I can't seem to see an easy way to populate the three other fields in the tabular form using data that I can retrieve with the LOV.

View 1 Replies View Related

Application Express :: Maximum Rows On Tabular Form?

Sep 27, 2012

I have a tabular form (report) multi-record. It display only the records 1-15 with pagination to the other pages. When I set the field 'Number of Rows' to 100, it still displays record 1-15 only. I just want to see the complete dataset on one page, without pagination. (There is a filter on it so there will never be more than 100 records displayed)

View 4 Replies View Related

Application Express :: Tabular Form Row Background Colour?

Jan 29, 2013

I have created a tabular form and have changed some row background colours by using the Column Template sectiom in the report template

i.e

<td #ALIGNMENT# headers="#COLUMN_HEADER#" class="t16data" style="background-color:#FFFF33">#COLUMN_VALUE#</td>

with '#ASSIGNMENT_ID#' = 99 as the condition

This changes the colour but when I move the mouse over the row it removes the colour.

View 3 Replies View Related

Application Express :: Javascript Function For Tabular Form Changes?

Apr 12, 2013

I have a tabular form with a few columns. THey are ID, date1, date2 and task_name. The task_name is a drop down list of tasks. Upon selecting a specific task, I want the date1 and/or date2 columns to become read only (voided out) so users cannot enter in data. I am working with a tabular form, so I figured I need a javascript function to handle the logic and to call the function in the html elements of the column in the apex environment. This will need to happen dynamically (on click) before the page is submitted. I am more lost/confused on syntax. I know I will need to know the actual column name (coo1, coo2, something like that) of my columns that I will be refering to when I use javascript.

View 2 Replies View Related

Application Express :: How To Display Picture Image On Form

Oct 24, 2012

I have just started using Oracle Application Express 11g. On my new attempt I am able to develop a table, report and a form, but I am not able to display picture image on the form though the browse link is active.

I can load the file name from the location folder to the form but it does not display. When I click on APPLY CHANGE then everything disappears. My main problem is how to successfully configure the settings for image display.

View 1 Replies View Related

Application Express :: Unable To Delete Row(s) From Tabular Form?

Jan 28, 2013

I created report with row selector, when I select one row I get tabular form regarding to the selected row from report. I can insert and update data from tabular form, but I have problem with deleting them. Error I get is

ORA-01403: no data found (Row 207589)

My tabular form is created by wizard and primary key is managed by database rowid, I use apex 4.1 an 10g database.

View 3 Replies View Related







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