SMS_MT_SUBSCRIPTION_DEFS

Stores multi-tenant SMS subscription definitions, channel id, type, idempotency flag, converters, and details.

Details

• Schema: FUSION

• Object owner: FND

• Object type: TABLE

• Tablespace: Default

Primary Key

Name	Columns
SMS_MT_SUBSCRIPTION_DEFS_PK	SUBSCRIPTION_ID

Columns

Name	Datatype	Length	Not-null	Comments
SUBSCRIPTION_ID	VARCHAR2	36	Yes	UUID subscription id
SUBSCRIPTION_NAME	VARCHAR2	500	Yes	Name of subscription
ABS_CHANNEL_ID	VARCHAR2	36	Yes	Absolute Channel id
SUBSCRIPTION_TYPE	VARCHAR2	15	Yes	Type of subscription
IDEMPOTENT	VARCHAR2	1	Yes	idempotency flag
ADDITIONAL_DETAILS	BLOB			additional details
KEY_CONVERTER	VARCHAR2	36		Key converter
VALUE_CONVERTER	VARCHAR2	36		Value converter
TRANSFORMATION_SCHEMA	BLOB			Schema of message or business event transformation
PROTOCOL	VARCHAR2	100		Protocol or system that will be consuming messages on this subscription
PROTOCOL_SETTINGS	BLOB			Additional settings for this protocol, stored as JSON
SINK	VARCHAR2	100		Message sink for messages or business events
ASSIGNED_CONSUMERS	BLOB			Channel partition to consumer map, stored as JSON map
LATEST_OFFSETS	BLOB			Latest offsets for consumers, stored as JSON map
CREATED_BY	VARCHAR2	64	Yes	Who column: indicates the user who created the row.
CREATION_DATE	TIMESTAMP		Yes	Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY	VARCHAR2	64	Yes	Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE	TIMESTAMP		Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN	VARCHAR2	32		Who column: indicates the session login associated to the user who last updated the row.

Indexes

Index	Uniqueness	Tablespace	Columns
SMS_MT_SUBSCRIPTION_DEFS_U1	Unique	Default	SUBSCRIPTION_ID