1. Integration Platform Technologies: Siebel Enterprise Application Integration Guide
  2. Siebel EAI Adapter Operations for Effective Dating on Links

Siebel EAI Adapter Operations for Effective Dating on Links

The Siebel EAI Adapter receives the integration object in the format described in the Enabling Effective Dating on Links. Depending on the specified operations the effective dates are used as described in the following:

  • Insert operation. Once 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. Once 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 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 the 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>