Following is list of States Description and Values for Oracle SOA Suite 10g/11g categorized by table name:
COMPOSITE_INSTANCE
| State | Description |
| 0 | Running |
| 1 | Completed |
| 2 | Running with faults |
| 3 | Completed with faults |
| 4 | Running with recovery required |
| 5 | Completed with recovery required |
| 6 | Running with faults and recovery required |
| 7 | Completed with faults and recovery required |
| 8 | Running with suspended |
| 9 | Completed with suspended |
| 10 | Running with faults and suspended |
| 11 | Completed with faults and suspended |
| 12 | Running with recovery required and suspended |
| 13 | Completed with recovery required and suspended |
| 14 | Running with faults, recovery required, and suspended |
| 15 | Completed with faults, recovery required, and suspended |
| 16 | Running with terminated |
| 17 | Completed with terminated |
| 18 | Running with faults and terminated |
| 19 | Completed with faults and terminated |
| 20 | Running with recovery required and terminated |
| 21 | Completed with recovery required and terminated |
| 22 | Running with faults, recovery required, and terminated |
| 23 | Completed with faults, recovery required, and terminated |
| 24 | Running with suspended and terminated |
| 25 | Completed with suspended and terminated |
| 26 | Running with faulted, suspended, and terminated |
| 27 | Completed with faulted, suspended, and terminated |
| 28 | Running with recovery required, suspended, and terminated |
| 29 | Completed with recovery required, suspended, and terminated |
| 30 | Running with faulted, recovery required, suspended, and terminated |
| 31 | Completed with faulted, recovery required, suspended, and terminated |
| 32 | Unknown |
| 64 | Stale |
CUBE_INSTANCE
| State | Description |
| 0 | STATE_INITIATED |
| 1 | STATE_OPEN_RUNNING |
| 2 | STATE_OPEN_SUSPENDED |
| 3 | STATE_OPEN_FAULTED |
| 4 | STATE_CLOSED_PENDING_CANCEL |
| 5 | STATE_CLOSED_COMPLETED |
| 6 | STATE_CLOSED_FAULTED |
| 7 | STATE_CLOSED_CANCELLED |
| 8 | STATE_CLOSED_ABORTED |
| 9 | STATE_CLOSED_STALE |
| 10 | STATE_CLOSED_ROLLED_BACK |
DLV_MESSAGE
| State | Description |
| 0 | STATE_UNRESOLVED |
| 1 | STATE_RESOLVED |
| 2 | STATE_HANDLED |
| 3 | STATE_CANCELLED |
| 4 | STATE_MAX_RECOVERED |
DLV_TYPE
| State | Description |
| 1 | Invoke Message |
| 2 | DLV Message |
MEDIATOR_INSTANCE
| State | Description |
| 0 | No faults but there still might be running instances |
| 1 | At least one case is aborted by user |
| 2 | At least one case is faulted (non-recoverable) |
| 3 | At least one case is faulted and one case is aborted |
| 4 | At least one case is in recovery required state |
| 5 | At least one case is in recovery required state and at least one is aborted |
| 6 | At least one case is in recovery required state and at least one is faulted |
| 7 | At least one case is in recovery required state, one faulted and one aborted |
| >=8 and < 16 | Running |
| >= 16 | Stale |
Oracle Fusion Middleware 
Leave a comment