Advice On OES Database Structure For Holding Email Message Text.
(Doc ID 1435575.1)
Last updated on DECEMBER 03, 2019
Applies to:
Oracle Email Center - Version 11.5.10.2 to 11.5.10.2 [Release 11.5]Information in this document applies to any platform.
Goal
For 11.5.10 Email Center Customers, Oracle Email Server (OES) is used.
The following note gives advice on how it is possible to query the OES tables directly to find out details on the emails stored, in the message body of emails.
For Example
Oracle Teleservice has an Interactions Tab for the existing email interactions, how can the email body be retrieved from the back-end ?
Note
Please be aware an understand of SQL, OES, and Email Message structures will be needed in order to use this note.
Directly querying the OES data with SQL, would need full site testing.
Custom written SQL would need to checked for performance related issues.
Please be aware an understand of SQL, OES, and Email Message structures will be needed in order to use this note.
Directly querying the OES data with SQL, would need full site testing.
Custom written SQL would need to checked for performance related issues.
Solution
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
| Goal |
| Solution |