Login
Register

Home

Trainings

Fusion Blog

EBS Blog

Authors

CONTACT US

Kishore Ryali
  • Register

Oracle Gold Partners, our very popular training packages, training schedule is listed here
Designed by Five Star Rated Oracle Press Authors & Oracle ACE's.

webinar new

Search Courses

A basic requirement in most implementations is displaying company logo. This article shows how to achieve it in Application Express.

Requirement:
Display Apps2Fusion logo on Person Details application http://apex.oracle.com/pls/apex/f?p=62577. To take step forward, I want to make the image clickable to redirect user to apps2fusion website in separate window.


Implementation:

Brief Steps are

 

  • Upload company logo image in Shared Components > Images > Create button.
  • Go to Shared Components > Definition (Under Application section). In Logo section, enter logo type as Image and logo as #WORKSPACE_IMAGES#a2f_logo_s.JPG. #WORKSPACE_IMAGES# is a substitution string which is replaced with actual location of image.
  • To make logo clickable, enter logo type as Text and logo as Apps2Fusion.com

Why I switched to logo type as Text to implement clickable logo?

When logo type Image is chosen, APEX uses img tag to display image. You can use logo attributes (field below logo) to set image attributes like width, height etc. There is no href attribute for img tag unlike anchor tag. So I wrote html tags bundling anchor and image tags, to put them under logo type Text. #WORKSPACE_IMAGES# substitution string is still applicable in HTML text.

Lets see the detailed steps .
  • Go to Shared Components > Images (Under Files section). This displays all the available images in application. Choose create to upload new image. Note that application field is optional.
  • Go to Shared Components > Definition (Under Application section). For non-clickable logo, choose logo type as Image and logo as #WORKSPACE_IMAGES#a2f_logo_s.JPG. I've used logo attributes for setting alternate text and title. Alternate text (alt) is used when image cannot displayed.
 

 

  • For clickable logo, choose logo type as Text and logo as Apps2Fusion.com. This HTML text is image tag wrapped around anchor tag with href and target attributes.

 

  • Apply Changes and run the application.


Apps2Fusion logo is shown in top left portion of the application.

How #WORKSPACE_IMAGES# substitution string works?
Viewing page source is good way to check how substitution strings are replaced. In case of  #WORKSPACE_IMAGES#a2f_logo_s.JPG substitution string, it is replaced with a function call wwv_flow_file_mgr.get_file?p_security_group_id=5937624817042064053&p_fname=a2f_logo_s.JPG
where p_security_group_id is workspace identifier. Package wwv_flow_file_mgr is in FLOWS_020100 which APEX 3.2 schema. wwv_flow_file_mgr.get_file fetches file from APEX_WORKSPACE_FILES table which contains images, css files and javascript files. Since APEX_WORKSPACE_FILES is one-stop table for above files, to reference css/javascript files in HTML code you can use same substitution string #WORKSPACES_IMAGES# like #WORKSPACE_IMAGES#custom.css or #WORKSPACE_IMAGES#customjs.js

 

What is difference between #WORKSPACE_IMAGES# and #APP_IMAGES# substitution strings?
APEX Workspace can contain one or more applications. If application field is left NULL when creating an image, image take global or workspace scope. It means it is not attached to any specific application.

#WORKSPACE_IMAGES# substitution string is used for accessing workspace and application images. It is replaced with wwv_flow_file_mgr.get_file?p_security_group_id=&p_fname=

#APP_IMAGES# substitution string is used for accessing only application images. It is replaced with wwv_flow_file_mgr.get_file?p_security_group_id=&p_flow_id=&p_fname=
Note the extra parameter p_flow_id added to same function call.

If image is workspace image, #APP_IMAGES# substitution string cannot be used.


What is difference between #WORKSPACE_IMAGES# substitution string and /i/ notation for accessing images?
/i/ notation can also be used for accessing images. /i/ points to physical directory on the server  where images are located. Suppose if APEX3.2 is installed on windows, /i/ points to \apex\images. For above requirement if I placed logo file in physical directory, I can use logo Image as /i/a2f_logo_s.JPG

Which notation to use? Personally I prefer #WORKSPACE_IMAGES# notation as I can upload images from APEX application which does not require access to server physical directories. I can also see the images in Shared Components > Images when they are uploaded from APEX application.

URL for the application:

My application can be accessed using the url http://apex.oracle.com/pls/apex/f?p=62577:1

 

 

Kishore Ryali

Comments   

0 #1 lakshman 2009-06-08 08:49
I am using only oracle erp 11.5.10.2 is it possible for change the logo. pls tell how. more usefull ur source but am not using fusion

advance thanks.
Quote
0 #2 Kishore Ryali 2009-06-08 10:54
Hi,

If you are talking about changing Oracle logo to your company logo in 11i, please follow instructions in metalink note 395663.1

