How to Prevent Invalid Email Addresses Being Entered in POXPOEPO Resulting in Undeliverable Notifications (Doc ID 1348523.1)

Last updated on JULY 14, 2016

Applies to:

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

Goal

In the Purchase Order entry form after saving a Purchase Order and choosing approve, under the Transmission Methods there is an E-Mail option where the Supplier email address defaults, if setup in Supply Base>Suppliers. The user does have the option to enter any email address 'on the fly' in this field which can cause issues if an invalid email address is entered. These email addresses get populated in the wf_local_roles table where the orig_system field is populated with WF_LOCAL_USERS. If the email address is invalid then it can cause undeliverable email notifications to be delivered to System Administrator. For example the following undeliverable message was delivered showing the invalid email address entered in the details:


From: TOR-IS-Postmaster
To: linda4-xxx@oracle.com
Sent: Tuesday, July 19, 2011 11:29 AM
Subject: Undeliverable: Closed: Standard PO 8207, 0

Delivery has failed to these recipients or distribution lists:

linda4-xxx@oracle.com


Replication steps:

1. Create a Purchase Order and save.
2. Click on the Approve button.
3. Under the Transmission field click on E-mail.
4. Enter an invalid email address.
5. Query on the wf_local_roles to see the invalid entry.
6. Undeliverable message is received.

The corresponding table level data can be retrieved as follows:

select name, display_name, email_address, orig_system
from wf_local_roles
where orig_system='WF_LOCAL_USERS';

In this sample case the sql query results returned:

NAME DISPLAY_NAME EMAIL_ADDRESS ORIG_SYSTEM
LINDA4-XXX@ORACLE.COM.AMERICAN LINDA4-XXX@ORACLE.COM.AMERICAN LINDA4-XXX@ORACLE.COM WF_LOCAL_USERS

How can these types of errors be prevented?

Solution

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