siebel

As the quote goes, "You cannot NOT have a user experience". User experience is one of the most important things in product design. I personally feel that Siebel's User Interface could be a lot better than what it is (but thanks to the new Innovation pack for 2012, with the Open UI I think Siebel is getting there). Most users do not like drilling down on a record which then takes them to the detail view of a record and then navigating back to the parent record. What they usually ask for is, if they could have the tabs right on the main view of the screen. Something like this -   Some thought this was not possible but actually it is and requires just a web template change for the Aggregate views. Change the Web Template of the view to either one of the following - 1. View Parent Multi Child With Tabs 2. View Parent List With Tabs 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 - ...