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

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


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