Purchasing Programs

Key Oracle Purchasing concurrent programs:

• Mass Update of Requisitions for update of Purchase Requisitions or Internal Requisitions (unless it's in Cancelled Status).

• Mass Update of Purchasing Documents program updates person information on Oracle Purchasing documents from a previous (old) person to a new person. It will NOT work on Cancelled, Finally Closed, Closed POs and Frozen POs.

          The following documents will be updated:

•   Standard Purchase Order
•   Blanket Purchase Agreements
•   Blanket Releases
•   Planned Purchase Orders
•   Planned Releases
•   Contract Agreements

• PO Output for Communication is triggered as soon as the Purchase Order is Approved and send a notification (via Oracle Workflow Mailer Engine) to the Supplier by email (if Supplier Site's Communication Method is 'Email').

Profile option PO: Secondary Email address (in R12) can be set to a secondary Email address to which the purchase order will be sent for internal reference or to forward to supplier in case it missed it earlier.

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   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' ;    

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