FFS_OFFLINE_SYNC

Stores synchronization errors logged during applying actions performed in the off-line mode.

Details

• Schema: FUSION

• Object owner: FFS

• Object type: TABLE

• Tablespace: DATA

Primary Key

Name	Columns
FFS_OFFLINE_SYNC_PK	OFFLINE_SYNC_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
OFFLINE_SYNC_ID	NUMBER		10	Yes	System generated primary key column.
USER_ID	NUMBER		18		Unique Identifier Of The User Id.
RESOURCE_ID	NUMBER		8		Unique Identifier Of The Resource Id.
ACTION	VARCHAR2	1020			Displays Where The Conflict Occurred.
ENTITY	NUMBER		8	Yes	Type Of Entity (For example 1 - 'activity', 2 - 'inventory').
ENTITY_ID	VARCHAR2	1020			ENTITY ID (for example activity id).
ACTION_TIME	TIMESTAMP			Yes	Displays The Time When The Conflict Occurred (Gmt).
STATUS	NUMBER		3	Yes	Conflict status. 0 - the conflict could not be resolved, 1 - auto resolved the conflict.
REASON_CODE	NUMBER		3	Yes	Conflict Reason Code (For example '21', '41').
ERROR_DESCRIPTION	VARCHAR2	4000			Description Of The Conflict Error.
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
FFS_OFFLINE_SYNC_PK	Unique	DATA	OFFLINE_SYNC_ID