Email Shows Different Supplier From Purchase Orde in Body of PDF Attachment When Buyer Enters Own Email Address
Last updated on JULY 02, 2018
Applies to:Oracle Purchasing - Version 12.1.3 and later
Information in this document applies to any platform.
The buyers create and approve Purchase Orders (PO)s. On the PO Approval screen, the email address typically defaults from the supplier site. By default the workflow email will go to the supplier. The Buyer manually overwrites the email address with their own email address to review the PO PDF that's attached to the workflow email. It is here where the PO PDF attachment on the workflow email intermittently will show the correct supplier name but the workflow email body doesn't.
The wfstatus.sql shows the correct supplier - the wfmlrdbg.sql shows the incorrect email for the supplier.
Example of wfstatus.sql results showing correct email:
SUPPLIER TREE SERVICES
SUPPLIER_SITE VARCHAR2 JACKSON
po shows supplier = ORACLE and site = JACKSON
Example of wfmlrdbg.sql.html showing incorrect email:
User Name = JOHN.DOE@ORACLE.COM.AMERICAN
DISPLAY_NAME = TREE SERVICES CO-NEWPORT
Email Address = JOHN.DOE@ORACLE.COM
The Display_name shows wrong supplier = TREE SERVICES and site = NEWPORT
JOHN.DOE@ORACLE.COM.AMERICAN BAKER DISTRIBUTING CO INC-JACKSONVILLE
Display Name = BAKER DISTRIBUTING CO INC-JACKSONVILLE
there is no row for Display Name = TREE SERVICES -NEWPORT
WF Activity shows incorrectly supplier while approving the PO by opening (as broad Search) in PO Summary POXPOVPO:
Worflow Activity shows incorrectly picked random supplier while approving the PO by opening (as bulk or broad search criteria) from PO summary form POXPOVPO'
Inquire / View Approval through Workflow
Oracle Workflow: Status Monitor shows
Activity = PO PDF to the Supplier
Parent Activity = Email PO
Performer = XXXXXXX --- incorrect supplier
However, this issue is not encountered when opening individual PO and approving.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms