Updating foreign key for new account fails using Integration Object: SBL-DAT-00523, SBL-EAI-04451
(Doc ID 518766.1)
Last updated on NOVEMBER 22, 2019
Applies to:Siebel System Software - Version 188.8.131.52  and later
Oracle Solaris on SPARC (64-bit)
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 :-
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
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.
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