SIEBEL: IC User Properties

IC user properties

SupressQueryOnInsert - IC Level:Use this property for performance tuning the EAI Siebel Adapter operation. If you are doing EAI Siebel Adapter Insert operation, the system will automatically search for the record before it is created. This is the default behavior. If you are sure that the record is new and can handle errors, add SupressQueryOnInsert user property with value Y to the IC. This will improve the performance of the operation.

PICKLIST, PicklistUserKeys - IC Field Level: Picklist user property has a peculiar behavior. If the property value is Y, it will validate the Picklist value and error out in the EAI siebel adapter operation. If the value is not present then the validation happens at BC level (Object Manager). You can see the error in EAI Object manager log rather than workflow log if you are calling the Workflow in a web service.

This has one more advantage of auto filling field values when set to N. For example, status field has Active and Inactive as valid values in picklist. If the XML has Status as 'Act', and if the PICKLIST property is set to N, the operation will set Active as the field value. 


Bookshelf mentions that performing the validation of a bounded picklist in the EAI Siebel Adapter is about 10% faster than performing the validation in the Object Manager.

Consider a scenario where we need to set Account to ABC for a Contact record. There can be multiple accounts with name ABC. Then I have to identify a particular ABC record based on another criteria like Account Number field and set the field values accordingly. In this case PicklistUserKeys property should be used. We need to set the value to 'Name, Account Number' and these two fields should be available in IC. This will determine the picklist value to pick.

Ignore Bounded Picklist is another user property which can be used to avoid bounded picklist errors in EAI Siebel Adapter operations. Valid values are Y,N.