GRN NOTIFICATION PROCESS
Purpose:
·
Purpose of this extension is to allow the users
to receive the email alerts once new receipt created in the respective PO then
Oracle alert will send mail to the Item Planner.
Notification Feature:
GRN Notification provides you with the features you need to
satisfy the following basic business needs.
You will be able to address the following:
·
Once the receipt made at the XXXX Stores
·
Alert is triggered
·
Alert carries set of information
o
GRN Number, GRN Date
o
PO Number, Supplier Name, Supplier Site
o
Item Name, Description, Receiving Quantity,
o
Purchase requisition Number and Quantity
requested
·
Notification will contain the above information
·
Notification will be sent to the respective Item
Planer (MTR).
Navigation:
Navigate to the
Responsibility Alert Manager ->
Alert -> Define . Details to be
filled are below
Method
1. Build SQL Query as per requirement.2. Paste in the Select Statement Area and Click on verify button to cross check.
3.. Click on Action Button
4. Click on Action Details Button fill it like below
5. Action Detials-->Text
ALERT/MAIL FORMAT:
GRN Notification Information
------------------------------------------------------------------
GRN Number : &GRN_NO
GRN Date : &GRN_DATE
------------------------------------------------------------------
Purchase Order Details
------------------------------------------------------------------
PO Number : &PONUMBER
Supplier Name : &SUPPLIERNAME
Supplier Site : &SUPPLIERSITE
--------------------------------------------------------------------
Item Details
--------------------------------------------------------------------
Item Planner : &EMAIL
Item Number : &ITEMNUMBER
Item Description : &ITEMDESCRIPTION
Receipt Quantity : &QUANTITY
---------------------------------------------------------------------
Requisition Details
---------------------------------------------------------------------
Requisition Number : &REQ_NUMBER
Requisition Quantity : &REQ_QUANTITY
---------------------------------------------------------------------
6. Click on Action Sets
7. Action set Details-->Output
8. Action set Details-->Members
9. Alert Details-->Outputs
10. Alert Details-->Installations
