Integrating Workflow and OAF

Dinesh Nair's Oracle EBS Blog

Oracle Workflow is tightly integrated with Oracle Apps and it is very common to invoke workflow from OAF Pages too.

The class oracle.apps.fnd.framework.webui.OANavigation provides Java wrappers for Oracle Workflow Engine’s PL/SQL APIs.

 It is very simple to invoke Workflow using OAF, again there are two options first using Java wrappers and second through calling PL/SQL procedures but the later approach you can use if you are converting some Oracle Form into OAF form and all the code for Workflow is already ready and tested but if it is new workflow then you should use Java wrappers:

 Following piece of code invokes the Workflow from OAF:

 import oracle.apps.fnd.framework.webui.OANavigation;

 public void launchWorkFlowFromOAF(OAPageContext pageContext)


String wfItemType = “‘XXSR'”;

String wfProcess = “‘SR_MAIN_PROCESS'”;

OADBTransaction transaction = getOADBTransaction();

String Sr_No ;

String wfItemKey = ” “;

Sr_No = pageContext.getParameter(“sr_no”);

wfItemKey = Sr_No+ transaction.getSequenceValue(“xxsr_key_s.NEXTVAL”).toString();

OANavigation wfClass = new OANavigation();

// Create Workflow Process

View original post 145 more words


About pacesettergraam

A good and realistic person

Posted on September 27, 2013, in Uncategorized. Bookmark the permalink. Leave a comment.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: