Updating foreign key for new account fails using Integration Object: SBL-DAT-00523, SBL-EAI-04451 (Doc ID 518766.1)

Last updated on JULY 11, 2017

Applies to:

Siebel System Software - Version 7.8.2.1 [19216] and later
Oracle Solaris on SPARC (64-bit)

Symptoms

BACKGROUND::
Account data feeds are received every night and Siebel EAI Adapter is used to UPSERT all these records into Siebel. New and exising Account updates are sent as part of the feed. There are different types of accounts that are fed but we are using only one IO to load the data into siebel. We are multi-org, so wholesaler type of Accounts would be promoted to Organization. The entities that are getting updated are Account, Organization, Position, Business Address, Bill to Address, Ship to Address.  I am using CSV to property set BS and pass the property set to Siebel EAI Adapter.

An IO has been created based on Account Business Object as per following :-


IO : Account Io
    1 IC : Account
    2 IC : Internal Division
    3 IC : Account_Business Address
    4 IC : Account_Bill To Business Address
    5 IC : Account_Ship To Business Address
    6 IC : Account_Organization




PROBLEM::

When creating a new Account in Siebel with the above IO, it works as long as there are no association entities that update Primary fields on Account (when only Account, Internal Division details are in the CSV).  But when the feed inlcudes any of the Account_Organization OR Account_Position OR Account_Business Address OR Account_Bill To Business Address OR Account_Ship To Business Address, the EAI Siebel Adapter generates error :-

Error invoking service 'EAI Siebel Adapter', method 'Upsert' at step 'Upsert'.(SBL-BPR-00162)



Method 'WriteRecord' of business component 'Account' (integration component 'Account') for record with search specification '[Location] IS NULL AND [Name] = "Test Acc"' returned the following error:"The selected record has been modified by another user since it was retrieved. Please continue.(SBL-DAT-00523)"(SBL-EAI-04451)



If these association entities are used for an existing Account in Siebel, it also works fine.

Changes

 

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