After Update from 20.6 or Previous to 20.7+ or Later Some Old Workflows Versions That Were Not In Use are Trigger Instead The Ones Been Used Or Give Error SBL-BPR-00158 (Workflow does not exist) (Doc ID 2764254.1)

Last updated on JANUARY 28, 2022

Applies to:

Symptoms

After update to Siebel CRM 20.7+ from previous version of CRM 17.0+ (such as 18.x or 19.x) some old versions of some workflow were been executed or some workflow failed to be executed indicating that the workflow does not exists.

For the workflow execution failed  scenario the following error is observed:

The PostInstallDBSetup finished with overall status of Completed (Successful), but there are lot of error above for different workflows.

Some background about the change introduced in IP 2017 AND Siebel CRM 20.7 Update for workflows:

Siebel Innovation Pack 2017 and Updates does NOT support the legacy concept of workflow version (table S_WFR_PROC, column VERSION) and status (table S_WFR_PROC, column STATUS_CD).

From IP 2017 to Siebel CRM 20.6 workflow versioning on Design Repository (DR) is provided by Workspace versions where the workflow is been edit. And on Runtime Repository (RR) the S_WFA_DPLOY_DEF/S_WFA_DATA contains the compiled workflow corresponding to the workspace version used when Activating the workflow on Workflow Deployment screen.

On Siebel CRM 20.7+ workflow in Runtime Repository is now workspace enabled as other regular Siebel object such as Applet and S_RR_WORKFLOW table started to be effective used to store a compile version of the workflow on column COMPILED_OBJ_DEFN for each workspace where the workflow was delivered, so now Developers can fully take advantage of parallel development not only on design but also when testing with each workspace running his "version" through workspace version.

For more details about the change introduced in 20.7 refer to

• "Siebel CRM 2020 TOI: Workflow in Workspaces Functional Overview" Transfer of Information presentation at Document "Get Proactive - Oracle Applications Transfer of Information (TOI) Online Training (Doc ID 732026.1)" > on drop down "Choose a Product Line" select "Siebel" and search  for the presentations available and click on "Siebel CRM 2020 TOI: Workflow in Workspaces Functional Overview"
  
  
• Bookshelf > Business Process Framework: Workflow Guide > Chapter  1 Whats New in This Release > Whats New in Siebel Business Process Framework: Workflow Guide, Siebel CRM 20.7 Update
  
• Bookshelf> Installation Guide for Microsoft Windows > Chapter 1 What’s New in This Release > What’s New in Siebel Installation Guide for Microsoft Windows, Siebel CRM 20.7 Update > check link Inactivating Workflow Processes AND About Database Updates for Siebel CRM 20.x Update

Changes

Monthly Update from Siebel CRM 17.0 - 20.6 update TO Siebel CRM 20.7 or later

Cause

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