Apps To Fusion

.......Our Journey from Apps To Fusion

 
  • Increase font size
  • Default font size
  • Decrease font size
We have launched several Development, Functional and DBA Trainings. Visiti http://focusthread.com/training

APEX - Oracle Application Express

Thursday, 14 May 2009 20:45 Kishore Ryali
 E-mail | Print | PDF 

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.

Kishore Ryali

 

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

Application Items 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

 

Comments (28)add
Reg. Dashboards
written by Nirmal , August 14, 2009
Hi Kishore,

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.

thanks,
Nirmal
report abuse
vote down
vote up
Votes: +0
Problem with Flash chart
written by Nirmal , August 21, 2009
Hi,

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.


Thanks,
Nirmal
report abuse
vote down
vote up
Votes: +0
MD50/70
written by Abhishek Krishnan , October 02, 2009
Hi Kishore...Excellent site for beginners.....Anyways could you possibly send me sample MD50/70 for any Oracle APEX hands on project that you have.
Thanks in advance
report abuse
vote down
vote up
Votes: +0
Master detail(tabs) Pages
written by Fred , October 26, 2009
Hi Kishore,

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!

Fred

report abuse
vote down
vote up
Votes: +0
Screen mockups using APEX
written by Seenu007 , November 10, 2009
Thanks Kishore for your wonderful tutorial.

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.

Thanks,
-Seenu
report abuse
vote down
vote up
Votes: +0
Oracle application express - licence
written by S Uma , November 22, 2009
We have licence for Oracle 10g database, but don't have licence for Oracle 10g application server (AS).

Please let us know whether licence is required for using Oracle Application Express or it is a freeware for us
report abuse
vote down
vote up
Votes: +0
How to change APEX region background colour.
written by Nirmal , December 07, 2009
Hi Kishore,
I need to change the back-ground colour of my APEX region. Currently its in grey.
Kindly suggest how to do it.

Thanks,
Nirmal
report abuse
vote down
vote up
Votes: +0
Re: How to change APEX region background colour
written by Kishore Ryali , December 08, 2009
Nirmal,

1. If it is one-time time for a single page, then identify the css class for the region. For example: t3instructiontext for theme 3. In page Header Text attribute, add the below script

|style type="text/css"|
.t3instructiontext {background-color:#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" rel="nofollow" href="#WORKSPACE_IMAGES#SAMPLE2A.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

Kishore
report abuse
vote down
vote up
Votes: +0
Re: MD50/MD70
written by Kishore Ryali , December 08, 2009
Abhishek & Tommy,

I used same MD50/Md70 as in AIM documentation.

Kishore
report abuse
vote down
vote up
Votes: +0
Inserting multiple files using single tabular form
written by Punam , December 15, 2009
Hi,

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



and written process to upload cv as:

BEGIN

FOR I IN 1..APEX_APPLICATION.G_F40.COUNT
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,
APEX_APPLICATION.G_F02(I)
FROM WWV_FLOW_FILES WHERE NAME = APEX_APPLICATION.G_F40(I);

DELETE WWV_FLOW_FILES WHERE NAME = APEX_APPLICATION.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" rel="nofollow" href="/[removed]popupURL('f?p=4000:371:3494102961234719:::smilies/tongue.gif 371_ID,FB_FLOW_ID,FB_FLOW_PAGE_ID:1189512577311801,101, 40');" title="Edit">

and one hidden field whose value equals to 1189512577311801 (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?.....Please help me on this .....


report abuse
vote down
vote up
Votes: +0
How to add tab pages inside APEX page
written by Nirmal , December 17, 2009
Thanks Kishore.. I got one more favour.
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
report abuse
vote down
vote up
Votes: +2
Re: How to add tab pages inside APEX page
written by Kishore Ryali , December 17, 2009
Nirmal,

Personally 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
report abuse
vote down
vote up
Votes: +0
Conditional display in dropdown
written by Seenu , December 23, 2009
Hi Kishore -

Thanks for the knowledge pool you have put together for APEX.

I am kind of new to APEX and working my way out smilies/smiley.gif ....

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,
-Seenu
report abuse
vote down
vote up
Votes: +0
Re: Conditional display in dropdown
written by Kishore Ryali , December 23, 2009
Hi Seenu,

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
report abuse
vote down
vote up
Votes: +0
Re: Conditional display in dropdown
written by Seenu , December 23, 2009
Thanks Kishore for your response.

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,
-Seenu
report abuse
vote down
vote up
Votes: +0
Re: Conditional display in dropdown
written by Seenu , December 28, 2009
Hi Kishore -

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,
-Seenu
report abuse
vote down
vote up
Votes: +0
Re: Conditional display in dropdown
written by Kishore Ryali , December 28, 2009
Hi Seenu,

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_user. 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
order by 1

3. Create On demand application process setAppDeptNo using below pl/sql

DECLARE
l_deptno number;
BEGIN
l_deptno := apex_application.g_x01;
htp.prn('l_deptno=' || l_deptno);
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/javascript)


Example given in http://www.oracle.com/technolo...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.

Kishore

report abuse
vote down
vote up
Votes: +0
Backgroup color for subtotals and grand total
written by Rajinikanth , March 05, 2010
Hi,

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
report abuse
vote down
vote up
Votes: +0
Apex Falsh Chart
written by Joe , March 23, 2010
hi,
How do i enable the show values check box for Stacked 2D column flash chart, in Apex

Thanks in Advance...
report abuse
vote down
vote up
Votes: +0
Oracle APEX
written by swapnil , April 08, 2010
How the the Markert is responding to Oracle apex i.e are the Companies prefering the APex for web development

report abuse
vote down
vote up
Votes: +0
Tech Sales Consultant
written by Emmanuel , April 14, 2010
Hi,

what is the roles and responsibilities of DBA and Development team in APEX??

Thanks in advance
report abuse
vote down
vote up
Votes: +0
New APEX Resource
written by Michael Lum , May 14, 2010
Hi Kishore,

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!
report abuse
vote down
vote up
Votes: +0
Problem in Orace APex
written by HASEEB kHAN , June 15, 2010
plz. help me , facing problem in
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

report abuse
vote down
vote up
Votes: +1
Problem with tabular form
written by KRIS , July 12, 2010
Hi Kishore,

I have a column used in the tabular which has to be substituted with a bind variable such as smilies/tongue.gif101_USERNAME only when updated. I cannot use APP_USER/ Please advise....

Thanks
KRIS
report abuse
vote down
vote up
Votes: +0
Re: Problem with tabular form
written by Kishore Ryali , July 13, 2010
Kris,

You can use APEX_CUSTOM_AUTH.GET_USERNAME function to get logged in user name.

Kishore
report abuse
vote down
vote up
Votes: +0
oracle forms conversion to Apex
written by Sushil T , July 14, 2010
Hi ,

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.
report abuse
vote down
vote up
Votes: +1
design and develop a business dashboard application using apex
written by savio , July 29, 2010
can u pls show me an example of dashboard creation using apex as i am new to apex. i need to do a business dashboard, could you pls send me the steps to create dashboard in apex or any examples which i can refer.
many thanks
savio

report abuse
vote down
vote up
Votes: +0
Write comment
quote
bold
italicize
underline
strike
url
image
quote
quote
smile
wink
laugh
grin
angry
sad
shocked
cool
tongue
kiss
cry
smaller | bigger

security image
Write the displayed characters


busy