Getting Unique Record Error Inserting Line Item Record On High Load Because of Duplicate Sequence Generation
Last updated on FEBRUARY 15, 2017
Applies to:Siebel Workflow - Version 188.8.131.52.10 [IP2014] and later
Information in this document applies to any platform.
On : 184.108.40.206.10 [IP2014] version, Siebel Workflow
Inserting line item record using workflow in async mode throwing following error on High Load.
"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"
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
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