The values in the page item dont get submitted hence generate errors in my application , in apex 4.2 using collectionEg.
apex_collection.add_member(p_collection_name => 'ORDER', p_c001 => :P56_product_id, p_c002 => :P56_product_name, p_c003 => :P56_list_price, p_c004 => 1);
Can there be a reason why ?
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 RelatedI 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?
db11gxe , apex 4.0 , firefox 24 , I have a page with a report and two items , and i want to print the whole page (the report with the items) , can apex do so ?
View 1 Replies View RelatedAPEX 4.2.1 On a page with dozens of editable page items, when branching back to the same page on-submit, is there a way to clear cache for all items except a few (key) items? The branch attributes (via the f?p= syntax) support clearing cache for the entire page and setting specific item/value pairs but no support for exclusions.
View 2 Replies View RelatedIm tring to dynamically hide/show page item. I searched and found something but it not working for me. Im using apex 4.1 and below described are work I did.
In my page (form) I have 5 fileds iitems.
- Customer No
- Edit
- First Name
- Last Name
- Address
I want to hide First Name, Last Name, Address based on the value in Edit. Let say if user selects "Edit First Name" then First Name must get visible while Last Name & Address hidden.
So I placed this line onChange="$f_Hide_On_Value_Item(this,'LASTNAME,'LN')" in page item EDIT> Label > HTML Table Cell Attributes
But it not working for me? Where am I go wrong?
I have created tabular form. I have set LOV for one column. Here my requirement is when i select the value from lov then it will fetch that value into page item.
I am using apex 4.1
I have 20 item fields in same form. i need to align them in sequential manner. For example x y z abcl m o p q r s xyzabclmopqrs are the items to achieve this what i have to do...
View 2 Replies View RelatedI am facing this problem, not sure how to solve this. Basically, the default value of the "items" on the page don't get set when the session is cleared and I visit the page for the first time.
So when I check the session for the first time, all page items are null. But when I revisit the page, the page items gets set sometimes.
My collection is not working as expected, what could be the issue here. This is what i did,
1. I created a collection in a process to fire on page load
if apex_collection.collection_exists(p_collection_name=>'MMMM') then
apex_collection.delete_collection(p_collection_name=>'MMMM');
end if;
APEX_COLLECTION.CREATE_OR_TRUNCATE_COLLECTION(p_collection_name => 'MMMM');
2. On my page i have a text field P1_text1 when i enter value into text field like ="sample data" i want this data loaded into my collection, so i created a button and added a process(on submit - before computations...) so it should insert into the collection when i click the button but no data is loaded, process:
APEX_COLLECTION.ADD_MEMBER(
p_collection_name => 'MMMM',
p_c001 => :P1_TEXT1,
p_c002 => 'TESTDATA' );
3. when i run the below query it shows "no data found" ,
SELECT c001,c002
FROM APEX_COLLECTIONS
WHERE collection_name = 'MMMM';
Had some issues with a page on which i changed the value of an item using javascript and added a dynamic action (dummy pl-sql) that submitted the item. The problem was that if i also used $x_disableItem to disable the item in the function that set the value , the value submitted was always null. However if i used the "Disabled" attribute from the item Settings and remove the calling $x_disableItem in the function, the value submitted is correct.
To reproduce , create these objects on a page (default everything not specified):
<li>P1_VALUE - textfield
<li>P1_SET_VALUE - button calls "javascript:setValue();"
<li>P1_SUBMIT - submits the page
<li>Dynamic action:
- Event - Before Page Submit
- Execute PL-SQL (begin null; end;) - Page item to submit P1_VALUE
[code]....
So i have two questions:
1) Why is the implementation different (would have expected to behave in the same way)?
2) When using the javascript API function $x_disableItem , why is the value submitted null?
P.S: For the workaround i removed the $x_disableItem call with calling a custom function that toggles the read-only attribute of a given item.
Not able to open login page 101 in my internal application. I am getting below error
ORA-12170: TNS:Connect timeout occurred
Error Not able to get parameters values
OK
I would like to have a table in HTML region and to display in the table some Page Items from the page.
I got the code like this:
{
<table>
<tr><td>&P1_ECEMEA_ASSISTANCE</td></tr>
<tr><td>&P1_ECEMEA_WIP</td></tr>
</table>
}
It shows the Page Item names as text, not the values. However this code without the table tags:
{
ECEMEA Request for CQT Assistance: &P1_ECEMEA_ASSISTANCE.
ECEMEA CQT Work in Progress: &P1_ECEMEA_WIP.
}
works and the Page Item values are displayed.
Is it possible to display the Page Item values in the HTML table at all or I have to use a different method of showing the values in a table? The above is only a snippet of the code. I need to display about 30 Page Items, formatted in a table with headings.
what kind of region is the best to be used or if I should only use some escape symbols in the table code.
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 RelatedI'm trying to update a number field on an apex page by summing up the values of multiple page items. I've tried to follow this tutorial
[URL]........
especially the "Create a Set Value Dynamic Action Using PL/SQL" part.
In the tutorial example they return an page item value P3_SAL multiplied by a multiplier they've determined by another page item's case. What I want to do is much simpler in that I just want to add up multiple page item values and then display them in a number field at the bottom of the page.
so the code I tried to use based on the tutorial is in the tab: Home >Application Builder>Application 103>Page 3>Edit Dynamic Action>Create / Edit Action
Set Type: PL/SQL Function Body
PL/SQL Function Body:
BEGIN
return :P3_ITEM1+P3_ITEM2+P3_ITEM3;
END;
Page Items to Submit: P3_ITEM1,P3_ITEM2,P3_ITEM3
But it gives me an error that I need to declare the identifiers, yet it works if I only use one item and I can perform any arithmetic.
i.e.
BEGIN
return :P3_ITEM1+1000;
END;
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.
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.
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.
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?
I've been creating numerous sample applications. In my latest one, I've been working on custom security schema and it's been working great for the most part. The one issue I'm having is passing login values into my application items. Though I don't receive any error messages or anything, upon checking the value of the application items via the session button, they never contain anything. The code I have in place on my login page is as follows:
begin
select username, user_id
into :F56_USER_NAME, :F56_USER_ID
from GS_USERS
where username = lower( rtrim( ltrim( :P101_USERNAME ) ) );
[code].........
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 RelatedI 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,
I am trying to create a collection using bind variables in APEX 4.1. I have the following procedure but all I get is an error in the debug page DOH ORA-20104:
create_collection_from_query_b Error:ORA-01006: bind variable does not exist
My code is
DECLARE
l_names wwv_flow_global.vc_arr2;
l_values wwv_flow_global.vc_arr2;
l_names(1) := 'EXPENSE_FROM';
l_names(2) := 'EXPENSE_TO';
[code]....
how to create tabs with drop down submenu items like the ones we have under products tab in the link below.
[URL]
I have a simple shuttle:
1 Adam
2 Baker
3 Charlie
4 Delta
5 Echo
6 Foxtrot
Select Name D, UserID R from UserTable
The values are stored in a VARCHAR2 field MULTI_USER (for example 1:2:4:6) When I want to get the names back from the selected item, how do I reference the colon-separated items?
For example:
Select Name from UserTable
where UserID in (select MULTI_USER from MULTI_USER where MULTI_USER_ID = 1)
should return:
Adam
Baker
Delta
Foxtrot
I am trying to update a collection and a table.I got some example code and installed on oracle.com, but I just can't seem to get it to work.I always get an errorORA-20001: Current version of data in database has changed since user initiated update process.I think the problem lies with comparing the checksums, but I cannot spot the mistake
View 2 Replies View RelatedNote, I'm using APEX 4.1.1
The scenario is that I have tabular form that was manually created from a collection; the collection name is "COMPANY"
Within this tabular form, I have number of selection lists (apex_item.select_list) and for each, I fire off a JavaScript based on the "onchange" event (e.g.,'onchange="updateCollection(' || seq_id || ', 10, this.value)"'); updateCollection is a custom function I created. Right now, all it does is alert me with the specifics of the of the selection list. As a further example, if I select "Google" from the selection list, sequence id would be "1", attribute number would be "10" and attribute value would be "Google"
Within this JavaScript, I would like to update the value of this associated element in the "COMPANY" collection. Ideally, I would like to directly call this:
APEX_COLLECTION.UPDATE_MEMBER_ATTRIBUTE(p_collection_name => "COMPANY", p_seq => 1, p_attr_number => 10, p_attr_value => 'Google') but I could not figure out how to do this.
in our application, we're uploading .xls files with several (and heavy) sheets.
In order to get better performance, is there any way to load just one of them?
On a tabular form I have 50 columns each an input box , (basically 50 weeks of the year)
in these boxes I want to make them numbers only and max length 2
currently I have in the ELEMENT ATTRIBUTES for each column
OnFocus="javascript:this.maxLength=2"; onKeyPress="return numbersonly(this,event)";
( I have a function called numbers only in page 0 )
what I would like to do , to make it more maintainable is to remove all the calls in the element attributes of each column
and put it in 2 dynamic actions how would I go about this ?
I have tried using jquery selector of input:text to call javascript code on both events , Get focus and Key Press for every text box but its not working .
I created one collection report and in the report when i click on the next >> then the report will show the next columns to enter data in some columns but the data which i entered before going to next will not get retain (data is getting lost) when i come back by clicking << previous but i want the data to get retained even when i click on next >> or previous << in report so that i can enter large amount of data at a time in the report columns by clicking >> & << and click on submit button to save all the data.
View 3 Replies View Related