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

Last updated on MARCH 01, 2018

Applies to:

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 :-

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 :-

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

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.