Please find the list of APEX articles that cover from the very basics to Advaced topics on APEX. Some of these articles contain video tutorials to help you get started.
Introduction to Oracle Application Express
Basic Concepts of Oracle Application Express
Oracle APEX - Person Details Audio Video Tutorial 01 (Search Page)
Oracle APEX - Person Details Tutorial 02 (Delete functionality)
Oracle APEX - Person Details Tutorial 03 (Create and Update Person)
Firebug - Essential tool for APEX/Web Developers
How to access Oracle Apps (EBS) tables/views in APEX
How to display company logo for APEX application?
How to get elapsed time for APEX region?
APEX Security:
How to login to APEX with EBS login credentials (Authentication Scheme)
Security using Authorization in APEX
Prevent URL tampering using APEX Session State Protection
Save State before branching - New Security feature in APEX 3.2
Maintaining authentication between APEX applications
Apps2Fusion Articles 
Comments
I am soon gonna get a new requirement to create Dashboard using APEX.
Do I need to have a Java resource with me to handle it ?
If so, then how they can be helpful to me? I am not aware of Dashboards much.
Kindly suggest.
thank s,
Nirmal
I created a flash chart in APEX of type "2D Column". When I run the page, it displays "waiting for data" with a processing sign.
Its not displaying any chart at all. The page processes (waiting for data) indefinetely. What could be the fault?
Kindly suggest.
Than ks,
Nirmal
Thanks in advance
Thanks for hardwork. It's a good article
Could you possibly send me sample MD50/70 for any Oracle APEX?
My E-mail: tommyszh
Thanks,
Tommy
I am a beginner in APEX, but experience in Oracle Designer and Forms.
I was wondering if it's possible to create a master detail page with multiple tabs(details)? like with Oracle Designer?
Much appreciated!
F red
In APEX, how can we create screen mockup (prototypes). I read somewhere that we can definetly do that but couldnt get any good information. I am currently using some free tool (Axure RP) to develop the screen prototypes.
Please direct me if we can do that using APEX drag&drop feature.
Thank s,
-Seenu
Please let us know whether licence is required for using Oracle Application Express or it is a freeware for us
I need to change the back-ground colour of my APEX region. Currently its in grey.
Kindly suggest how to do it.
Thanks,
Ni rmal
1. If it is one-time time for a single page, then identify the css class for the region. For example: t3instructionte xt for theme 3. In page Header Text attribute, add the below script
|style type="text/css"|
.t3instructionte xt {background-col or:#00ff00 }
|/style|
This overrides the display attributes for that region.
2. If you want to change background color for region in all the pages where it is used. Then you need to create a custom region template in shared components. First create a custom css with class attributes of your preference, and upload css as static file in shared components. Make a copy of region template and give a custom name. Then you can attach custom css and change region class attribute to custom class attribute in your css.
You can link your custom css using
|link rel="stylesheet " href="#WORKSPAC E_IMAGES#SAMPLE 2A.css" type="text/css" |
Please note I'm using pipe sign for bracket for html tags because my html tags are getting stripped in comments section
Kishor e
I used same MD50/Md70 as in AIM documentation.
Kishore
I have one tabular form. I want to add browse button column in that form. I cannot add that field directly as tabular form is not supporting blob data. Is there any solution to add browse button column to tabular form and upload files?
I have added one NULL column for upload document. and used html expression
a nd written process to upload cv as:
BEGIN
FOR I IN 1..APEX_APPLICA TION.G_F40.COUN T
LOOP
INSERT INTO document(doc_ID , doc_TYPE, LANGUAGE, doc_DATE, FILE_REF, MIME_TYPE, person_ID )
SELECT doc_SEQ.NEXTVAL ,
1,
1,
SYSDATE ,
BLOB_CONTENT,
MIME_TYPE,
APE X_APPLICATION.G _F02(I)
FROM WWV_FLOW_FILES WHERE NAME = APEX_APPLICATIO N.G_F40(I);
DE LETE WWV_FLOW_FILES WHERE NAME = APEX_APPLICATIO N.G_F40(I);
END LOOP;
END;
but still it is not uploading file in the database.
can anyone help me "What is the Problem with above code?"
When we are creating file browse button then it creats
a class="eLink" tabindex="999" href="/old/[removed] popupURL('f?p=4 000:371:3494102 961234719::::P3 71_ID,FB_FLOW_I D,FB_FLOW_PAGE_ ID:118951257731 1801,101,40');" title="Edit">
and one hidden field whose value equals to 118951257731180 1 (it changes per item)
As I have created Null column for browse button it is not creating as well as not creating hidden item.
That's why I am not getting file uploaded .... So is there any solution for this problem?.....Pl ease help me on this .....
Inside my apex page, I need to have multiple tabs similar to Sales Order form in OM and Enter and Maintain form in HRMS.
How can I achieve this in APEX?
Thanks,
Nirmal
Person ally I've tried tabbed region in a page. I saw couple of examples of extjs library. These links might help.
http://oracleinsights.blogspot.com/2008/06/tabbed-regions-in-oracle-apex-using.html
http://apex.oracle.com/pls/otn/f?p=65555:54:4411438880491348::NO:
Thanks
Kishore
Thanks for the knowledge pool you have put together for APEX.
I am kind of new to APEX and working my way out :) ....
I have a question w.r.t conditional display of values in dropdown.
There are dropdown combo lists in a region (on a single page). And these 3 dropdowns are dynamic LOVs coming from different database table.
i.e. Dropdown1 --> Table1
Dropdown2 --> Table2
Dropdown3 --> Table3
My goal is to show only first dropdown when a user comes to that page first time. And depending upon the selection made from the first dropdown, I want to show the second dropdown (only for few values in 1st dropdown this second dropdown should be shown) and subsequently based on the value selected from second dropdown, the third dropdown should show a refined list which is a subset of all the rows in table 3.
If someone else have confronted with similar kind of issue , please let me how you worked on it or direct me.
Thanks,
-S eenu
Check the section "Adding a Dependent Select List" in below URL
http://www.oracle.com/technology/obe/hol08/apexweb20/ajax_otn.htm
I would do it this way for filtering employee list based on department list. I put a page together on apex.oracle.com
1. Create a department select list base it on dynamic lov
2. Create an application item in Shared components. Name it F_DEPT_NO
3. Create employee LOV using bind variable. Something like this.
select empno r, ename d from emp where deptno = :f_dept_no
4. Now that employee select list is based on f_dept_no application item. We have to set value to it on change of department select list
5. So in onChange event of department select list, call an application process to set selected value to f_dept_no
Hope this helps
Kishore
In step (5) , how do I create an application process and use it to set the application item. I have gone thru the URL you mentioned but there its creating an on-demand process using AJAX and referencing that in the page header.
Thanks,
-Seen u
Just wanted to followup with my last posting dated Dec 23. If someone else on this forum faced this issue please let me know how you resolved it.
Thanks,
-S eenu
I create sample page on apex.oracle.com . This site is running like a snail for last few days. Anyways you can access by logging into http://apex.oracle.com/pls/otn/f?p=a2f_main with a2f_admin/a2f_u ser. Chose Random Examples in navigator and click on Dependent LOV.
Here are the step by step instructions.
1. Created application item for department in shared components. Named in APP_DEPT_NO
2. Employee LOV in shared component uses above application item as bind variable. Query used is
select ename d, empno r
from emp
where deptno = :app_dept_no
or der by 1
3. Create On demand application process setAppDeptNo using below pl/sql
DECLARE
l_deptno number;
BEGIN
l_deptno := apex_applicatio n.g_x01;
htp.prn('l_dept no=' || l_deptno);
:APP_DEPT_NO := l_deptno;
EXCE PTION
WHEN OTHERS THEN
htp.prn('E rror in setDeptNo' || sqlerrm);
END;
4. Javascript in page html header text. This is for calling on demand application process. It is apex implementation of ajax request. Please note I replace '' with ')' in below javascript. This comment section doesnt allow me to use html tags.
(script type="text/java script)
functio n f_setDeptNo()
{
var get = new htmldb_Get(null ,$v('pFlowId'), 'APPLICATION_PR OCESS=setAppDep tNo',0);
get.addParam('x 01',$v('P13_DEP T_HIDDENVALUE') );
gReturn = get.get();
}
(/ script)
4. Call this javascript from onChange event of department lov. Use onChange="f_set DeptNo();" in html form element attributes.
E xample given in http://www.oracle.com/technology/obe/hol08/apexweb20/ajax_otn.htm#t1 uses select list. Im using Popup Lov. For employee like lov, it is better to use popup lov as dont have to fetch all thousands of employees (in real-time) on page load.
I'll put together an article if possible.
Kish ore
I would like like to show alternate colors for my subtotals or groupwise. also for grand total.
Kindly suggest for making it.
i can show same color - yellow for subtotal and grandtotal under
Report Attributes -> Break Formatting -> #COLUMN_VALUE#
Thanks
How do i enable the show values check box for Stacked 2D column flash chart, in Apex
Thanks in Advance...
what is the roles and responsibilitie s of DBA and Development team in APEX??
Thanks in advance
Just wanted to let you know about a new resource for APEX developers, consultants, and customers.
http://apex.justdoes.it
It's a community that is free to join, and allows you to both UPLOAD APEX applications that promote your company or service, and DOWNLOAD applications, both free and proprietary, which may be useful for you.
If you're interested, feel free to check it out.
Thanks, and have a great day!
migrating oracle forms converted to xml file
using 11g & apex 3.2. 10g Forms
In application migration project only Access Type
selection is coming . but uploading xml file i need Form Type . How to solve it
I have a column used in the tabular which has to be substituted with a bind variable such as :P101_USERNAME only when updated. I cannot use APP_USER/ Please advise....
Tha nks
KRIS
You can use APEX_CUSTOM_AUT H.GET_USERNAME function to get logged in user name.
Kishore
I designed one form in 10g compiled and generated xml without any button pallets to this form and tried converting into apex 3.2 - successful converted.
scenario 2 - I tried converting a form which already has button pallets and go buttons etc. in forms = while converting it is treating all buttons as columns and even after converting them as non database columns - still i am not able to achive the same look and feel and couldn't succeed successfully.
2. How to build Menu Application with drop down menu for the users to click and access those forms.
thanks in advance if you can put some light on this and assist me with the same.
many thanks
savio
i just installes oraclexe universal and then installed apex3.2. when i tried to connect to sqlplus , an error is shown as " sqlplus is not an internal or external command......" could you pls tell me what is the problem.
Thanks,
Maggie
I would like to see all the tables and views that a page uses.
Do you know how I can see this information in Apex 3.2?
Thanks,
Ma ggie
First , I am not having very much luck knowing if my comment is getting through to you. I keep getting error messages at the top of the comment section. This area 'Write Comment' is not user friendly. Nothing against you though, just the comment section is difficult and caused me stress. As an Oracle Apex developer, I do not need anymore stress. LOL
I would like to see all the tables and views that a page uses.
Do you know how I can see this information in Apex 3.2?
Thanks,
M aggie
I apologize the comment section being not friendly. To answer your question, I dont know a straight forward way to do it. You can check 'Application Expression Views' under 'Utilities' to write a query using appropriate views. Refer this link http://forums.oracle.com/forums/thread.jspa?messageID=2606726�
Kishore
Please check 'path' variable in windows. It should contain the folder where sqlplus executable is.
Kishore
I would like to know how can I generate a chart of different series with the same colour.
For instance UCL and LCL of a PBC chart (Two series in red
After just going through your labs I feel I'm starting to get to grips with what APEX can do. It's developed into a very nice tool.
Just a quick question - when a field is a required field you do not get a graphical indicator in the same way you do with say OAF pages (the little blue circle) - is there any way you know where you can enforce such a thing - other than creating a new item for it and programatically populating it (I'm guessing you can programatically query the attributes of a field like you can in say - Oracle Forms).
I am new to Apex
I have two tables (Master and Child) for simplicity sake lets say Orders and Order Details
Howeve r I need to split the fields of the Order Details between two tab pages
So I now have 3 tabs(A,B,C)
Ta b A is Orders (PK order#)
Tab B is(Order Details )--Need to capture and display the Product Name on Tab B for the same Order#
Tab C is(Order Details )--Need to capture and display the Product Price on Tab C for the same Order#
My question is how do I carry the primary key on Tab A through to Tab A and B so that when I save/navigate to TAB B and C
only values pertaining to Order# currently in Tab A are shown?
TAB A (Orders) TAB B (Order Details) TAB C (Same Order Details table)
Order #1 Pk Order #1 fk Order #1 fk
Product Name Product Price
Please help, I am not winning with the multiple page branches especially when one table info is spread over two tabs.
How can I carry through the order # Pk through to the other two pages?
I have a deadline and this is stressing me out.
Thanks.
I have two tables (Master and Child) for simplicity sake lets say Orders and Order Details
Howeve r I need to split the fields of the Order Details between two tab pages
So I now have 3 tabs(A,B,C)
Ta b A is Orders (PK order#)
Tab B is(Order Details )--Need to capture and display the Product Name on Tab B for the same Order#
Tab C is(Order Details )--Need to capture and display the Product Price on Tab C for the same Order#
My question is how do I carry the primary key on Tab A through to Tab A and B so that when I save/navigate to TAB B and C
only values pertaining to Order# currently in Tab A are shown?
TAB A (Orders) TAB B (Order Details) TAB C (Same Order Details table)
Order #1 Pk Order #1 fk Order #1 fk
Product Name Product Price
Please help, I am not winning with the multiple page branches especially when one table info is spread over two tabs.
How can I carry through the order # Pk through to the other two pages?
I have a deadline and this is stressing me out.
Thanks.
Thanks for this wonderful knowledge on APEX.
A quick question, I am trying to store a hyperlink(url) value in a field so that, users can just click on it and go the webpage stored in that field.
For example...I have a field called "Webpage" and I am planning to store a url like http://www.apps2fusion.com for each record. So, the user should be able to click on this link from this "Webpage" field, so that, they will open a website in a new window.
Could you please let me know.
I appreciate all of your help.
Thank you in advance,
Venkat.
If it is static url, you can store it in Shared Components > Shortcuts. Add a column link for a report and give it in the URL.
Kishore
Thank you,
Venkat.
When I create a Shortcut, what should be the source? And, where do I need to define actaul website address?
Also, how do I Add a column link for a report and give it in the URL?
Can you please give me little more details.
Thank you in advance,
Venkat .
I am trying to store the data other than wwv_flow_files how can i do it.
Please share your knowledge and help me out !!!
Thanks
i have created report using sql in one table and i need to sort the table because the sort element does not work for that table. could anyone help me
I am new to APEX.
I have manually created DHTML list using lists in APEX. I want to create it dynamically using tables.
I tried but not worked for me.
i choose DHTML list because i want it in (+) sign when click on it all sub list entries should be displayed
and also wanted to create something like when user click on one particular sub entry it should be saved in database
with other fields of table.
Was just wondering if any one came across this sort of query or design.
Thanks in Advance
Regard s,
Digisha
i am trying to put some sql plus commands together,like the following,
set feedback off
set echo off
set linesize 10000
set heading off
set pagesize 0
set trimspool on
set space 0
set truncate on
spool myout.lst
select 1 from dual
exit
to be invoked by a buttom on the apex webpage.But it doesn't work.
could anyone help me ?
Can they be embedded to the javascript?
Th anks.
Sarah
How would I do the following in APEX.
Have an application , theres nothing special about the application. I want a button that will allow me to change the colour of the blackground and text colour when I click it. I want to change the background to Black and the text colour to yellow leaving everything else the same.
If you have any pointers that'd be great. ...
thanks
Will u plz help me in sending mail using oracle apex.
I have created a Display item say Voucher Date and also created another Drop Down item containing some Values. Eg Between, Less than, Equal to etc.
Now i want the following.
Whe n the user selects the value Between, two text box should appear and accept the dates
When the user selects the Value Less than, then only one text box should appear and accept the value
Is it possible in Apex? If so, kindly advice and provide me a solution.
Than ks
Rajesh V
Am entirely new to Oracle apex,I need to develop one application for that I need to create the login page , when the user
enters there username and password it should be redirected to next page which is a form to enter their details,
Can you please kindly tel me where to start and how to proceed.Am new to this please guide me.
Thank you,
With regards,
Gurujo thi.D
I am making a mobile application,
th e problem is that as i use the POPUP LOV instead of select list so the label is above and the select list textbox is below.
But other label and textbox are in same line.
what do i do to align them properly, So that the textbox will align below the label??????? :(
response quickly please.
Thank you.
With regards,
Nisha
your sites really nice, keep it up! I'll go ahead and bookmark your website to come back in the future.
All the best
Hi All,
I am trying to call my APEX page in my APEX application from within Oracle eBusiness suite - Just to try out some customisation options,
I have followed the whitepaper about EBS and APEX integrations - http://www.oracle.com/technetwork/developer-tools/apex/learnmore/apex-ebs-extension-white-paper-345780.pdf
1. I have set the profile option FND: APEX URL at site level, so it points to my APEX url -> http://:8080/ap ex (I have replaced on the EBS_Hostname to my instance and that works correctly)
2. I have all the required application items on my APEX application so that I could pass the User ID, Responsibility ID and security group ID with exactly same name as used in the below call out
3. I have created a function security in E-Business so that it points to the HTML (To my APEX application page) -> GWY.jsp?targetA ppType=APEX&p=1 03:2:::::EBS_RE SP_ID,EBS_APP_I D,EBS_SEC_GROUP :[RESPONSIBILIT Y_ID],[RESP_APP L_ID],[SECURITY _GROUP_ID]
Note: 103 is my APEX application ID, 2 is the Page to which it needs to redirect
4. I have cleared the cache from Functional administrator responsibility and now I can see the new menu entry (Pointing to my function security created) n my E-Business relevant but when I click on it - it does not bring up the APEX page nor it brings the login page
Re-direct URL when I click on the EBS function security is
http:///OA_HTML/GWY.jsp?targetAppType=APEX&p=103%3A2%3A%3A%3A%3A%3AEBS_RESP_ID%2CEBS_APP_ID…
Would be great if anybody has already done something similar
I have also bounced the apache / middle tier
Thanks
Shasi
Hi Shasi,
I am also having difficulties for calling from EBS to APEX application page. I see ur comment above, did you have any success?
Thanks,
Rchen
RSS feed for comments to this post