Getting Unique Record Error Inserting Line Item Record On High Load Because of Duplicate Sequence Generation (Doc ID 2234003.1)

Last updated on FEBRUARY 15, 2017

Applies to:

Siebel Workflow - Version 8.1.1.14.10 [IP2014] and later
Information in this document applies to any platform.

Symptoms

On : 8.1.1.14.10 [IP2014] version, Siebel Workflow

Inserting line item record using workflow in async mode throwing following error on High Load.

ERROR
-----------------------
"Error invoking service 'FINS Data Transfer Utilities', method 'DataTransfer' at step 'Create WOLIE - DTU'.(SBL-BPR-00162)
--
The same values for 'Order Type, Line Number' already exist.
 
If you would like to enter a new record, please ensure that the field values are unique.(SBL-DAT-00382"


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create simple workflow with following steps
Start --> Siebel Operation insert step to create new line item --> End
2. Create simple client side BS to trigger this workflow in Async mode for the same order(Object Id)
3. Simulate this BS multiple times( 5 to 6 times) by specifying the iteration as 20

Observation :- Some of the WfProcMgr component task error out with user key conflict




Cause

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