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