IEM — Email Center
16 documented tables · 1 views — Oracle EBS ETRM 12.2.2
Most-referenced tables
| Table | Description | Data Vault class* |
|---|---|---|
IEM_EMAIL_ACCOUNTS |
List of all eMC email accounts. | hub-leaning |
IEM_SERVER_GROUPS |
Top level, logical group of various servers in the system. | hub-leaning |
IEM_DB_SERVERS |
Database instances and their connection properties. | hub-leaning |
IEM_CLASSIFICATIONS |
List of all classification names and corresponding email accounts. | hub-leaning |
IEM_EMAIL_SERVER_TYPES |
List of various types of email servers. | hub-leaning |
IEM_KB_CATEGORIES |
List of searchable knowledge base categories | hub-leaning |
IEM_THEMES |
List of themes per classification. | satellite-leaning |
IEM_SAFETY_QUEUES |
Safety queue for AQ post processing | standalone |
IEM_DB_CONNECTIONS |
Account information on named database instances. | satellite-leaning |
IEM_EMAIL_CLASSIFICATIONS |
List of top n classifications for every email message. | link |
IEM_EMC_SERVERS |
eMC server instance details | satellite-leaning |
IEM_COMP_RT_STATS |
Temporary runtime data. | standalone |
IEM_KB_RESULTS |
Search results from various knowledge base categories per email message. | link |
IEM_EMAIL_ICNTR_MAPS |
Map an email account to one or more Interaction Centers. | satellite-leaning |
IEM_EMAIL_SERVERS |
Instance details of all email servers. | link |
*Heuristic classification mined from FK structure — a modeling suggestion, not Oracle's.
Key public APIs
| Package | Class | Procedures | Used by |
|---|---|---|---|
IEM_TAGPROCESS_PUB |
PUB | 5 | 7 packages |
IEM_ROUTE_PUB |
PUB | 2 | 6 packages |
IEM_MAILITEM_PUB |
PUB | 15 | 5 packages |
IEM_CLIENT_PUB |
PUB | 15 | 3 packages |
IEM_EMAILACCOUNT_PUB |
PUB | 6 | 2 packages |
IEM_KNOWLEDGEBASE_PUB |
PUB | 6 | 1 packages |
IEM_SERVER_PUB |
PUB | 1 | 1 packages |
IEM_REROUTE_PUB |
PUB | 4 | 1 packages |
IEM_MAILPREPROCWF_PUB |
PUB | 26 | 1 packages |
IEM_MGINBOX_PUB |
PUB | 1 | 1 packages |