Apps To Fusion

.......contents copyright protected by FocusThread UK Ltd

 
  • Increase font size
  • Default font size
  • Decrease font size
We are glad to announce the launch of Forum for Customizations and Extensions. Click here to visit http://apps2fusion.com/forums
Our OA Framework, BPEL Development & Apps DBA Trainings from USD 299 only [on weekends] . Click here for details.
Also see here fully verifiable feedbacks/testimonials


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 (19)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
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