Category Archives for workflow

SQL to monitor (check status) of Workflow Notification Mailer (Java)

 SQL> SELECT COMPONENT_STATUS from APPS.FND_SVC_COMPONENTS where COMPONENT_ID=10006;  

Read More

How to update Workflow Administrator Role in Oracle Applications 11i/R12

If you want to see workflow details (owned by other users) or status diagram in Oracle Applications 11i/R12 then you should belong to one of responsibilities/user listed under WF_ADMIN_ROLE. By default (in 11i & R12) this role is set to user sysadmin (In old versions 11.5.8 or prior, it used to set to *) If […]

Read More

Workflow Notification Mailer Configuration using Autoconfig for Outbound Processing

I remember, 30th July 2006 is the first day Atul started blogging with his first post http://becomeappsdba.blogspot.com/2006/07/how-2-become-oracle-apps-dba.html   In past 2 years, there is tremondous reponse from viewers from all over the world. I would like to congratulate and wish him all the best on this great occasion.  Today I want to post the Workflow […]

Read More

Collection of Workflow Administration Scripts and/or Concurrent Program

Workflow Scripts: Source Oracle Documentations The below are the collection of Workflow Administration Scripts and/or Concurrent Program. 1. FNDWFPR For Oracle Workflow embedded in Oracle Applications, use the standard concurrent program FNDWFPR ”Purge Obsolete Workflow Runtime Data” to purge old data from the Oracle Workflow runtime tables regularly. Navigate to the Submit Requests form in […]

Read More

Workflow Notification Mailer Setup in Oracle Apps R12/12i

On popular demand from readers, I am going to cover Workflow Notification Mailer in Oracle Applications R12/12i. Workflow notification mailer setup in R12 is similar to 11i ( In both release 11i (OWF.H and higher in 11i) & R12 are Java Mailer) * Previous version of Notification Mailer in 11i was based on C also […]

Read More

Oracle Workflow Notification Mailer

On popular request from my readers, I need to take a break from Oracle Identity Management Updates and need to Update on Oracle Workflow Notification Mailer. Oracle Workflow in itself is a Product which is tough to cover in this blog but I am going to cover few important & frequently used components from Oracle […]

Read More
Not found