Advice on OES Database structure for holding Email Message Text.

(Doc ID 1435575.1)

Last updated on SEPTEMBER 06, 2016

Applies to:

Oracle Email Center - Version to [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.

For Example

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms