How to change the workflow email notifications subject line in oracle apps r12

How to change the workflow email notifications subject line in oracle apps r12

In this post , We will be discuss about the workflow email notification subject in oracle apps. Workflow email notifications subject is some thing standard , which is already designed by the Oracle apps application like what will be the information about PO or Expense will be see in the workflow email notification subject line in oracle apps r12. To change the workflow email notification subject line , we need to do little bit customization in the standard workflow tables to create or change the workflow email notifications subject line in oracle apps.

 

Steps to Change the Workflow email Notification subject line in oracle apps

Step1:- For example , we want to change the Purchase Order workflow email notification subject line here below.

 

In this PO Workflow notifications subject line , We are seeing the BU name , PO number & PO amount.

 

Business Requirment :- We want that , Supplier Name should also come in the Workflow email notification subject line in oracle apps r12 so that approver can see the notification subject itself for which supplier this PO notification approval is coming.

 

 

Step2:-

First of all , We need to go to the WF_NOTIFICATIONS table for this above notification shown above. In the Subject enter the PO number for which you are seeing this email notification.

 

We need to find the message_name for this above email notification.

 

SELECT MESSAGE_NAME FROM APPS.WF_NOTIFICATIONS

WHERE MESSAGE_TYPE='POAPPRV'

AND SUBJECT LIKE '%334444%'

 

In the above query , the result is ' PO_PO_APPROVE_PDF_OAF'

 

Step3:- In this below SQL query , We will get the all the attribute names which can be used in the workflow email notifications subject line.

SELECT * FROM apps.WF_MESSAGE_ATTRIBUTES_VL

WHERE  MESSAGE_TYPE ='POAPPRV'

and message_name='PO_PO_APPROVE_PDF_OAF'

 

Here below  , we can see 'SUPPLIER' is the attribute available for the this PO workflow notification subject line so we can display the supplier name in the workflow email notifications subject line in oracle apps.

 

 

Step4:-

select * from apps.WF_MESSAGES_VL

WHERE  TYPE ='POAPPRV'

and name='PO_PO_APPROVE_PDF_OAF'

 

We can see the subject column , in this below table and this subject column shows , what type of email notification subject line will be display.

 

We need to update the subject line for this name 'PO_PO_APPROVE_PDF_OAF'.

So the OLD value is

Old Subject Value

&OPERATING_UNIT_NAME -  &DOCUMENT_TYPE_DISP &DOCUMENT_NUMBER&RELEASE_NUM_DASH&RELEASE_NUM,&PO_REVISION_NUM  for &TOTAL_AMOUNT_DSP &FUNCTIONAL_CURRENCY &REQUIRES_APPROVAL_MSG &WRONG_FORWARD_TO_MSG

New Subject Value Will be

&SUPPLIER &OPERATING_UNIT_NAME -  &DOCUMENT_TYPE_DISP &DOCUMENT_NUMBER&RELEASE_NUM_DASH&RELEASE_NUM,&PO_REVISION_NUM  for &TOTAL_AMOUNT_DSP &FUNCTIONAL_CURRENCY &REQUIRES_APPROVAL_MSG &WRONG_FORWARD_TO_MSG

Script to Change the workflow email notifications subject line in oracle apps r12

 

update apps.WF_MESSAGES_VL

set SUBJECT='&SUPPLIER &OPERATING_UNIT_NAME -  &DOCUMENT_TYPE_DISP &DOCUMENT_NUMBER&RELEASE_NUM_DASH&RELEASE_NUM,&PO_REVISION_NUM  for &TOTAL_AMOUNT_DSP &FUNCTIONAL_CURRENCY &REQUIRES_APPROVAL_MSG &WRONG_FORWARD_TO_MSG'

WHERE  TYPE ='POAPPRV'

 

Commit;