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

10 comments:

Minivia Figueira said...

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

Jessica Meri said...

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

Sridevi Koduru said...
This comment has been removed by the author.
Sridevi Koduru 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.

Ali Akbar 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

Nitesh Kumar 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/

Nitesh Kumar 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/