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.
It is very good and useful for students and developer . Learned a lot of new things from your post!Good creation ,thanks for good info Oracle SOA Online Training
ReplyDeleteVitamins and Natural Supplements could be one aspect of the arrangement to help your heart wellbeing. There's not an alternative for getting the vitamins and minerals your body needs from healthy food, similar to vegetables, Fruits, and entire grains. However, in case you're eating well and still short on specific supplements, a few enhancements may help. Natural Treatment for Atrial Fibrillation is beneficial for begin taking anything new, to ensure you don't cause issues with your medicine. Natural Treatment helps to provide a lot of supplements for Atrial Fibrillation.
ReplyDelete