Monday, June 1, 2015

Oracle Workflow:Providing Approval/Rejection for a notifcation through API's

Hi All,

Recently i got a requirement to  Overide a work flow  Approval process programmatically

Scenario:Let assume the workflow is pending with supervisor and he is not available to provide approval/rejection a oracle notification.

Possible reasons:
1.users didnt set up vaccation rules
2.Notification is timedout and pending with supervisor manager


One way to handle these scenarios is througth work flow administartor which requires a production incident and it own SLA to resolve.

There are oracle wokflow  notification API' s which allows to set the result of the notification through APIS

--Set all the notification attributes result/any comments attributes on the notification etc
wf_notification.setattrtext (nid      => l_notification_id,
                                           aname    => l_aname,
                                           avalue   => l_avalue);
--API to complete the worklfow node and move it
wf_notification.respond (l_notification_id,
                                  ',
                                 );

This solution is usesful when the oracle approval mechanism need to be handled from third party applications

19 comments:

Unknown said...

What is your experieince working with Oracle AME? for r12 Invoice Approvals.

Unknown said...

this article nice ,this information is very useful to me and our company OracleAppsTechnicalOnlineTraining

Unknown said...
This comment has been removed by the author.
Unknown said...


Regards
Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, SQL, PL/SQL, D2K at sridevikoduru@oracleappstechnical.com | +91 - 9581017828.

Anonymous said...

usefull post, but how can i achieve the MORE INFORMATION REQUIRED and REQUEST FOR CORRECTION functionality from normal pl/sql block.
Thanks in Advance.

oracle Ebs training said...

Hi,
I found your blog has very interesting topics,thanks for sharing such an interesting information with us. Erp tree provides best oracle financials online coaching globally.people who interested in oracle go through our site and for more info call us .
Oracle Financials training

Unknown said...

This one is very informative blog, thank you for sharing such useful information for  Technical Institute in Bihar. There is one more institute which provide best coaching for exam preparation of general competition courses. I hope you like our institute  www.adyainstitute.com

Amit said...

Nice Blog

Install Oracle Appsr12 Dump For Better Practice


https://www.olx.in/item/install-oracle-appsr12-dump-at-500-only-ID1bqZlz.html

Anonymous said...

I really appreciate information shared above. It’s of great help. If someone want to learn Online (Virtual) instructor lead live training in Oracle Technical Financials , kindly contact us http://www.maxmunus.com/contact
MaxMunus Offer World Class Virtual Instructor led training on Oracle Technical Financials . We have industry expert trainer. We provide Training Material and Software Support. MaxMunus has successfully conducted 100000+ trainings in India, USA, UK, Australlia, Switzerland, Qatar, Saudi Arabia, Bangladesh, Bahrain and UAE etc.
For Demo Contact us.
Nitesh Kumar
MaxMunus
E-mail: nitesh@maxmunus.com
Skype id: nitesh_maxmunus
Ph:(+91) 8553912023
http://www.maxmunus.com/

Anonymous said...

I really appreciate information shared above. It’s of great help. If someone want to learn Online (Virtual) instructor lead live training in Oracle AME , kindly contact us http://www.maxmunus.com/contactMaxMunus Offer World Class Virtual Instructor led training on Oracle AME . We have industry expert trainer. We provide Training Material and Software Support. MaxMunus has successfully conducted 100000+ trainings in India, USA, UK, Australlia, Switzerland, Qatar, Saudi Arabia, Bangladesh, Bahrain and UAE etc.
For Demo Contact us.
Nitesh Kumar
MaxMunus
E-mail: nitesh@maxmunus.com
Skype id: nitesh_maxmunus
Ph:(+91) 8553912023
http://www.maxmunus.com/

Unknown said...

I have found this article about Oracle quite informative. People who are into making career in OCA should read this blog regularly as it is giving useful tips and tricks regarding technological aspects of Oracle.

Best Regards,
Crish Watson
Pass Microsoft Certification Without Exam

tejaswini said...

I need to communicate my deference of your composing aptitude and capacity to make perusers read from the earliest starting point as far as possible. I might want to peruse more up to date presents and on share my musings with you.data science course in malaysia

360DigiTMG said...


This was certainly one of my preferred web journals. Each post distributed impressed me.
what is hrdf

360DigiTMG said...

Attempting to express profound gratitude won't just be satisfactory, for the fabulous clearness in your creation. I will in a brief instant get your rss channel to stay instructed with respect to any updates.
360DigiTMG

hrdf claimable training said...

Here at this site actually the particular material assortment with the goal that everyone can appreciate a great deal.
hrdf claimable training

tejaswini said...

I truly like your style of blogging. I added it to my preferred's blog webpage list and will return soon…
HRDF training

Unknown said...

Really Nice Information It's Very Helpful All courses Checkout Here.
data analytics training in yelahanka

BEST IT CERTIFICATIONS ONLINE WITHOUT EXAMS said...

offensivesecurityusa.com prepares you for an increasingly critical field: information security. Our courses focus on real-world penetration testing techniques and methods, preparing you to tackle real-life challenges. Our certifications prove to employers that you have the in-demand skills they need.

How to get OSED without exam online.

can i pass OSWE certification without training

how to pass OSEP certificate without test

can i pass OSWP certificate without exam

how to get OSCE certificate without exam

How to pass OSCP certificate without taking exam

360DigiTMGAurangabad said...

nice blog!! i hope you will share a blog on Data Science.
data science courses aurangabad