Thank s
Kishore
Quote
0 #3 Saravanan Ayyanar 2009-06-18 19:53
Hi

I have concurrent program defined. I have added the debug message in the program to track the status. When I run this program, I couldn't see this message. Once this program is completed, I could see the debug messages.

When program is running, I want to see the debug messages. Can you please help me on this.

Regards
Saravanan.A
Quote
0 #4 Kishore Ryali 2009-06-19 08:54
Saravanan,

You may write your debug messages to custom error table and include it in autonomous transaction if you dont want to commit in your original program.

Kisho re
Quote
0 #5 naushad 2010-06-13 06:17
Hi, Thanks a lot for this tutorial. Do you have a tutorial on how to create Dependant LOV (you have created this on your apex workspace)?

Th ank you very much.
naushad.
Quote
0 #6 susan mark 2010-07-17 05:03
Thank you very much for posting such valuable information. As i am associated with Logo Design & Web Banner Business, so i am very well aware of usefulness of the info..
Quote
0 #7 susi jhons 2010-07-17 05:04
hank you very much for posting such valuable information
Quote
0 #8 Jaganmohan 2010-08-09 10:28
How does it handle in Apex 4 ? It gives Error ERR-7620 Could not determine workspace for application ().


Jaganmohan Krishnamoorthy
REDKNEE India.
Quote
0 #9 Jaganmohan 2010-08-11 02:58
Displaying logo in Apex 4.0

Finally, I could able to display logo in Apex 4.0 , after removing prefix and using #WORKSPACE_IMAG ES# substitution string.

Thanks .
Jaganmohan Krishnamoorthy
REDKNEE India.
Quote
0 #10 Emmanuel 2010-11-04 12:12
I wish I could find such informative sites more often. I regularly spend much time on lust looking for some worthy sites when I can find something to read. Your site is surely one of them. I wish you futher success. My site – search engine on rapidshare files. Hope to be useful for someone
Quote
0 #11 anna123 2010-12-04 13:34
I follow your advice to display logo of the company.
But it is not working.
And what is this htlmdb in path of image?

Please explain in details.

and hossain,
If your problem is solved then you please help me.
I would be thankful to you.

regards,
http://paraorkut9.org/
Quote
0 #12 Kaithy Aravind Reddy 2011-01-12 07:47
Thanks Kishore, I was looking for this .. good.
Quote
0 #13 custom logo design 2011-05-31 08:42
it has been an awesome article very informative and helpful
custom logo design
Quote
0 #14 James 2011-07-15 03:42
@anilpassi Hi, I am Kenyan living and working in Nairobi in an IT environment. I am currently developing an application using Oracle Apex and am new to it and I have a few problems that I think you can help me out.Kindly assist since I seem to be stuck. The problems are

1. I am not able to resize my logo to a small logo on top of the pages.
2. I am not able to arrange my pages for the regions to appear column-wise..i. e region for navigation bars to the left,center for main texts and lright column for announcements/a dverts for my intranet to look smart and organised.
3. Lastly, in my entry application screen, I am not able to press enter key so that it goes to the next field.

Kindly assist.

Thanks

James

my email is

Jemo2009

Joined: Fri Jul 15, 2011 7:20 am
Quote
0 #15 Cheap Logo design 2011-08-18 01:54
i am so excited to read your post. i appreciate your thoughts and ideas. thanks for sharing with us.
i just bookmarked your site and i will share it with others. :)
Quote
0 #16 Garden Seed 2012-03-28 07:31
These are really great tips. Thanks for sharing them with us.
Quote
0 #17 web design bangalore 2012-04-12 00:57
I wanted to thank you for this great blog! I really enjoying every little bit of it and I have you bookmarked to check out new stuff you post.

http://www.nuvodev.com/
Quote
0 #18 window blinds 2012-04-12 09:27
Thanks for sharing such a nice post
regards...
Quote
0 #19 Atanas 2012-11-13 09:48
Thank you, it worked for me in APEX 4.2 although the path is slightly different
Share d Components
User Interface Attributes
Logo

Please, Is there a way for the logo to be conditional that is - with a multilanguage site to display logo_en.jpg or logo_fr_jpg or logo_es.jpg depending on page language chosen?
Quote
0 #20 Atanas 2012-11-16 06:52
To answer my last question myself: it is possible to have a substitution sting in the file name itself.
I use the FSP_LANGUAGE_PR EFERENCE application level item to store the current language.

So I just named my logos en_logo.gif, fr_logo.gif es_logo.gif and then for the image used

#WORKSPACE_IMAGES#&FSP_LANGUAGE_PR EFERENCE._logo.gif
Quote
0 #21 sigi 2013-09-18 15:05
Hi
this is in regards to the user requirement where i have created a interactive report and deployed the page into ebs.
Now the user said that the report should run according to the user who login from ebs of that particular region.
my interactive report runs for all regions and i should not show all the regions to the particular user
Example:le ts say that a user from capetown has logged in from ebs. if he clicks the resposibility with the page it should display only the capetown details but not other regions
Quote
0 #22 kinjal 2015-07-14 13:02
Hi Kishor,

