CCT — Telephony Manager
34 documented tables · 1 views — Oracle EBS ETRM 12.2.2
Most-referenced tables
| Table | Description | Data Vault class* |
|---|---|---|
CCT_MIDDLEWARE_TYPES |
This table lists each middleware type, such as PROSPECT_ASPECT or OPENTEL. | hub-leaning |
CCT_ROUTES |
Route table. | hub-leaning |
CCT_TELESET_TYPES |
This table specifies the characteristics of a particular type of telesets. | hub-leaning |
CCT_INTERACTION_KEYS |
This table lists the predefined Interaction keys for OA Prefs Admin Screen. | hub-leaning |
CCT_TELESETS |
This table defines a hardware teleset characteristics. | satellite-leaning |
CCT_CLASSIFICATIONS |
Classifications table. | hub-leaning |
CCT_MIDDLEWARE_PARAMS |
This table specifies the specific middleware parameters a middleware needs. | satellite-leaning |
CCT_MIDDLEWARES |
This table is for holding information needed for interfacing with the switch's middleware. | satellite-leaning |
CCT_ROUTING_RESULTS |
This table is used to the store the workflow routing results | standalone |
CCT_TEMPAGENTS |
This table is used by the Routing Server Workflow definitions to keep track of the Agents returned by the node | standalone |
CCT_SERVER_RT_STATS |
Server Real Time Statistics table | standalone |
CCT_INTERACTION_DEFS |
Call Center Interaction definitions table. | standalone |
CCT_ROUTING_FILTERS |
This table is used to store temporarily the Routing filters for the interaction | standalone |
CCT_EVENTS |
This table holds every event that the OTM throws internally. | standalone |
CCT_ROUTING_SERVERS |
Routing Servers table. | standalone |
*Heuristic classification mined from FK structure — a modeling suggestion, not Oracle's.
Key public APIs
| Package | Class | Procedures | Used by |
|---|---|---|---|
CCT_INTERACTIONKEYS_PUB |
PUB | 0 | 10 packages |
CCT_COLLECTION_UTIL_PUB |
PUB | 5 | 9 packages |
CCT_IH_PUB |
PUB | 1 | 4 packages |
CCT_QDE_PUB |
PUB | 7 | 2 packages |
CCT_MEDIA_TYPES_PUB |
PUB | 1 | 2 packages |
CCT_MQD_PUB |
PUB | 2 | 1 packages |
CCT_CUSTOM_LOOKUP_PUB |
PUB | 1 | 1 packages |
CCT_HEX_UTIL_PUB |
PUB | 2 | 1 packages |
CCT_JTFRESOURCEROUTING_PUB |
PUB | 9 | 1 packages |
CCT_SERVERGROUPROUTING_PUB |
PUB | 3 | 1 packages |