My Oracle Support Banner

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 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.


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.