Error SBL-DAT-00494 Occurring While updating Activity under Service Request Screen by different Users (Doc ID 1265613.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel CRM - Version 8.0 SIA [20405] and later
Information in this document applies to any platform.

Symptoms


Siebel Version: 8.1.1. 1 SIA

Statement Of Issue: When updating same Activity record in two different sessions, throwing unexpected error.

Steps to Reproduce:
1. Go to application1 create a activity under service request screen with Type,Sub type and status fields filled and save the record and leave other fields blank.
2. Go to application 2 and query for service request to which activity has been added and select activity record added in application1
3. Enter values for remaining fields and save the record.
4. Now goto application1 and don't refresh activity applet enter the values for left out fields and save the record.

Error Thrown:


The selected record has been deleted by another user since it was retrieved. Please continue.(SBL-DAT-00494)
SBL-DBC-00111: An error has occurred writing to a record. Please continue or ask your systems administrator to check your application configuration if the problem persists.
The target name PAR_ROW_ID is specified more than once for an assignment in the same SQL statement

Business Impact: Misleading the users with errors.

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