FFS_CATALOG_SCM_SYNC
Manages the synchronization process between Supply Chain Management (SCM) and Oracle Field Service (OFS).
Details
-
Schema: FUSION
-
Object owner: FFS
-
Object type: TABLE
-
Tablespace: DATA
Primary Key
| Name | Columns |
|---|---|
|
FFS_CATALOG_SCM_SYNC_PK |
CATALOG_SCM_ID, TYPE |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| CATALOG_SCM_ID | NUMBER | 10 | Yes | Reference to the corresponding FFS_CATALOG_SCM, associating each sync process with the right catalog integration setup. | |
| TYPE | VARCHAR2 | 4 | Yes | Type of the synchronization process, such as 'CURR' or 'PREV'. | |
| SYNC_SCHEDULED_AT | TIMESTAMP | Yes | Timestamp indicating when a synchronization process is scheduled to start. | ||
| STATUS | VARCHAR2 | 255 | Status of the synchronization process, such as 'SYNCED', 'ERROR', or 'SYNCING'. | ||
| SYNC_STARTED_AT | TIMESTAMP | Timestamp marking the start of the synchronization process. | |||
| SYNC_FINISHED_AT | TIMESTAMP | Timestamp marking the end of the synchronization process. | |||
| TOTAL_ITEMS | NUMBER | 10 | Numeric field indicating the total number of items expected to be processed in the sync. | ||
| PROCESSED_ITEMS | NUMBER | 10 | Count of items that have been processed in the ongoing synchronization iteration, indicating sync progress. | ||
| CATALOG_VERSION_ID | VARCHAR2 | 255 | Version of the catalog created during the sync iteration. | ||
| SYNC_TRACE_ID | VARCHAR2 | 255 | Unique identifier for the sync process, instrumental in tracking and investigating operations. Also associated with corresponding log entries. | ||
| ERROR_CODE | VARCHAR2 | 255 | Error code provided when a sync process ends with an error. | ||
| ERROR_DESC | VARCHAR2 | 4000 | Detailed description of the error encountered during the sync process. | ||
| ADDITIONAL_DATA | VARCHAR2 | 4000 | Additional not standardized JSON data of the sync 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. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| FFS_CATALOG_SCM_SYNC_U1 | Unique | DATA | CATALOG_SCM_ID, TYPE |