Some Workflows Have Inactive Flag Set to Y After Update From Siebel 20.6 Or Previous To Siebel CRM 21.9 Or Later Versions (Doc ID 2856693.1)

Last updated on OCTOBER 28, 2022

Applies to:

Symptoms

On this particular scenario customer was updating from Siebel CRM 19.12 to 21.12 version and some workflows in Siebel Repository table (S_WFR_PROC) has the Inactive flags set to Y.

The developers identified that they have some workflows that are been worked and should not have been Inactive set to Y.

The PostInstallDBSetup should only set Inactive=Y for the workflows NOT been used ONLY as per Document:2714523.1 - InactiveWFs Is Not Setting Inactive Property To TRUE For Any Workflows On the Repository, But Repository Has Lots of Unused Workflows

Customer notice that about 554 records in S_WFR_PROC have the Inactive flag set to TRUE (checked or Y on S_WFR_PROC column INACTIVE_FLG) by PostInstallDBSetup process, but some of these 554 are been used on the Development environment and the legacy Version column is not 0 and as indicated on Document 2714523.1 the PostInstallDBsetup should only act over legacy Version column = 0

The issue can be reproduced on customer environment with following steps:

1. Execute an update from Siebel CRM 19.12 to Siebel CRM 21.12 Development environment.

2. After the Update install end with success verify the PostInstallDBSetup reports and confirm no errors show up.

3. Open Siebel Tools and verify the workflows on the Repository, some workflows that are been used has Inactive set to checked and show inactive in Siebel Tools > Object Explorer > Workflow Processes.

Changes

Customer update Siebel CRM 19.x to 21.12

Cause

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