1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

PR & PO Notificatins - Reg

Discussion in 'Oracle SCM & Manufacturing' started by kalam.scm, Feb 17, 2014.

  1. kalam.scm

    kalam.scm Active Member

    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    75
    Dear Friends,

    I have an urgent requirement as mentioned below.

    We need to provide our commercial manager Mr. XYZ (Employee Number 33) with email and system notification of every approval of PRs and POs.

    Please let me know the necessary actions or process to be done and let me know.

    Note: Mr. XYZ is already an approver for PO and PR.Apart from that he has to receive notification for every approval of PR and PO.

    Thanks & Regards,

    Shaik
     
  2. ushanair

    ushanair Active Member

    Messages:
    12
    Likes Received:
    2
    Trophy Points:
    90
    Hi,

    I thing using Oracle Event Alert on WF_NOTIFICATIONS table (insert) this can be achieved, you can retrieve information from WF_NOTIFICATIONS and check message_name values

    PO_REQ_APPROVE_JRAD for OPEN status
    PO_REQ_APPROVED_JRAD for CLOSED status

    Thanks
     
  3. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Hi,

    For this you need event alert on pr table and po table.