Purchasing

Get Involved. Join the Conversation.

Topic

    Mohammad Arif Zaffar
    Report showing PO approvers details with the comments they...Answered
    Topic posted September 18, 2019 by Mohammad Arif ZaffarBlue Ribbon: 750+ Points, tagged Approvals, Approvals/Notification 
    50 Views, 3 Comments
    Title:
    Report showing PO approvers details with the comments they put during approval
    Summary:
    Report showing PO approvers details with the comments they put during approval
    Content:

    Hello,

     

    I am looking for report or BI Query which should show PO approvers details like approver name, date and time of approval and the the comments they put during approval.

     

    Best Comment

    Niamath Jeddy

    You could consider building a report based on below table:

    PO_ACTION_HISTORY

     

    PO_ACTION_HISTORY contains information about the approval and control history of your purchasing documents. There is one record in this table for each approval or control action an employee takes on a purchase order, purchase agreement, release, or requisition. Each row includes references to the document itself, the employee who acted on the document, the date of the action, the type of action taken on the document, and a note each employee can leave when taking an action on the document. . Oracle Purchasing uses this information to display history information about documents and to forward documents in the approval process to the appropriate employee. .

    Comment

     

    • Niamath Jeddy

      You could consider building a report based on below table:

      PO_ACTION_HISTORY

       

      PO_ACTION_HISTORY contains information about the approval and control history of your purchasing documents. There is one record in this table for each approval or control action an employee takes on a purchase order, purchase agreement, release, or requisition. Each row includes references to the document itself, the employee who acted on the document, the date of the action, the type of action taken on the document, and a note each employee can leave when taking an action on the document. . Oracle Purchasing uses this information to display history information about documents and to forward documents in the approval process to the appropriate employee. .

    • Mohammad Arif Zaffar

      Thank you for your reply. 

      One clarification, 

      ...nd a note each employee can leave when taking an action on the document....

      by note you means the comments each approver adds in the approval notification?

    • Niamath Jeddy

      yes. what i pasted above is from oracle table documentation. There is a 'note' column in that table which is supposed to hold the comments put in by approvers.