Use of Siebel EAI to solve complex Config requirement

Scenario :

To Synch up the Account Team with associated Opportunties team.

Issue :

Use of scripting option : Too much performance impact if number of opptys associated with the account .

Solution :



Create a IO TestAccIO , based on Account BO , with Account and Postion as IC
Create a IO TestOptyIO ,based on Opportunity BO , with Opportunity and Position as IC.

Create a Datamap map mapping TestAccIO as source IO and Target IO as TestOptyIO
map only the child position IC fields 1:1

Create a workflow process with below steps
1) Account Message : EAI siebel Adapter getting the Account message
2) Datamap : EAI Datamapping engine , using the above created map
3) Get Opty IDs : Query in Opty BC with Account Ids
4) populate the Opty id : Populate the Opty id in the Opty Message.
5) upsert on Opty : EAI Siebel Adapter using upsert method .
6)end

Invoke this workflow in the Account Write REecord script (preferably by checking if any update happened on Accoun team to restrict invokation only on the account team updatation)

Use Server Request business service to put the request to workflow process manager , with asynch mode .