PO Output for Communication

PO Output for Communication is one of the most important standard reports available in Oracle. Very often in every implementation project the layout of this report is customized to suit the customer needs and demands.

In this article, i will touch up some of the 'lessons learnt' issues

1- As per the Oracle documentation, this report will be triggered as soon as the Purchase Order is Approved. Also it will send a notification to the Supplier by Email as long as the Supplier Site's Communication Method is 'Email'

Sometimes suppliers might complain that they didn't receive the Purchase Order document from Oracle due to which delays the procurement of the goods. 

In R12 Oracle comes up with a profile option that can be set to a generic Email and the program will send a copy of PO PDF(output of this report) to this email address.

Navigate to: System Administrator=>Profiles=>System

Set the profile option PO: Secondary Email address to a generic Email address to which the purchase order will be sent.

This back up Email can be used for internal reference or to forward to supplier in case if it is missed somehow.

2-  The PO Output for Communication leverages the features of Oracle Workflow Mailer Engine to send Purchase Order PDF notification to the Suppliers.

The below query would be helpful to know whether the Purchase Order transmitted to the supplier or not.

SELECT segment1,
       approved_date,
       supplier_notif_method,
       polc.displayed_field po_status,
       print_count,
       printed_date,
       from_user,
       to_user,

       status,
       mail_status,
       original_recipient
  FROM po_headers_all poh, wf_notifications wn,po_lookup_codes polc
 WHERE     1=1
     AND polc.lookup_type(+)= 'AUTHORIZATION STATUS'
        AND poh.authorization_status = polc.lookup_code(+)
       AND wn.user_key(+) = poh.segment1
       AND wn.item_key(+) = poh.wf_item_key    
       AND supplier_notif_method = 'EMAIL'
       AND NVL (edi_processed_flag, 'N') <> 'Y'
       AND NVL(xml_flag,'N') <> 'Y'
       AND message_name(+) = 'AME_EMAIL_PO'
       and  displayed_field='Approved'     
order by poh.po_header_id desc     

If mail_status is MAIL, it means the email delivery is pending for workflow mailer to send the notification.
If mail_status is SENT, its means mailer has sent email
If mail_status is Null & status is NULL or OPEN, its means that no need to send email as notification preference of user is "Don't send email" or the Workflow mailer s not Up and Running