My Oracle Support Banner

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

Last updated on APRIL 30, 2018

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

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
Cause
Solution


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.