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 02, 2017

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.

Symptoms

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="http://www.siebel.com/xml/SWIProductIntegrationIO">
              <siebelproduct:ProductIntegration>
                 <siebelproduct:WorkspaceName>ABC WorkSpace</siebelproduct:WorkspaceName>
                 <siebelproduct:WorkspaceReleaseFlag>N</siebelproduct:WorkspaceReleaseFlag>
                 <siebelproduct:WorkspaceReuseFlag>Y</siebelproduct:WorkspaceReuseFlag>
                 <siebelproduct:ListOfProductDefinition>
                    <siebelproduct:ProductDefinition>
                       <siebelproduct:PriceType>One-Time</siebelproduct:PriceType>
                       <siebelproduct:ProductId>1-XYZ</siebelproduct:ProductId>
                       <siebelproduct:BusinessUnitId>0-R9NH</siebelproduct:BusinessUnitId>
                       <siebelproduct:UnitofMeasure>Each</siebelproduct:UnitofMeasure>
                       <siebelproduct:PricingCommitType/>
                       <siebelproduct:DynamicDiscountMethod/>
...
      <remoteFault xmlns="http://schemas.oracle.com/bpel/extension">
          <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 "oracle.apps.aia.core.eh.BPELJavaAction".


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

...
UPDATE SIEBEL.S_ISS_JWS SET
      DB_LAST_UPD_SRC = :1,
      DB_LAST_UPD = current_date,
      LAST_UPD = :2,
      LAST_UPD_BY = :3,
      MODIFICATION_NUM = :4,
      EFF_RELEASE_TS = :5
   WHERE
      ROW_ID = :6 AND MODIFICATION_NUM = :7
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.
...



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