Advice on OES Database structure for holding Email Message Text.
Last updated on SEPTEMBER 06, 2016
Applies to:Oracle Email Center - Version 18.104.22.168 to 22.214.171.124 [Release 11.5]
Information in this document applies to any platform.
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.
Oracle Teleservice has an Interactions Tab for the existing email interactions, how can the email body be retrieved from the back-end ?
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms