Email Shows Different Supplier From Purchase Orde in Body of PDF Attachment When Buyer Enters Own Email Address

(Doc ID 1573717.1)

Last updated on AUGUST 19, 2015

Applies to:

Oracle Purchasing - Version 12.1.3 and later
Information in this document applies to any platform.
POXPOVPO

Symptoms

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:

EMAIL_ADDRESS JOHN.DOE@ORACLE.COM
..
PO_WF_EMAIL_PERFORMER JOHN.DOE@ORACLE.COM.AMERICAN
..
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

wf_local_roles:
NAME DISPLAY_NAME
JOHN.DOE@ORACLE.COM.AMERICAN BAKER DISTRIBUTING CO INC-JACKSONVILLE
JOHN.DOE@ORACLE.COMHOTMAIL.COM.AMERICAN JOHN.DOE@ORACLE.COMHOTMAIL.COM.AMERICAN
JOHN.DOE@ORACLE.COM.AMERICAN JOHN.DOE@ORACLE.COM.AMERICAN
JOHN.DOE@ORACLE.COMNTHONYDOORS.COM.AMERICAN JOHN.DOE@ORACLE.COMNTHONYDOORS.COM.AMERICAN
JOHN.DOE@ORACLE.COM.AMERICAN JOHN.DOE@ORACLE.COM.AMERICAN
==>
Display Name = BAKER DISTRIBUTING CO INC-JACKSONVILLE
there is no row for Display Name = TREE SERVICES -NEWPORT

Additional symptom:

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.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms