Tuesday 31 March 2015

Oracle ERP – customizing Po Requisition Approval WF Notification

 

The request is to modify Po Requisition Approval Notification that is sent by an email. Erp is 12.1.3

By default it looks like this

image

First of all we need to understand how does the message is generated

We will search for the Workflow in the workflow status monitor and click on the “Workflow Details”

image

We will see a lot of information. We need to scroll down until we find the value of Req Lines Framework Region.

In my case it will be

JSP:/OA_HTML/OA.jsp?OAFunc=ICX_POR_REQLINES_NTFN&reqHdrId=-&DOCUMENT_ID-&contReqFlag=-&CONTRACTOR_REQUISITION_FLAG-&funcCurr=-&FUNCTIONAL_CURRENCY-&contStatus=-&CONTRACTOR_STATUS-&supplEmailNotAvail=-&IS_SUPPLIER_EMAIL_NOT_AVAIL-&vendor=-&VENDOR_DISPLAY_NAME-&contAssignReqd=-&CONTRACTOR_ASSIGNMENT_REQD-

image

What do we understand from this string. We understand that the message content is generated by a call to ICX_POR_REQLINES_NTFN function. Lets open function definition under “Application Developer” responsibility

Under “Web HTML” tab we will see that the function actually calls a OAF region.

image

 

So it is clear that if we replace the region by a custom region, it will display our custom content.

I created a very simple OAF project that has a region with a label “Hello” . (OA region is the only OA component in the project. No VO or AM are needed)

image

 

If you also want to preserve original content of the email, add a region that extends the original region

image 

 

Deploy the new region to the server and change function definition to point to your region

image

Restart OC4J server.

We are done.

Now, after creating the requisition I get my customized email

image