Workflow Management Does Not Allow Change In Workflow Schema To Another Workflow Group (Doc ID 1922618.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Demantra Demand Management - Version 12.2.3 and later
Information in this document applies to any platform.

Goal

Customer is on 12.2.3 and mentions that removing the workflow from the
original group and associating to another, it does reflect the same on the
front end ( workflow manager). However they still can see in the back end
tables that the workflow is associated to both group. After bounce the
webservice all changes are undone and the workflow is in both the groups from
both the front end and the backend

Reproduction steps
1. Created a new workflow called Test schema

2. Added to the workflow group Demand management
3. Can see it in the database in the backend ( one row comes up)


select wgs.*, ws.schema_name, wsg.* from wf_schema_groups wsg,
wf_groups_schemas wgs, wf_schemas ws
where wgs.group_id =wsg.group_id and ws.schema_id =wgs.schema_id
and (ws.schema_name like 'Test%' or ws.schema_name like '%Test%')


1713 Test schema 43 43 Demand Management Demand Management Workflows 387 1
WF_SCHEMA_GROUP:43


4. Then created a new Workflow group called ---> test schema

5. Added the workflow Test schema to this new workflow group Test schema and
now can see this workflow Test schema in both the Demand Management and Test
schema workflow group

select wgs.*, ws.schema_name, wsg.* from wf_schema_groups wsg,
wf_groups_schemas wgs, wf_schemas ws
where wgs.group_id =wsg.group_id and ws.schema_id =wgs.schema_id
and (ws.schema_name like 'Test%' or ws.schema_name like '%Test%')

Now 2 rows

1713 Test schema 324 324 Test schema 387 0 FEE14C32D60CBA61E040950A2F710524
1713 Test schema 43 43 Demand Management Demand Management Workflows 387 1
WF_SCHEMA_GROUP:43


Can see the the same from the front end too

Test schema workflow in 2 workflow groups --Demand Management and Test Schema


6. Then from the front end removed the workflow Test schema from the Demand
Management workflow group. From front end now do not see Test schema workflow
in Demand Management group


7. But in the backend it still show Test schema in both the workflow groups (
Demand Management and Test schema)

select wgs.*, ws.schema_name, wsg.* from wf_schema_groups wsg,
wf_groups_schemas wgs, wf_schemas ws
where wgs.group_id =wsg.group_id and ws.schema_id =wgs.schema_id
and (ws.schema_name like 'Test%' or ws.schema_name like '%Test%')

1713 Test schema 324 324 Test schema 387 0 FEE14C32D60CBA61E040950A2F710524
1713 Test schema 43 43 Demand Management Demand Management Workflows 387 1
WF_SCHEMA_GROUP:43



8. Bounced the application and see that the Test schema is now in both Demand
management and Test Schema workflow group. SO even if we remove a workflow
from a group, it shows as removed from the front end, but the back end tables
still show it in the group. And a bounce undos it and you can see the
workflow in that group again
 

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms