Composite states can be found in the following schema/table/column:
<env>_soainfra.composite_instance.state
BPEL component states can be found here:
<env>_soainfra.cube_instance.state
Mediator component states can be found here:
<env>_soainfra.mediator_instance.component_state
This table maps, to the best of my ability, the various states. It is nowhere near complete, and still requires clarification, but it is the most complete mapping out there to date.
| State | COMPOSITE_INSTANCE | CUBE_INSTANCE | MEDIATOR_INSTANCE |
| Open and Running | 0 | 1 | 8 |
| Open and Suspended | 8 | 2 | |
| Open and Faulted | 34 | 3 | 2 |
| Closed and Aborted | 8 | ||
| Closed and Cancelled | 7 | ||
| Closed and Completed | 1 | 5 | 0 |
| Closed and Faulted | 2 / 3 | 6 | |
| Closed and Pending/Cancel | 4 | ||
| Closed and Stale | 64 | 9 | 16 |
| Initiated | 0 | ||
| Terminated | 16 / 48 / 50 | ||
| Recovery Required | 4 / 5 / 7 | 4 | |
| Non-Recoverable | 10 | ||
| Unknown | 32 |
If you have any additions or corrections to the table above, please leave a comment below and I'll update it.
4 comments:
good job.
thank you
Oracle has FINALLY released a list of the instance states. See this blog post:
http://blogs.oracle.com/ateamsoab2b/entry/list_of_all_states_from
I see the blog post but for Composite_Instance - what is State=64 mean? They display "-" ?
Unfortunately, there is no documentation on the "64" state in the COMPOSITE_INSTANCE table.
Even Oracle Doc ID 1362028.1 doesn't describe it. At this time, your best bet is to open an SR to find out for sure.
Post a Comment