Oracle applications - Surendranath Subramani: August 2016

Friday, August 5, 2016

Oracle Purchase Requisition (iProcurmenet) Approval notification Header information #HDR - How it works

Published date: 04-Aug-2016

Purpose:
The purpose of this article is to understand how to display custom header information on the workflow notification.

Let us take an example.
In Oracle Purchase Requisition module when requisition is set for approval the approval notification has below 3 header information how only these 3 information’s only displayed.

·         Requisition header description
·         Requisition total
·         Non-recoverable Tax




Ok, will look into the details now.

Open the workflow and go to notification and you will see attribute with the internal name #HDR as shown below.

The attributes with internal name that start with #HDR will be automatically enabled in notification header.
In below screen if you notice requisition description is having internal name #HDR_1


Now that you have understood how it is working I am going to show you simple example with source code attached at end of this article so you can implement at your environment and run the sample workflow to see the result.

Step: 1
a.       Create simple workflow
b.      Create attribute (internal name should be #HDR_1)
c.       Move the attribute to message (Send Message)
d.      Execute the workflow
a.       I have created package and plsql block to execute the workflow which is also attached at the end of the article.





You will find the Header description available at the header portion of the workflow notification.



Code can be downloaded using below link