GeeKs Blogging @ dotCOM

Siebel – Automating Merge Records by script – II

I call this Part II, as I have already introduced the Merge Records Siebel functionality, and discussed its usage in his post. One of the interesting discussions we had was how such a data could possibly be inserted into the Siebel system, since Siebel has so many mechanisms to prevent Data Corruption. We had also zeroed in on EIM and EAI as the basic culprits which could possibly insert inconsistent data into the Siebel Database.

When such a thing happens on sucha large scale, or when we know the exact pattern whereby we can detect these duplicate records in the system, we may look at options to automate the process of Merging Records. How nice would it be if we could just somehow put it all up in a workflow or script which would achieve the above objective.

Exploring further on the topic, I came to realize that there is an undocumented BC method which we may fire to achieve the objective above. Try looking at the script below:

var Target_Id = “Dummy-001″;
var Source_Id = “Dummy-002″;
var bo_Contact = TheApplication().GetBusObject(“Contact”);
var bc_Contact = bo_Contact.GetBusComp(“Contact”);

bc_Contact.InvokeMethod(“SetAdminMode”, “TRUE”);
bc_Contact.SetViewMode(All);
bc_Contact.ClearToQuery();
bc_Contact.SetSearchSpec(“Id”, Source_Id + ” OR ” + Target_Id );
bc_Contact.ExecuteQuery(ForwardBackward);

if (bc_Contact.FirstRecord())
{
while (bc_Contact.GetFieldValue(“Id”) != Target_Id)
{
bc_Contact.NextRecord()
}
bc_Contact.InvokeMethod(“MergeRecords”, Source_Id);
}

If you notice carefully, we have invoked the method, “MergeRecords” on the Contact BC. The Contact BC has the class, “CSSBCContactSIS” which definitely, thus, supports this method. My guess would be that this method would be supported for all the BCs, where the vanilla Edit -> Merge Records functionality is enabled for the corresponding views. I haven’t actually gone further than this.

If somebody has had any other experience with Merge Records, please do share!

Related posts:

1. Siebel – Merge Records – Checklist I call this Part III, and concluding part of a...
2. Siebel – Merge Records Functionality How many times have we realized that there are multiple...
3. Siebel – Looping multiple records – Update records Hi, We often come across a requirement where we need...
4. Siebel – EAI Siebel Adapter – Looping Multiple Records This is a follow-up post on the post, Siebel –...
5. Siebel – Looping Multiple Records – III Looping through multiple records is a requirement we come across...
6. Siebel – Looping multiple records – Query and Process In my last post, I discussed as to how we...
7. Siebel – SIA BC Utility Service – Loop multiple records This is a vanilla business service which provides an extensive...