You can use SQL to query the instance table in the ORABPEL schema in Oracle BPEL Process Manager 10g (10.1.3.4) to narrow down your search.
PROCESS_ID STATE CREATION_DATE REVISION_TAG DURATION INSTANCE_ID
- The STATE column stores values of 1 (In-flight), 5 (Success), 6 (Warning), 8 (Error), and 9 (Stale). Stale processes are those that have been undeployed.
- The DURATION column is calculated by substracting the CREATION_DATE from the MODIFY_DATE. The CREATION_DATE is when the process was instantiated, and the MODIFY_DATE is when the last activity in the process was executed.
- Per the SQL statement above, the INSTANCE_ID is actually parsed from the TITLE column.