Working with Email (WEML)
Purpose: Use Work with Email to review and work with emails that have been forwarded into Correspondence History and that are in error. For more information: See Email Repository Overview the Order Administration Web Services Guide on My Oracle Support (ID 2953017.1) for more information on how the system processes forwarded emails.
Possible error reasons include:
- the email did not include sufficient information to assign it to a customer
- the email included conflicting information: for example, it specified a customer number and an order number, but the order number is not valid for that customer
- the email included invalid information, such as an email category that does not exist
- the email address in the email does not match an existing customer
- there is more than one customer with the email address in the email (Note: This condition produces an error only if the Assign Unreferenced Email (H93) system control value is set to *DUPE)
In this topic:
- Work with Unrouted Email Screen
- Change Email Screen
- Display Email Screen
- Display Email Detail Screen
- Symbol and Special Character Conversion in Emails
Work with Unrouted Email Screen
How to display this screen: Enter WEML in the Fast path field at the top of any menu, or select Work with Unrouted Email from a menu.
Field | Description |
---|---|
Date |
The date when the email was forwarded into the system. You can select Sort by email date to display the date when an email was originally sent (the Email sent date) rather than the date when it was forwarded into the system and the Correspondence History record was created (the Created on date). Similarly, after you have selected to display the Email sent date, you can select Sort by create date to switch the displayed date back to the Created on date. Numeric, 6 positions (in user date format); optional. |
Src (Source) |
Indicates whether the email was inbound or outbound. Valid values are:
A user-supplied code indicating the email’s source is not currently implemented. Normally, only inbound (EXT) emails are listed on this screen as unrouted. Alphanumeric, 3 positions; optional. |
Rsn (Reason) |
The reason why the system did not assign the email. Possible reasons are:
|
To determine the specific error(s) for an email, select Change for an email to advance to the Change Email Screen, where the system displays an error message. See Email Repository Overview for general information. For more information see the Order Administration Web Services Guide on My Oracle Support (ID 2953017.1). Optional. |
|
Cat (Category) |
A category that you use to group email correspondence between you and your customers. A category of NTF indicates that the email was a notification generated by the system and sent to the customer. Alphanumeric, 3 positions; optional. |
Email address |
The email address of the person who originated the email. Alphanumeric, 50 positions; display-only. |
Option | Procedure |
---|---|
Change an unrouted email |
Select Change for an email to advance to the Change Email Screen. |
Delete an unrouted email |
Select Delete for an email to delete it. |
Display an unrouted email |
Select Display for an email to advance to the Display Email Screen. |
Create a tickler for the MN (manually created) tickler event |
Select Create tickler for an email to advance to the Create Tickler Screen. |
Display email subject and text |
Select Display detail for an email to advance to the Display Email Detail Screen. |
Change display sequence by date |
Select FIFO to display emails in ascending chronological order (earliest to latest). Similarly, once FIFO is selected, Select LIFO to display emails in descending chronological order (latest to earliest). |
Change displayed date to the date email was originally sent |
Select Sort by email date to display the date when an email was originally sent (the Email sent date) rather than the date when it was forwarded into the system and the Correspondence History record created (the Created on date). Similarly, after you have selected to display the Email sent date, you can select Sort by create date to switch the displayed date back to the Created on date. You can use this option together with selecting FIFO to display emails in ascending or descending chronological order based on Created on date or Email sent date. The four possible sort options are:
The current sort is indicated in the upper left corner of the screen. |
Change Email Screen
Purpose:
- Unrouted email: An unrouted inbound email is an email that originated from a customer but has not been assigned to a customer because of insufficient or invalid identifying information. Use this screen to review the specific errors and other detail information, correct any errors, and assign the email. Any fields that are in error are highlighted when you advance to this screen, and an error message indicates the nature of the error.
- Routed email: A routed email is an inbound email or outbound email notification that is assigned to an customer and, potentially, additional records such as an order, bill-to customer, or purchase order. Use this screen to review detail information or to reassign the email differently if you have the proper authority; the Changed Routed Email (B08) secured feature controls access to this screen for routed (assigned) emails. If you do not have authority to change a routed email, you can use the Display Email Screen to review all of this information.
How to display this screen: Select Change for an email at the:
- Work with Unrouted Email Screen
- Work with Email by Order Number Screen
- Work with Email by Customer Sold To Number Screen
- Work with Email by Customer Ship To Number Screen
- Work with Email by Customer Bill To Number Screen
Field | Description |
---|---|
Created on |
The date and time that the email was received into Order Administration and the Correspondence History record was created. Date: numeric, 6 positions (in user date format); display-only. Time: numeric, 6 positions (HH:MM:SS format); display-only. |
Email sent |
The date and time when the email originated. This is not the date and time when you forwarded an external email into Order Administration, but the date and time when a forwarded email was originally sent. Because the date and time on an external systems can be set differently, it is possible for there to be discrepancies between this date and the date when the email record was created in Order Administration. In the case of an email notification generated by the system, the dates created and sent should be identical. Date: numeric, 6 positions (in user date format); display-only. Time: numeric, 6 positions (HH:MM:SS format); display-only. |
Subject |
The subject line of the email.
|
Alphanumeric, 78 positions; display-only. |
|
Email address |
The email address of the person who originated the email. Alphanumeric, 50 positions; display-only. |
Display name |
The name associated with the email address. Depending on the original email application, a forwarded message might include either the display name or the actual email address: Uses actual email address: -----Original Message----- From: lak@example.com Sent: 08/09/2006 10:33:38 AM Uses display name: -----Original Message----- From: Harry Truman Sent: 08/09/2006 10:33:38 AM Alphanumeric, 50 positions; display-only. |
CC |
The email addresses that were sent copies of the email. This field is truncated if the original information exceeded the maximum length in Order Administration. Alphanumeric, 50 positions; display-only. |
Source |
Indicates whether the email was inbound or outbound. Valid values are:
A user-supplied code indicating the email’s source is not currently implemented. Alphanumeric, 3 positions; display-only. |
Routed |
Indicates whether the email has been assigned to a customer. Valid values are:
|
Attachment |
Indicates if there was a file attached to the email. Attachments to emails forwarded into Order Administration are discarded; however, if you forward the email using the Outlook form, the form adds a flag to the subject line indicating that the email originally had an attachment. An attachment could be any sort of file that is sent along with the email, such as a document, image, script, or program. Valid values are:
|
Error reason |
The reason why the system did not assign the email. This field is set only for unrouted emails. Possible reasons are:
|
See Email Repository Overview for general information. For more information see the Web Services Guide on My Oracle Support (ID 2953017.1). Alphanumeric, 1 position; display-only. |
|
Category |
A category that you use to group email correspondence between you and your customers. A category of NTF indicates that the email was a notification generated by the system and sent to the customer. Category codes are defined in and validated against the Correspondence Category table; see Working with Email Category (WEMC). Alphanumeric, 3 positions; optional. |
Order number |
The order number and order ship-to number, if any, related to the email. The order ship-to number is separated from the order number by a hyphen (-). See Identifying an Unrouted Email for information on completing or correcting these fields for an unrouted email. Order number: numeric, 8 positions; optional. Order ship-to number: numeric, 3 positions; optional. |
Customer reference number |
A cross-reference code available to identify the customer with a record in another system. Validated against the Alt customer # field at the second Create Customer screen in customer maintenance, or an Alternate customer # cross reference from the Alternate Customer # Cross Reference table (see Working with Alternate Customer Number Cross-References). Note: If the Display Alternate Customer Cross Reference Window (I84) system control value is selected, the system selects the last customer numerically (that is, the most recently created customer) who matches based on the primary Alt customer # from the Customer Sold To table, if any; otherwise, it selects the last customer numerically who matches based on the Alternate customer # cross reference. If the Display Alternate Customer Cross Reference Window (I84) system control value is unselected, the system selects the last customer numerically who matches based on the Alternate customer # cross reference, regardless of whether there is also a match based on the Alt customer #.See Identifying an Unrouted Email for information on completing or correcting this field for an unrouted email. Alphanumeric, 15 positions; optional. |
Order reference number |
A cross-reference code available to identify the order with a record on another system. Validated against the E-commerce order number field in the Order Header Extended table; this field is displayed as the Alternate order field at the Display Order Properties Screen. See Identifying an Unrouted Email for information on completing or correcting this field for an unrouted email. Alphanumeric, 35 positions; optional. |
Customer sold to |
A number identifying the sold-to customer associated with the email. Validated against the Customer Sold To table. If a sold-to number is identified, the customer’s company name, if any, and name appear to the right. See Identifying an Unrouted Email for information completing or on correcting this field for an unrouted email. Customer number: numeric, 9 positions; optional. Customer name: alphanumeric, 41 positions; display-only. |
Customer ship to |
A number identifying a permanent shipping address associated with a sold-to customer. See Identifying an Unrouted Email for information on completing or correcting this field for an unrouted email. Numeric, 3 positions; optional. |
User code 1 |
A field available to enter a one-position code or flag. Not validated against any table. Alphanumeric, 1 position; optional. |
Customer bill to |
A number identifying a customer responsible for payment on an order. Validated against the Customer Bill To table. See Identifying an Unrouted Email for information on completing or correcting this field for an unrouted email. Numeric, 7 positions; optional. |
User code 2 |
A field available to enter a 10-position code. Not validated against any table. Alphanumeric, 10 positions; optional. |
Invoice number |
A number identifying the invoice with which an order was billed or credited. Validated against the Invoice Header table. See Identifying an Unrouted Email for information on completing or correcting this field for an unrouted email. Numeric, 7 positions; optional. |
User code 3 |
A field available to enter a 20-position code. Not validated against any table. Alphanumeric, 20 positions; optional. |
Vendor number |
A number identifying a vendor who supplies you with merchandise. Validated against the Vendor table. Ordinarily used here only for drop shop purchase orders associated with an order. See Identifying an Unrouted Email for information on completing or correcting this field for an unrouted email. Numeric, 7 positions; optional. |
User number |
A field available to enter a 13-position number. Not validated against any table. Numeric, 13 positions; optional. |
Purchase order number |
A number identifying a purchase order. Validated against the PO Header table. Ordinarily used here only for drop ship purchase orders associated with an order. See Identifying an Unrouted Email for information on completing or correcting this field for an unrouted email. Numeric, 7 positions; optional. |
User date |
A field available to enter a date. Numeric, 6 positions (in user date format); optional. |
Option | Procedure |
---|---|
Display the text of the email |
Select Display email detail to advance to the Display Email Detail Screen. |
Advance to standard order inquiry |
Select Order inquiry. If the email is associated with an order number, you advance to the Order Inquiry Header Screen or the Order Inquiry Detail Screen, depending on the setting of the Default Version for Order Inquiry (C34) system control value. If the email is not associated with an order number, you advance to the Order Inquiry Scan Screen. Note: This option is not available when you are working with a routed email in standard order inquiry. |
Accept your entries and assign the email |
After you have identified the email, select Accept. See Identifying an Unrouted Email below for more information. Note: This option is available only if you have the proper authority, based on the Changed Routed Email (B08) secured feature. |
Identifying an Unrouted Email
You can associate an email with any of the following:
- order-related information:
-
Order number and order ship-to number
-
Customer sold to number
-
Customer ship to number
-
Customer bill to number
-
Purchase order number (for drop shipments)
-
Vendor number (for drop ship purchase orders)
-
- customer-related information:
-
Customer sold to number
-
Customer ship to number
-
- Vendor number and Purchase order number
To associate an email with any of the above types of information, complete the field or prompt for a list of valid values.
When you complete a field, the system:
- Fills in the related fields if it can positively identify them. For example, when you enter an order-related field such as the order
number, the system fills in the customer sold-to number and the following
related fields if they exist on the order:
-
Customer ship-to number
-
Customer bill-to number
-
Order reference number
-
- Confirms that all entries on the screen are consistent. For example, if you complete the order number and the customer reference number, but the customer reference number is not correct for the customer sold-to on the order indicated, the system displays an error message.
Things to note: The system does not:
- Fill in a field if more than one possible relationship exists. For example, when you enter the order number, the system does not fill in the invoice number, because it is possible for an order to have more than one invoice.
- Confirm a relationship between a vendor number and order-related or customer-related information; however, the system does confirm that a purchase order number is consistent with a vendor number if you enter both, and fills in the vendor number if you enter just the purchase order number. The exception is drop ship purchase orders, in which the vendor number and purchase order number are validated as order-related information.
- Confirm a relationship between customer-related information and a bill-to number, unless order-related information is also identified.
- Assign the email if you specify just a bill-to customer without specifying a sold-to customer. The system accepts your entry, but leaves the email in unrouted status.
Selecting the correct customer or order: Select Order inquiry. If you have selected an order number, you advance to the Order Inquiry Header Screen or the Order Inquiry Detail Screen, depending on the setting of the Default Version for Order Inquiry (C34) system control value. You can review the order and customer information at these screens to see if they are consistent with what you know about the email.
If you have not selected an order number, you advance to the Order Inquiry Scan Screen. At these screens, you can scan on customer name or email address to help you identify the originator of the email and the related order, if appropriate.
When you have completed your inquiry, select Exit to return to the Change Email screen, where you can enter the appropriate information.
Accepting your entries: If there are no errors, select Accept to accept your entries and assign the email.
Rejecting your entries: Select Exit to exit the screen without accepting your entries. If you advanced to this screen from the Work with Unrouted Email Screen, a pop-up window prompts you to confirm that you are exiting.
Click Accept changes to accept your changes, OK to exit the screen without saving your changes, or Exit to return to the Change Email screen.
Display Email Screen
Purpose: Use this screen to review detailed information about an email. You cannot change any information at this screen. See Change Email Screen for field descriptions.
How to display this screen: Select Display for an email at the:
- Work with Unrouted Email Screen
- Work with Email by Order Number Screen
- Work with Email by Customer Sold To Number Screen
- Work with Email by Customer Ship To Number Screen
- Work with Email by Customer Bill To Number Screen
Display Email Detail Screen
Purpose: Use this screen to review the content of an email.
Note:
The system does not save the text of outbound email notifications, which are identified by a Src (Source) of INT (internal) and a Cat (Category) of NTF notification; however, you can review the subject line at the Change Email Screen or the Display Email Screen to determine the type of notification that was sent. The system saves a record of email notifications only if the Write Outbound Email to Email Repository (H99) system control value is selected.How to display this screen:
- Select Display detail for an email at the:
- Work with Email by Order Number Screen
- Work with Email by Customer Sold To Number Screen
- Work with Email by Customer Ship To Number Screen
- Work with Email by Customer Bill To Number Screen
- Select Display email detail at the:
Email text: The contents of the email are presented on this screen. The Email Presentation (I01) system control value controls the extent to which blank line spaces in the email are consolidated.
Field descriptions: See the Change Email Screen for a description of the remaining fields on this screen.
Symbol and Special Character Conversion in Emails
Emails are stored in the Correspondence History table in plain text. The table below describes how some commonly used symbols and special characters are rendered.
Symbol/character appearance | Description | Converted to: |
---|---|---|
< |
left angle bracket |
< |
— |
em dash |
- (hyphen) |
– |
en dash |
- (hyphen |
non-breaking space |
space |
|
© |
copyright symbol |
¤ |
® |
registration symbol |
« |
™ |
trademark |
(tm) |
¼ |
1/4 |
Ê |
½ |
1/2 |
Ë |
§ |
section symbol |
º |
¶ |
paragraph symbol |
à |
abcde |
symbol font |
abcde (regular text) |
The following characters are deleted from the email:
- ~ (tilda)
- | (pipe)
- optional hyphen
- em space
- en space