I want to add a image on home page. How do we achieve it?
Please assist me.

Regards,
Kinjal
Quote
0 #23 парсинг магазина 2021-08-05 15:56
Я не даже, как я сюда попал, но я подумал, что этот пост хороший.
Я не знаю, кто вы, но определенно вы идете к известному блоггеру, если
вы не уже;) Ура!
Quote
0 #24 coin scam 2022-02-08 10:09
As a result, the land site all of a sudden disappears, and there are
oft cases of equipment casualty that they can't win money regular though they agree
the back.
Quote
0 #25 Rugpull 2022-02-21 12:46
Rugpull
Quote
0 #26 verify toto 2022-02-26 15:25
verify toto
Quote
0 #27 슈어맨 2022-03-01 09:41
The selective information you're weft up on the Toto locate!
Quote
0 #28 eat and run 2022-03-02 10:33
eat and run
Quote
0 #29 먹튀 2022-03-21 17:40
먹튀
Quote
0 #30 토토사이트 순위 2022-03-24 21:21
토토사이트 순위
Quote
0 #31 토토사이트 주소 2022-04-01 15:48
I’m really enjoying the plan and layout of your blog.
Quote
0 #32 thinfi.com 2022-04-05 09:23
What’s up, yeah this clause is real exacting and I consume erudite tidy sum of things from
it on the theme of blogging. thanks.
Quote
0 #33 토토사이트 추천 2022-04-30 16:13
Hey! I cognise this is middling hit theme but I was
speculative which web log weapons platform are you victimization for
this internet site? I’m acquiring FRS up of WordPress because
I’ve had problems with hackers and I’m looking at alternatives for some other chopine.
I would be amazing if you could repoint me in the counselling
of a upright political platform.
Quote
0 #34 토토사이트 2022-05-07 02:31
I consume been absent for about time, simply in real time I remember wherefore I victimized to love this blog.

Give thanks you, I’ll attempt and ensure spinal column More ofttimes.

How frequently you update your website?
Quote
0 #35 www.21yibiao.com 2022-05-08 19:33
I accept been abstracted for about time, merely in real time I recollect why I put-upon to lovemaking this blog.
Thank you, I’ll try on and chip rear More oftentimes.
How frequently you update your website?
Quote
0 #36 툰타임 2022-07-02 05:08
Patch on with this write-up, I absolutely
believe that this situation needs ALIR more care.
Quote
0 #37 KTX토렌트 2022-07-02 10:15
Hello, I savor recitation through and through your put up.

I the likes of to indite a small comment to endorse you.
Quote
0 #38 건마바다 2022-07-03 04:26
Wow, awe-inspiring web log layout! How hanker stimulate you been blogging for?
Quote
0 #39 byzaixian.com 2022-07-16 23:27
I want to to thank you for this wonderful read!!

I absolutely loved every little bit of it.
I have got you book marked to look at new stuff you post…

my web blog: best online casino apps (byzaixian.com: http://byzaixian.com/home.php?mod=space&uid=77417&do=profile&from=space)
Quote
0 #40 또보고 2022-08-10 07:22
Wow, awing web log layout! How foresightful have got you been blogging for?
Quote
0 #41 꽁포인트 2022-08-10 07:30
Situation on with this write-up, I dead consider that this site of necessity ALIR
Sir Thomas More aid.
Quote
0 #42 프릭툰 2022-08-10 07:54
you bring in blogging see well-to-do. The whole wait of your network internet site is excellent,
as considerably as the capacity!
Quote
0 #43 두루마리 2022-08-10 08:48
you stool blogging looking well-heeled. The total calculate of your WWW situation is excellent, as well as the content!
Quote
0 #44 핫애니베스트 2022-08-10 09:47
Excellent, what a blog it is! This internet site provides utilitarian facts to us,
observe it up.
Quote
0 #45 토토랜드 2022-08-10 10:21
Situation on with this write-up, I absolutely trust that this place of necessity ALIR more attending.
Quote
0 #46 금TV 2022-08-10 10:55
Wow, awesome blog layout! How foresighted have got you been blogging for?
Quote
0 #47 먹튀자바라 2022-08-10 11:18
Office on with this write-up, I absolutely consider that this web site inevitably Former Armed Forces More aid.
Quote

Add comment


Security code
Refresh

Search Trainings

Fully verifiable testimonials

Apps2Fusion - Event List

<<  Apr 2024  >>
 Mon  Tue  Wed  Thu  Fri  Sat  Sun 
  1  2  3  4  5  6  7
  8  91011121314
15161718192021
22232425262728
2930     

Enquire For Training

Fusion Training Packages

Get Email Updates


Powered by Google FeedBurner