If you are running into this error when you click on the "Activities"
tab in the standalone(olite based) instance of Oracle BPEL
Console(10.1.3.4), then it is due to a missing column, namely
process_guid, in "admin_list_wi" view.
You can create the view again by running the following.
create or replace view admin_list_wi
as select wi.cikey, wi.node_id, wi.scope_id, wi.count_id,
wi.creation_date wi_creation_date, wi.creator wi_creator,
wi.modify_date wi_modify_date, wi.modifier wi_modifier,
wi.state wi_state, wi.transition,
wi.exp_date, exp_flag, wi.priority wi_priority,
wi.label, wi.custom_id, wi.comments, wi.reference_id,
wi.execution_type,
ci.domain_ref as ci_domain_ref,
ci.process_id process_id, ci.revision_tag revision_tag,
ci.process_guid process_guid,
ci.title title, ci.root_id, ci.parent_id, fault_name,
index_1, index_2, index_3, index_4, index_5, index_6
from cube_instance ci, work_item wi, wi_fault fault, ci_indexes indexes
where ci.cikey = wi.cikey (+)
and fault.cikey (+) = wi.cikey
and fault.node_id (+) = wi.node_id
and fault.scope_id (+) = wi.scope_id
and fault.count_id (+) = wi.count_id
and indexes.cikey (+) = ci.cikey ;
