BPEL_PROCESS_INSTANCES
Table D-1 provides an overview of all the process instances of Oracle BPEL Process Manager and Oracle Mediator.
Table D-1 BPEL_PROCESS_INSTANCES View
| Attribute Name | SQL Type | Attribute Size | Indexed or Unique? | Null? | Comment |
|---|---|---|---|---|---|
|
|
|
-- |
PK |
N |
Unique instance ID |
|
|
|
500 |
-- |
N |
User-defined application name |
|
|
|
500 |
-- |
N |
User-defined composite name |
|
|
|
50 |
-- |
N |
User-defined revision number |
|
|
|
500 |
-- |
N |
User-defined label |
|
|
|
500 |
-- |
N |
User-defined component name |
|
|
|
200 |
-- |
Y |
User-defined title of the BPEL process |
|
|
|
-- |
-- |
Y |
State of the BPEL process instance |
|
|
|
21 |
-- |
Y |
Text presentation of the state attribute |
|
|
|
-- |
-- |
Y |
User-defined priority of the BPEL process instance |
|
|
|
200 |
-- |
Y |
User-defined status of the BPEL process |
|
|
|
100 |
-- |
Y |
User-defined stage property of a BPEL process |
|
|
|
256 |
-- |
Y |
User-defined conversation ID of a BPEL process |
|
|
|
6 |
-- |
N |
Creation time stamp of the process instance |
|
|
|
6 |
-- |
Y |
Time stamp when the process instance was modified |
|
|
|
-- |
-- |
Y |
Date portion of |
|
|
|
-- |
-- |
Y |
Hour portion of |
|
|
|
-- |
-- |
Y |
Evaluation time of the process instance in milliseconds |