A Oracle Communications Services Gatekeeper Tables

This appendix lists all the tables that are created on first start-up of the Oracle Communications Services Gatekeeper database (except deployment-specific tables), and backward-compatible tables.

As an optimization, it is possible to remove tables if your communication services do not require them. Because non-existent tables do not require backing up, this makes your implementation more efficient.

Standard Service Gatekeeper 5.1 Tables

WLS_ACTIVE

BUDGET_CONFIG_TABLE

BUDGET_SERVICE_STATE_TABLE

BULK_MMS_CHUNK_LIST

BULK_MMS_CHUNK_SUB_LIST

BULK_MMS_ORDER_LIST

BULK_PUSH_CHUNK_LIST

BULK_PUSH_ORDER_LIST

BULK_PUSH_CHUNK_SUB_LIST

BULK_SMS_CHUNK_LIST

BULK_SMS_CHUNK_SUB_LIST

BULK_SMS_ORDER_LIST

CC_INTERCEPTOR_DATA

GLOBAL_BUDGET_CONFIG_TABLE

GLOBAL_WLNG_SLAS

LEGACY_SMPP_CONNECTION_STORE

LEGACY_SMPP_NOTIF_STORE

LEGACY_SMPP_SESSION_STORE

MPCC_CALL_LEG_SESSION

MPCC_CALL_SESSION

NATIVE_SMPP_SESSION_STORE

PL_AC_SIP_STATUS

PL_CD_SIP_ADDR_COR

PL_CD_SIP_COR_SUB

PL_CN_PX30_OSA_ASSOCIATOR

PL_CN_PX30_OSA_INFO

PL_CN_SIP_ADDR_COR

PL_CN_SIP_COR_SUB

PL_LEGACY_MM7_NOTIF

PL_LEGACY_MMS_MT

PL_MMS_MO_CONTENT_MMS

PL_MMS_MO_MMS

PL_MMS_MT_DR_MMS

PL_MMS_OFFLINE_NOTIF

PL_MMS_ONLINE_NOTIF

PL_LEGACY_MMS_STATUS

PL_LEGACY_MMS_VASP_ID

PL_LEGACY_MMS_VAS_ID

PL_LEGACY_SMPP_BIND_STORE

PL_MPCC_MEDIA_NOTIF

PL_SMS_ONLINE_NOTIF

PL_SMS_SMPP_MO_SMS

PL_PAYMENT_RESERVATION_DATA

PL_PUSH_PAP_NOTIFICATION_INFO

PL_PX30_AC_UI_CALL_INFO

PL_PX30_UI_CALL_LEG_INFO

PL_SMS_BINARY_NOTIF

PL_SMS_MO_SMS

PL_SMS_OFFLINE_NOTIF

PL_SMS_SMPP_MT_SMS

PL_TL_MLP_TRIGGER_INFO

PL_TPC_INAP

PL_TS_MAP_NETWRK

PL_TS_MAP_NETWRK_ROUTE

PL_TS_MAP_NOTIF

PL_TS_MAP_TRIGGERS

PRES_SIP_NOT

PRES_SIP_SUB

PRES_SIP_URI_MAP

PRM_USERS_BC

SHORTCODE_MAPING_STORE

SLEE_ALARM

SLEE_CHARGING

SLEE_INSTANCE_IDS

SLEE_LICENSE_TPS_LOG

SLEE_PL_MGR_PLUGIN

SLEE_SNMP_CONFIG

SLEE_SNMP_TRAP_RECEIVERS

SLEE_STATISTICS_DATA

SLEE_SUPPORTED_STATISTICS

SMPP_SERVICE_APP_INFO

SLEE_DB_LOCKS

SLEE_LICENSE_TPS_CHECK_STATE

SLEE_STATISTICS_CONFIG

SMPP_SERVICE_MO_CON

TPC_CALL_PARTICIPANTS_INFO

TPC_SIP_CALLSESSION_INFO

WLNG_ACCOUNT_GROUPS

WLNG_APP_ACCOUNTS

WLNG_APP_INSTANCES

WLNG_APP_SESSIONS

WLNG_BLOB_CONFIGURATION

WLNG_CONFIGURATION

WLNG_HTTPPROXY

WLNG_MGMT_USERGROUPS

WLNG_MGMT_USERS

WLNG_PRM_SESSIONS

WLNG_SLA_CUSTOM_XSD

WLNG_SLAS

WLNG_SP_ACCOUNTS

WLNG_SUBSCR_CONTRACTS

Services Gatekeeper Backwards Compatible Tables

If you are using backwards compatible listeners (CORBA-based) for alarms, EDRs, or CDRs, there are additional tables in the database. These tables are not included by default in the out-of-the-box version of Services Gatekeeper.

slee_alarm_config

slee_alarm_params

slee_alarm_severity_mapping

slee_charging_config

slee_charging_listeners

slee_edr_filter_properties

slee_edr_filters

slee_edr_listener_filters

slee_edr_listeners