Fusion Blog

EBS Blog


Contact Us

  • 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 Click here to raise Support Ticket. Get reply within 48 hours.

Search Courses



JUser: :_load: Unable to load user with ID: 855

User Rating: 5 / 5

Star ActiveStar ActiveStar ActiveStar ActiveStar Active

Business Requirement : - User needs to add Attachment (Upload/review attachment) Functionality in Any Existing OA framework page.

Solution :- You can add new Attachment Link or Attachment Table Type  oa framework Region on that page using personalization.

Difference between Attchment link and attachment Table is When you add attachment table It will display List of Attachments on same page where you have added attachment Region and when you Add Attachment Link it will display link on Same page where You have added Attachment Region and when you click on that link page will Redirect to another page where all list of attachments will be shown.

1)Go to page where you want to add attachment link.
Ex : Framework Tutorial Toolbox ->Search / Drilldown.


2)Click on search.

3)Click on go.

4)Click on details.

5)Go to about this Page.

6)Find View And Primary key for data of view object.
Ex .:- 
Primary Key:- HeaderId
View name :-   PoDetailsFullExpVO1

7)Click on  personalize page link.

8)Click on create new item. 

9)Select Type attachment link.

10)Fill Following Details and Click On Apply.
View Name :- PoDetailsFullExpVO1

11)now below error shown on page.

12Now go to newly created attachment link -> Entity Mapping.

13)click on create item.

14)Create Entity map as shown below and click on apply.

Click On Apply.

15)Go to newly created Entity Map -> Primary key and click on create item.

16)Following link Appears.
View Attribute :-  HeaderId

17)Go to Entity map Map->CategoryMappings and click on create item.

18)create category map as shown below and click on apply.

19)Now click on Return to Application.

20) You can find Link for Adding And  Viewing Attachments on this page, click on go.

21)Attach a file and Click on apply.

22)On page you can find view attachment link.

23) Now you can find attachments.

24)Open any attachment by just clicking on Link , open/save dialogue box appear.


0 #1 Obilesu 2011-12-25 13:34
Hi Dear,

Really Excellent presentation, and it will really helpful.

Regar ds,
0 #2 Stalin 2011-12-25 23:54

I really appreciate your effort and good posting. i have seen two three of your positing it is good and useful. i am always keep these things in my mind when customer asking or during design.

Stalin G
0 #3 Abhijit 2012-01-01 10:24
Hi Dakshesh,

Than ks a ton for posting this article. Could you please let us know which column or any unix location would save this attachment/.doc /.xls ?

Thanks ,
0 #4 Dakshesh Patel 2012-01-01 10:37
Hi abhijit,
Attachment is stored in FND_LOBS database column.
0 #5 Manohar Baddam 2012-01-04 05:32
Hi Dakshesh,

Ther e is a requirement to respond to worklist notification or email notification with attachments, where-in the user attaches some data, replies back to notification and this attachment must be handled back by workflow and go to another user/get saved in application for that item transaction.

A ny ideas please help!

Manohar Baddam
0 #6 Abhijit 2012-01-09 15:53
Thanks Dakshesh
0 #7 Sreenivasa Gurani 2012-04-23 20:01
Hi Dear,
You post is really very helpful for me. Very good explanation.
I tried creating Attachment link on advance table region.
I can view the attachments attached from Forms. I can successfully able to attach the from OAF too. But the attachment is not saving in back end.
I can view the attachment image. but when i logout and login again , ican not see the attachment.
wha t might be the issue? please help.

S reenivasa
0 #8 Dakshesh Patel 2012-05-27 07:52
Dear Sreenivasa,
Check step 10 in post .you have not set automatic property as "true" so you can not view attachment after upload.

Regard s,
Dakshesh Patel
0 #9 Dakshesh Patel 2012-05-27 07:56
Dear Manohar,
For handling attachment through notification response you have to do customization in workflow or you can Explore "Request information" functionality of notification.Yo u can add attachment region in "Request Information page" of notification.

Dakshe sh Patel
0 #10 Mostafa Elmasry 2012-05-29 03:51
Dear Brothers,

I have a requirement that i want to check is there is an attachment or not, i mean when i click submit from the SIT OAF page i want the system to check if i attached a file or not, and if not an error shows and the application do like raise form_trigger_fa liure, is there any way to do this ?
0 #11 Imran Jan 2012-06-06 01:18
Dear Dakshesh,

Than ks for such great article related to attachments. I have enabled the atatchment on the request for Information page. I am:

1. Attaching the document
2. And answering the question asked

upon submitting this information, this attachment can not be viewed by the approver.

Coul d you please let me know what is the reason?

Thanks a ton
0 #12 sachin ingle 2012-12-08 01:07
Hi, Anil

I have a requirement to remove/disable icon in attachments
can you tell me how to do it

sachi n ingle
0 #13 Venkat P 2013-10-09 03:24
Hi ,
My question is when we attached Url Type, It's automatically open the url. how to open that one, is there any standard code?

0 #14 Ravi N 2014-01-14 19:16
Hi Nice Article,

One quick question, when mapping entity name is that an existing entity of the page or is it a default value XX_LINK_ENTITY. I am unable to save data in my screen if I give this name. Should I change the entity name as per page?
0 #15 Rahu 2014-05-29 10:13
May i know, how does "Personalize Page" will appear on the page.

Can you please explain

0 #16 Manuel Guinto 2014-11-21 09:43
How to get the file from java?
0 #17 Free Psychic 2015-01-26 08:55
It is perfect time to make a few plans for the future and it's time to be happy.
I've learn this put up and if I may I want to counsel you few interesting things or suggestions.

Maybe you could write subsequent articles regarding this article.

I want to read even more card readers!

Add comment

Security code

Search Trainings

Fully verifiable testimonials

Apps2Fusion - Event List

<<  Aug 2021  >>
 Mon  Tue  Wed  Thu  Fri  Sat  Sun 
  2  3  4  5  6  7  8

Enquire For Training

Related Items

Fusion Training Packages

Get Email Updates

Powered by Google FeedBurner