My Oracle Support Banner

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:

Siebel CRM - Version 20.7 and later
Information in this document applies to any platform.

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

 

Changes

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

Cause

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
Symptoms
Changes
Cause
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.