Supplier Management

Get Involved. Join the Conversation.

Topic

    Harshith Eshwar Shaila
    In need of a query to track number of emails and related...Answered
    Topic posted October 9, 2019 by Harshith Eshwar ShailaBronze Medal: 1,250+ Points, last edited October 9, 2019, tagged Security, Supplier Communication, Supplier Profile Management 
    27 Views, 2 Comments
    Title:
    In need of a query to track number of emails and related details sent out to suppliers over a period of time?
    Content:

    Hi all,

    We require a query that we can run in BI publisher to show any emails sent out to suppliers over a period of time?  During testing we unintentionally had emails from POs and Agreements sent out to actual suppliers from development instance, we have manually generated a list of affected suppliers (they were less in number), but it would be helpful to have a query for this issue if it occurs again. 

    We have opened an service request (SR 3-21255360671) for this a well.

    Regards,

    Harshith E S

     

    Version:
    19C (11.13.19.07.0)

    Best Comment

    Harshith Eshwar Shaila

    Hi Niamath,

    I had raised an SR for this and they provided the below query, hope it helps you as reference

    select a.po_header_id,a.segment1 as "PO NUMBER" ,a.creation_date,a.approved_date,a.closed_date,a.document_status,b.communicated_date,b.communicated_to_supplier
    from fusion.po_headers_all a, fusion.po_versions b
    where a.po_header_id=b.po_header_id 
    and b.po_header_id in (select po_header_id from po_headers_all c ) 

    Regards,

    Harshith E S

     

     

    Comment

     

    • Niamath Jeddy

      you can query the po_action_history table. filter on records with action_code='COMMUNICATION'

       

      • Harshith Eshwar Shaila

        Hi Niamath,

        I had raised an SR for this and they provided the below query, hope it helps you as reference

        select a.po_header_id,a.segment1 as "PO NUMBER" ,a.creation_date,a.approved_date,a.closed_date,a.document_status,b.communicated_date,b.communicated_to_supplier
        from fusion.po_headers_all a, fusion.po_versions b
        where a.po_header_id=b.po_header_id 
        and b.po_header_id in (select po_header_id from po_headers_all c ) 

        Regards,

        Harshith E S