My Oracle Support Banner

Need Clarification On FLOW_INSTANCE States (Doc ID 2851847.1)

Last updated on MARCH 03, 2022

Applies to:

Oracle SOA Suite - Version 12.2.1.3.0 and later
Information in this document applies to any platform.

Goal

On : 12.2.1.3.0 version, Fabric

Need clarification on FLOW_INSTANCE States

During the upgrade process the weblogic(SOA, OSB) from 12.2.1.3 to 12.2.1.4, while proceeding with schema upgrade, the following queries are executed to check for closed/open instances count:

Closed/Aborted:
select count(s.flow_id) from sca_flow_instance s where s.active_component_instances= 0 and s.created_time >= to_timestamp('2011-09-01','YYYY-MM-DD') and s.created_time <= to_timestamp('2021-12-31','YYYY-MM-DD') and s.updated_time<= to_timestamp('2021-12-31','YYYY-MM-DD');

Open:
select count(s.flow_id) from sca_flow_instance s where s.active_component_instances> 0 and s.created_time >= to_timestamp('2011-09-01','YYYY-MM-DD') and s.created_time <= to_timestamp('2021-12-31','YYYY-MM-DD') and s.updated_time<= to_timestamp('2021-12-31','YYYY-MM-DD');

Which instance count it will give by using the below query, where active_component_instances has negative value?

select count(s.flow_id) from sca_flow_instance s where s.active_component_instances< 0 and s.created_time >= to_timestamp('2011-09-01','YYYY-MM-DD') and s.created_time <= to_timestamp('2021-12-31','YYYY-MM-DD') and s.updated_time<= to_timestamp('2021-12-31','YYYY-MM-DD');

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.