siebel

If you are getting tough time after upgrading your Internet Explorer to version 8.0 and if you have observed that no Menu items is working across the application i.e. Application Menus, Applet Menus etc, then don't get panic, this is something due to the new version only of IE. But not to worry here, IE 8.0 provides the facility of running the browser in compatibility view where it allows the

When I tried taking the export from Service Request list applet, I saw a difference in the way export applet was behaving in comparison with how it used to worked in IE 6.0. Right now I am using IE 7.0.So let me tell you the complete scenario what happened: From Service Request list applet, I clicked on Menu -> Export and as per expectation Export applet came up and I clicked on "Next" button.

Our team was facing one performance issue in our application in which navigation to a view was taking hell lot of time. As every Siebel developer does, we also spooled the query which is running in the background and found the culprit query for the issue. SQL query seems to be very simple:SELECT T1.CONFLICT_ID, T1.LAST_UPD, T1.CREATED, T1.LAST_UPD_BY,T1.CREATED_BY, T1.MODIFICATION_NUM, T1.ROW_ID,

Generally whenever you create a new Inbound Integration in Siebel, its a recommended practice that you get a new Database login created for it and that you can share with the other system for which you have created this inbound integration. I did the same thing, requested for a new DB login from our DBA and got it created. Before handing over to other party for use, I tried testing this newly

In our Siebel application, we are using OOB functionality for creating Service Requests via emails, and yes I think you guessed it right we are using Siebel eMail Response workflows which are available in Siebel Tools and you just need to configure them as per your need and these works really well.(For people who are new to this subject, to find these workflows you need to query in Siebel tools

Want to customize your tool bar? here is how you can do it. Depending upon where you want your button or control to go. You will have to select the appropriate toolbar and customixe it. In this post I will show you how to create a custom button to logout from your application. Step 1:   go to Command Object in your Object Explorer and query for "Logout " (If you cannot see this object. In tools go to View | Options | Object Explorer tab | check the Command Object) Step 2: Copy the the Logout command object and rename it to 'Logout New' (you could use the same one too) Step 3: Go to the toolbar Object in your Object Explorer and query for "HIQuery" toolbar(you could use another toolbar depending on where you would like to see your button on the application) Step 4 : click on the toolbar Item child object. Create a new record called ' Logout ' with the following properties - Name : Logout - Command : Logout New - Display Name : Logout   Step 5: ...

Hi all, This is usually a part of Branding, adding your own images/icons to the siebel application like I have added below. Required Configuration : Add the Screen on the Page tab. Only the image will be visibl e. In Bitmap Category create a new record with a unique name and the required parameters. In Bitmap child object create a new record with name ‘Screen Tab’ and in filename specify the name of the file with the .gif extention. To specify the properties of ‘Logo’ go to menu -->View-->Windows-->Properties Windows. Now you will be able to edit the ‘Height’ and ‘Width’ properties. In the Object Explorer goto Screen --> Create new/Use existing screen and give the required properties. Then goto Siebel Tools menu--> View-->Windows-->Properties Windows. Specify the name of the Bitmap Category in the Bitmap Category Property as displayed in the below figure. Compile all the Objects. Clear internet history and files. Reopen the Application. Yo...

Here is a complete documentation of how to pull Siebel data from an external application(JDeveloper) Cheers!

There are many ways of doing this. Here are two - 1. The first approach is a bit easier than the second. The script is written in the Applet_Load event of the Applet Browser Script. You can also invoke the executable file from a button click etc... Script function Applet_Load () { //Instantiate an ActiveX shell Objext. var wshell = new ActiveXObject("WScript.Shell"); var oFSO = new ActiveXObject("Scripting.FileSystemObject"); //the path of where this file has been installed sDirectory = "C:\\PROGRA~1\\WINDOW~1\\ACCESS~1\\"; sFile = "wordpad.exe"; sFilePath = sDirectory + sFile; //Check if the .exe file is installed if(oFSO.FileExists(sFilePath)) { execRet = wshell.Run(sFilePath, 3, false); } else { alert("You do not Wordpad Installed."); } oFSO = null; wshell = null; return ("CancelOperation"); } Now, When the applet loads wordpad will open. 2. T...

Hey Amigos, Here is a utility from Siebel Systems that converts VBScript to eScript. After conversion it is not totally done but you should be 85% on your way. Click on the below icon to download the converter. Cheers!

Hi Folks, Here is an Interesting tip shared by my Colleague Venus Hindocha about how to kill your Siebel.exe Process by avoiding the hassle of going to task manager and killing it there. you can use the foll command from Start -> Run or put it in a batch file taskkill /F /IM siebel.exe Some theory: Taskkill: Ends one or more tasks or processes. Processes can be killed by process ID or image name. Syntax: taskkill [/s Computer] [/u Domain\User [/p Password]]] [/fi FilterName] [/pid ProcessID]|[/im ImageName] [/f][/t] /f : Specifies that process(es) be forcefully terminated. This parameter is ignored for remote processes; all remote processes are forcefully terminated. /IM (ImageName): Specifies the image name of the process to be terminated. Use the wildcard (*) to specify all image names. More Details

In Siebel versions 6.x and 7.x, there are several number fields such as SR Number, Agreement Number, Asset Number, and Invoice Number which have the Pre Default Value = Expr: 'RowIdToRowIdNum ([Id])'. RowIdToRowIdNum is a function used in calculated expressions. This function converts an alphanumeric ROW_ID to a unique, pure numeric ROW_ID. The conversion is performed for digits and letters after or before the hyphen '-'. The formula used by RowIdToRowIdNum is the following: [Last digit or letter * 36^0] + [Second to last digit or letter * 36^1] + [Third to last digit or letter * 36^2] + ...+ [Second digit or letter * 36^n-1)] + [First digit or letter * 36^n] By design, values of letter A is 10, B is 11, C is 12 ... Y is 34, and Z is 35. Example 1: Take the example of ROW_ID = 1-5GYG0. Start converting from the last digit or letter from right to left, which is 0 in this case: 0 * 36^0 = 0 Conversion of second t...

The unique identifier associated with every record in a Siebel Enterprise database is known as a Row Id. The column in which this value is found is ROW_ID and it is present on every table. The Row Id is unique for an entity. For example, the Row Ids for the same person in S_PARTY, S_CONTACT, and S_CONTACT_X are the same because they each refer to the same person. Row Ids are used extensively throughout Siebel Enterprises to access specific records. Although users access records by a User Primary Key such as Opportunity Name, it is more efficient for the Siebel Enterprise to store and access related data via the Row Id. The Row Id is a base-36 sequence number generated using a confidential, proprietary algorithm that ensures no duplication , thus protecting the referential integrity of the database. The ROW_ID column is VARCHAR(15), which may contain one or two non-numeric symbols (plus signs or hyphens, or both). The format of the Row Id is one of the following: CP-NS - ...