My Oracle Support Banner

Importing SIF File With Multiple Workflow Processes And Delivering Multiple Workflow Processes To Workspace Fails With Error "ORA-00001: unique constraint (SIEBEL.S_RR_WORKFLOW_U1) violated" (Doc ID 2541759.1)

Last updated on OCTOBER 29, 2019

Applies to:

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

Symptoms

SIEBEL VERSION:                   18.12 version

ACTUAL BEHAVIOR
---------------

When delivering workspace with modified workflow processes, it fails with error.

ERROR MESSAGE
--------------------------------

The error that occurs are:



EXPECTED BEHAVIOR
-----------------------

The expected behaviour is that the workflow process should be delivered successfully since the workflow process does not exist in the workspace yet and is unique in the repository with a different/specific name.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Launch Siebel Tools and create a workspace.

2. Import a sif file that contains workflow process definitions exported out from another environment. The workflow processes are imported successfully.

3. Publish the workflow processes.

4. Deliver the workflow processes.

5. The error occurs here at the delivery step.

BUSINESS IMPACT
-----------------------

The issue has the following business impact:

Due to this issue, workflow processes are not delivered, thus cannot be activated and cannot be used in the environment to perform specific business functions.

Changes

 

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.