My Oracle Support Banner

AIA for Communications: Siebel Product Workspace update conflict (SBL-DAT-00523) during products bulk synchronization from BRM to CRM (Doc ID 1352388.1)

Last updated on MARCH 01, 2018

Applies to:

Siebel CRM Service - Version 8.0 SIA [20405] and later
Oracle Communications Integration Pack for Order to Billing - Version 2.0.1 and later
Information in this document applies to any platform.


The error: "The selected record has been modified by another user since it was retrieved. Please continue.(SBL-DAT-00523)" can occur then many products of same Siebel Workspace project are synchronized in parallel from Oracle BRM to Siebel CRM.

As result of failure of product update, changes for that product are not reflected in Siebel CRM (for example Unit of Measure or Price Type fields could be left empty).

Retry to updating of single product from BRM to CRM, however, can be executed well.

* * *
Sample traces  of standard integration scenario for the AIA for Communications PIP: "Order to Bill":

(1) the Siebel ABCS Provider: "ProductOptimizedSyncPriceListListSiebelCommsProvABCSImpl" (Raw XML Audit traces):

event ... label="UpdateSingleProduct" ...
 ... message ... Faulted while invoking operation "SWIProductImportUpsert" on provider "SiebelProductService".
 ... details ...
        <SWIProductImportUpsert_Input ...>
           <siebelproduct:ListOfProductImport xmlns:siebelproduct="">
                 <siebelproduct:WorkspaceName>ABC WorkSpace</siebelproduct:WorkspaceName>
      <remoteFault xmlns="">
          <part name="code"> ... Server
          <part name="summary">... The selected record has been modified by another user since it was retrieved. Please continue.(SBL-DAT-00523)
          <part name="detail"> ... siebelf:logfilename ... EAIObjMgr_enu_0022_30000003.log

event ... label = "closed.faulted" ...
 ... message ... [FAULT RECOVERY] Invoked handleBPELFault on custom java action class "".

(2) the Siebel EAI Object Manager detailed traces of file, referenced in the SOAP Fault  (the "EAIObjMgr_enu_0022_30000003.log"):

      DB_LAST_UPD_SRC = :1,
      DB_LAST_UPD = current_date,
      LAST_UPD = :2,
      LAST_UPD_BY = :3,
      EFF_RELEASE_TS = :5
SQLParseAndExecute Bind Vars 4 .....1: Object Manager - Default
SQLParseAndExecute Bind Vars 4 .....2: <Current Time Stamp>
SQLParseAndExecute Bind Vars 4 .... 3: 1-USR <Row Id of the Siebel user>
SQLParseAndExecute Bind Vars 4 ...  4: 80299 <New Modification Id value, EAI task suggests for this update>
SQLParseAndExecute Bind Vars 4 ...  5: <Time Stamp of 'Effective Since' date>
SQLParseAndExecute Bind Vars 4 ...  6: 1-ABC <Row Id of the Workspace: 'ABC Workspace'>
SQLParseAndExecute Bind Vars 4 ...  7: 80298 <Modification Id value, EAI task expects, since last Select/Update to find in the table record>
ObjMgrBusCompLog Error 1  ... (oracon.cpp (1738)) SBL-DAT-00523: The selected record has been modified by another user since it was retrieved. Please continue.


To view full details, 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 a vibrant support community of peers and Oracle experts.