How to Prevent Invalid Email Addresses Being Entered in POXPOEPO Resulting in Undeliverable Notifications
Last updated on JULY 14, 2016
Applies to:Oracle Purchasing - Version 188.8.131.52 and later
Information in this document applies to any platform.
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:
Sent: Tuesday, July 19, 2011 11:29 AM
Subject: Undeliverable: Closed: Standard PO 8207, 0
Delivery has failed to these recipients or distribution lists:
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
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?
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