ZCA_UNDELIVERED_SIGNALS

This table stores the signals that were unable to be delivered through the normal Signal Delivery Framework process due to timeout or unavailable endpoint.

Details

• Schema: FUSION

• Object owner: ZCA

• Object type: TABLE

• Tablespace: Default

Primary Key

Name	Columns
zca_undelivered_signals_PK	ZCA_UNDELIVERED_SIGNALS_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
ZCA_UNDELIVERED_SIGNALS_ID	NUMBER		18	Yes	Primary Key - Unique Identifier for an undelivered signal
DELIVER_TO_CODE	VARCHAR2	256		Yes	The code identifying to which Signal Delivery Framework consumer this signal information had not been delivered
CORRELATION_ID	VARCHAR2	128		Yes	A unique identifier that correlates the enriched signal to an committed transaction.
SIGNAL_TIMESTAMP	TIMESTAMP			Yes	The date and time when the signal was originally generated.
SIGNAL_REQUESTED_BY	VARCHAR2	64		Yes	The username which committed the transaction from which the signal had been generated.
SIGNAL_DOCUMENT	CLOB			Yes	A JSON document that contains the enriched signal content generated from a transaction that had failed to be delivered.
RETRY_COUNT	NUMBER		5	Yes	The count of the number of retry attempts.
DELIVERY_FAILED_DATE	TIMESTAMP			Yes	The time at which the last attempted delivery was made.
DELIVERY_FAILURE_REASON	VARCHAR2	64		Yes	A general indication of the reason that the signal could not be delivered.
NEXT_DELIVERY_DUE	TIMESTAMP			Yes	A marker timestamp to indicate that this instance is ready for the ESS Job to process.
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.
OBJECT_VERSION_NUMBER	NUMBER		9	Yes	Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
SIGNAL_ERROR_COMPONENT	VARCHAR2	64			Used to identify the component involved in the signal processing viz FA/Enrichment MS/Triage MS

Foreign Keys

Table	Foreign Table	Foreign Key Column
zca_undelivered_signal_objects	zca_undelivered_signals	ZCA_UNDELIVERED_SIGNALS_ID

Indexes

Index	Uniqueness	Tablespace	Columns
ZCA_UNDELIVERED_SIGNALS_N1	Non Unique	Default	NEXT_DELIVERY_DUE, DELIVER_TO_CODE, CORRELATION_ID
ZCA_UNDELIVERED_SIGNALS_N2	Non Unique	Default	SIGNAL_ERROR_COMPONENT, RETRY_COUNT, DELIVERY_FAILURE_REASON
ZCA_UNDELIVERED_SIGNALS_U1	Unique	Default	ZCA_UNDELIVERED_SIGNALS_ID