PSC_TS_FAULTED_PROCESS
This table provides detailed information about the faulted process and alerted task
Details
-
Schema: FUSION
-
Object owner: PSC_TS
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
PSC_TS_FAULTED_PROCESS_PK |
FAULTED_TRANS_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| FAULTED_TRANS_ID | NUMBER | 18 | Yes | This column indicates the Faulted Transaction ID | |
| PROCESS_ID | VARCHAR2 | 100 | Yes | This column indicates the OPA Process ID | |
| PROCESS_STATE | VARCHAR2 | 100 | Yes | This column indicates the OPA Process Status | |
| TASK_ID | VARCHAR2 | 100 | This column indicates the OPA Task ID | ||
| TASK_STATUS | VARCHAR2 | 100 | This column indicates the Task Status. | ||
| RESOURCE_TYPE | VARCHAR2 | 30 | This column indicates type of resource PROCESS or TASK to indicate whether the row is storing a FAULTED PROCESS or ALERTED TASK | ||
| ERROR_DETAILS | CLOB | This column indicates the detailed error in workflow activity as shown in OPA | |||
| ERROR_SUMMARY | VARCHAR2 | 1000 | This column indicates the summary of the workflow activity error shown in OPA | ||
| RECIPIENTS_USER_ID | VARCHAR2 | 1000 | This column indicates the recipiens user-id | ||
| PROCESS_DEF_ID | VARCHAR2 | 100 | This column indicates the process definition id | ||
| RECORD_ID | VARCHAR2 | 100 | Yes | This column indicates the record id. | |
| RECORD_KEY | NUMBER | 18 | Yes | This column indicates the record key. | |
| RECORD_STATUS | VARCHAR2 | 100 | This column indicates the record status. | ||
| RECORD_TYPE | VARCHAR2 | 100 | Yes | This column indicates the record type. | |
| CLASSIFICATION | VARCHAR2 | 10 | This column indicates classification of record. | ||
| SUB_CLASSIFICATION | VARCHAR2 | 100 | This column indicates Sub-classification of record. | ||
| 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. | |
| 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 |
|---|---|---|---|
| PSC_TS_FAULTED_PROCESS_N1 | Non Unique | Default | RECORD_ID |
| PSC_TS_FAULTED_PROCESS_N2 | Non Unique | Default | RECORD_STATUS |
| PSC_TS_FAULTED_PROCESS_N3 | Non Unique | Default | RECORD_TYPE |
| PSC_TS_FAULTED_PROCESS_PK | Unique | Default | FAULTED_TRANS_ID |