Dynamic Workflow Notification Attachments

We know Workflow Notification can have attachments also. This is very useful feature and widely used in real-time. Big limitation in this method is if we know the number of attachments then this approach is easy to implement. Otherwise if we do not know the number attachments needs to attach, it is very difficult to use this approach. For example one PO can have multiple attachments. If the requirement is to include all of them in PO Approval notification then it is difficult using this approach.

One of the workaround could be listing all the attachments in the notification body (rather than as attachment) with dynamic hyperlink to the attached documents. This is can be done either using PLSQL or OA Framework document type.

Example:
Create simple workflow with message and notification. This workflow can have user_id, resp_id, resp_appl_id attributes. This will be used to set application context.

Create Document Type attribute to generate notification body.

In the PLSQL API which is used to generate notification body:
Initialize Application Context using available attribute values in workflow

Frame SQL query to get documents that needs to attach from fnd_lobs table.

Use FND_GFM and FND_WEB_CONFIG APIs to get document URL.

Write HTML TABLE tags and add File Name as one of the column with above hyperlink to the document. Use target as _blank to open the document in new browser.

Notification body will be generated with all available attachment documents. Clicking the link will download the document in the browser.

Limitation:
1. If user preference is set to send notifications over e-mail then user should have access to the application when he try to access the attachments from e-mail.
2. Document should be available in EBS fnd_lobs table.

10 comments:

Anonymous said...

We are a group of volunteers and starting a new scheme in our community.
Your web site provided us with valuable information to work on.

You have done an impressive job and our entire community will be
thankful to you.

My page Risk elements associated with Abnormality

Anonymous said...

Howdy, i read your blog occasionally and i own a similar one and i was just curious if you get a
lot of spam feedback? If so how do you protect against it, any plugin or anything you can recommend?
I get so much lately it's driving me insane so any assistance is very much appreciated.

My blog post ... http://chestfatburner.com

Anonymous said...

Good answer back in return of this difficulty with genuine arguments and telling everything on the topic of
that.

Look into my webpage ... Is hormonal disproportion a potential reason behind " moobs " growth?

Anonymous said...

Have you ever thought about adding a little bit more than just your articles?
I mean, what you say is valuable and all. However think
of if you added some great pictures or videos to
give your posts more, "pop"! Your content is excellent but with images and videos, this blog could certainly be one of the most
beneficial in its niche. Fantastic blog!

Also visit my web page :: http://chestfatburner.com/how-to-loose-fat-from-under-your-armpits

Anonymous said...

Pretty nice post. I just stumbled upon your blog and wished to
say that I've really enjoyed browsing your blog posts. In any case I'll be subscribing to your rss feed and
I hope you write again soon!

Here is my blog post ... http://chestfatburner.com/the-best-natural-cure-for-gynecomastia-and-how-it-works/

Anonymous said...

Wow, that's what I was looking for, what a information! existing here at this webpage, thanks admin of this web page.

Feel free to surf to my web-site ... http://chestfatburner.com

Anonymous said...

I will right away grasp your rss feed as I can't to find your e-mail subscription link or e-newsletter service. Do you have any? Please permit me recognise so that I may just subscribe. Thanks.

Also visit my web site :: http://chestfatburner.com

Anonymous said...

Hi excellent blog! Does running a blog like this require a lot of work?

I have no expertise in computer programming but I
had been hoping to start my own blog in the
near future. Anyways, if you have any suggestions or techniques for new blog owners please share.
I know this is off topic however I just needed to ask.
Appreciate it!

My webpage :: Will Certainly working out regularly eliminate abnormality?

Anonymous said...

Thanks for finally talking about > "Dynamic Workflow Notification Attachments" < Liked it!

Here is my website :: Natural treatments of
individual breasts

single razai said...

Notification body will be generated with all available attachment documents. Clicking the link will download the document in the browser.
kurti stitching factory ,