Hi All,
As me, you might be stumbling to find out what, similar to List of all states from COMPOSITE_INSTANCE, CUBE_INSTANCE, DLV_MESSAGE in 11g, the important tables would be for SOA Suite 12c and relevant states.
Basically this is described very well in the Oracle Support Document 2065869.1: 12c SOA composite <schema> States
For the benefit of every one, I have also copy pasted the content from the obove Oracle Note to here (copy right of the below details are with Oracle Support):
=======================================================================
CUBE_INSTANCE States
DLV_MESSAGE States
DLV_TYPE States
As me, you might be stumbling to find out what, similar to List of all states from COMPOSITE_INSTANCE, CUBE_INSTANCE, DLV_MESSAGE in 11g, the important tables would be for SOA Suite 12c and relevant states.
Basically this is described very well in the Oracle Support Document 2065869.1: 12c SOA composite <schema> States
For the benefit of every one, I have also copy pasted the content from the obove Oracle Note to here (copy right of the below details are with Oracle Support):
=======================================================================
Details
Based on 11g:
Tables COMPOSITE_INSTANCE and MEDIATOR_INSTANCE does not apply to 12c.
Tables CUBE_INSTANCE, DLV_MESSAGE and DLV_TYPE did not have any change.
The FLOW_INSTANCE is available only in 12c.
CUBE_INSTANCE States
| 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 States
| State | Description |
|---|---|
| 0 | STATE_UNRESOLVED |
| 1 | STATE_RESOLVED |
| 2 | STATE_HANDLED |
| 3 | STATE_CANCELLED |
| 4 | STATE_MAX_RECOVERED |
DLV_TYPE States
| State | Description |
|---|---|
| 1 | Invoke Message |
| 2 | DLV Message |
MEDIATOR States
Mediator state is now derived from SCA_ASYNC_CPNT_STATE table. The state column can take one of the following values:
FLOW_INSTANCE States
0 Active_Component_Instances
Completed Faulted Flow
0 Active_Component_Instances
1 or more Unhandled_Faults
Recoverable Flows
1 or more Active_Component_Instances
1 or more Recoverable_Faults
Completed Successfully
0 Active_Component_Instances
0 Unhandled_Faults
0 Recoverable_Faults
| State | Description |
|---|---|
| 1 | RUNNING |
| 2 | COMPLETED |
| 3 | FAULTED |
| 4 | ABORTED |
| 5 | STALE |
FLOW_INSTANCE States
| State | Description |
|---|---|
| -1 | NOT_SET |
| 1 | SUSPENDED |
| 2 | TERMINATED |
| 3 | STALE |
The Flow State is derived from the Flow Instance table using the following columns:
- Active_Component_Instances
- Unhandled_Faults
- Recoverable_Faults
- Admin_State
0 Active_Component_Instances
Completed Faulted Flow
0 Active_Component_Instances
1 or more Unhandled_Faults
Recoverable Flows
1 or more Active_Component_Instances
1 or more Recoverable_Faults
Completed Successfully
0 Active_Component_Instances
0 Unhandled_Faults
0 Recoverable_Faults
======================================================================
Further to the above Info, I also found a very useful blog that provides more knowledge / usage to the above table.
Oracle BPEL 12c Data model changes and FAQ
Hope this was helpful to you.
No comments:
Post a Comment