To Automate "Generate Reporting Relationship" on the Position applet, you could :

1. Create the script as a Siebel business service.
2. Create a workflow process that calls this business service.
3. Schedule this workflow process to run at the interval you desire, by using Siebel's Repeating Component Request feature with the component "Workflow Process Manager".

function Service_PreInvokeMethod (MethodName, Inputs, Outputs)
{
var busobj;
var buscomp;

busobj = TheApplication().GetBusObject("Assignment");
buscomp = busobj.GetBusComp("Assignment Group");
buscomp.InvokeMethod("Release");

return (CancelOperation);
}

Note:Work flow Process Manager (Server Request) Business Service instead. This would fire the workflow process which runs on wfprocmgr component. This will then take the SADMIN username to invoke.

(OR)

Business Service script below:

function Service_PreInvokeMethod (MethodName, Inputs, Outputs)
{

try
{

var AsgnBO = TheApplication().GetBusObject("Assignment");
var AsgnBC = AsgnBO.GetBusComp("Assignment Group");
AsgnBC..InvokeMethod("Release");
}
catch (e)
{
Outputs.SetProperty("Error Message", e.toString())
}

finally
{
AsgnBC = null;
AsgnBO = null;
}

return (CancelOperation);
}

This is Siebel EIM Interview Q&A Part 3 We have collected the Siebel real time interview questions related to EIM ( enterprise integration manager) , these are asked in real interviews in most of the companies. All the best for your job interview!

1.What is the behavior of the EIM merge process?

Ans: Data from the record you select as the surviving record are preserved. Data from the other records are lost. If there are other records associated with the records you merge, those records—with the exception of duplicates—are associated with the surviving record.

2.Why is the IF_ROW_STAT column set to the value NO_SUCH_RECORD after running a merge process?

Ans: If you do not correctly populate all the user key columns, the merge process will fail and the IF_ROW_STAT column in the interface table will be set to the value NO_SUCH_RECORD. This indicates that EIM cannot find the appropriate rows to merge using the specified user keys.

3.Can EIM be used to merge rows from secondary tables?

Ans: EIM can only be used to merge rows from target base tables, and not secondary tables. For example, the target base table for EIM_ASSET is S_ASSET. EIM can only be used to merge two or more S_ASSET rows into single S_ASSET rows. You cannot use EIM to merge two or more S_ASSET_CON rows into single S_ASSET_CON rows. During EIM merge, EIM will merge rows from the target base table, and update the rows from the secondary tables to reference the surviving target base table rows. If you try to merge two secondary tables rows into one row by populating the interface table with user keys of the secondary table rows, the interface table victim and survivor rows will have the same target base table user keys values, which will cause the target base table row to be deleted.

4.What is the recommended number of rows that can be loaded in a single batch?

Ans: For an initial load, you can use 30,000 rows for a large batch. For ongoing loads, you can use 20,000 rows for a large batch. You should not exceed 100,000 rows in a large batch. Furthermore, you should limit the number of records in the interface tables to those that are being processed. For example, if you have determined that the optimal batch size for your system is 19,000 rows per patch and you are going to be running 8 parallel EIM processes, then you should have 152,000 rows in the interface table. Under no circumstances should you have more than 250,000 rows in any single interface table, since this will have a tremendous negative performance impact. NOTE: The number of rows you can load in a single batch may vary depending on your physical machine setup. To reduce demands on system resources and improve performance, you should always try to use smaller batch sizes.

5. Should EIM stop processing when multiple rows fail a pass?

Ans: EIM is designed to import large volumes of data. Most failures are caused by data errors. It is usually faster and easier to correct the data errors and resubmit the corrected rows as part of a subsequent batch than to reprocess an entire batch. EIM does not stop when failures occur.

Create a User Defined Error Message which can smartly display dynamic text.

 Solution:  

1.  Create a User Defined Error with the text ‘%1 …followed by your text’

2.  Add the script behind the button where you want to invoke this error from

The parameter that is substituted in place of %1 is "Letter" or “Fax”, which is present in the message test

DBISQLC.EXE is the utility used to connect to sample/local database for DML,DDL operations. But how do we export the results of a query to a file?

 Solution:

 By using ‘OUTPUT’ command.

 e.g.

SELECT * FROM SIEBEL.S_CONTACT

To export the data to a file for the above query you have to issue the following query

 Note:-Don’t forget to add ‘;’ after the query and before OUTPUT TO clause otherwise you will get an error. Also make sure that a blank file exists in the path before you execute the query.

 Syntax:-