Email Shows Different Supplier From Purchase Order in Body of PDF Attachment When Buyer Enters Own Email Address (Doc ID 1573717.1)

Last updated on JANUARY 06, 2023

Applies to:

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 <username@>
..
PO_WF_EMAIL_PERFORMER <username@>
..
SUPPLIER <SUPPLIERNAME A>
SUPPLIER_SITE VARCHAR2 <SUPPLIERSITE A>

==>
po shows supplier = <SUPPLIERNAME B> and site = <SUPPLIERSITE A>

--------------------------------
 
Example of wfmlrdbg.sql.html showing incorrect email:

User Name = <username@>
DISPLAY_NAME = <SUPPLIERNAME A-SUPPLIERSITE B>
Email Address = <username@>

==>
The Display_name shows wrong supplier = <SUPPLIERNAME A> and site = <SUPPLIERSITE B>

wf_local_roles:
NAME DISPLAY_NAME
<username@>
<username@>
<username@>
<username@>
<username@>
==>
Display Name = <SUPPLIERNAME C SUPPLIERSITE C>
there is no row for Display Name = <SUPPLIERNAME A -SUPPLIERSITE B>

Additional symptom:

WF Activity shows incorrectly supplier while approving the PO by opening (as broad Search) in PO Summary POXPOVPO:

Workflow 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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.