Integration Platform Technologies: Siebel Enterprise Application Integration > EAI Siebel Adapter Business Service > Enabling Effective Dating on Links >

About Siebel EAI Adapter Operations for Effective Dating on Links

The Siebel EAI Adapter receives the integration object in the format described in the Web Service Schema Example. Depending on the specified operations the effective dates are used as described in the following:

Insert Operation

After the record is inserted into the parent and child business component, the Siebel EAI Adapter reads the EDStartDate and the EDEndDate from the integration object and inserts these values into the corresponding effective dating business component.

Update Operation

After the record is inserted into the parent and child business component, the Siebel EAI Adapter removes all history records from the effective dating enabled business component and then reads the EDStartDate and EDEndDate values from the integration object and inserts these dates as fresh records into the business component.

NOTE:  The Update operation is only possible for currently active links (in other words, update is not possible if a link has been soft deleted by giving a end date value for the most recent history record).

Upsert and Synchronize Operations

If the upsert attribute is specified for the operation in the integration component then no history records are deleted, instead the history given in the XML input is inserted into the history table.

The synchronize operation can result in the insert, update or deletion of the child integration component as specified in the conditions set in the Synchronize Method.

XML Example

This example illustrates what is required if you want to perform an insert or upsert operation to insert or update multiple history records for the same child business component.

NOTE:  Multiple entries must be specified in the input XML code with same user key.

<hous:Household>

<hous:ListOfRelatedContact>

<hous:RelatedContact EDStartDate="1/1/2003" EDEndDate=">

<hous:ContactId>88-30KSP</hous:ContactId>

</hous:RelatedContact>

<hous:RelatedContact EDStartDate="1/1/2002" EDEndDate="12/31/2002">

<hous:ContactId>88-30KSP</hous:ContactId></hous:RelatedContact>

<hous:RelatedContact EDStartDate="1/1/2001" EDEndDate="12/31/2001">

<hous:ContactId>88-30KSP</hous:ContactId>

</hous:RelatedContact>

<hous:RelatedContact EDStartDate="1/1/2000" EDEndDate="12/31/2000">

<hous:ContactId>88-30KSP</hous:ContactId>

</hous:RelatedContact>

<hous:ListOfRelatedContact>

</hous:Household>