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 JUNE 09, 2021
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 <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>
Display Name = <SUPPLIERNAME C SUPPLIERSITE C>
there is no row for Display Name = <SUPPLIERNAME A -SUPPLIERSITE B>
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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document