17
Aug
2009
Siebel – Run Case Insensitive queries
This is a nice tip I ran across. All the Siebel Developers use Siebel Tools and Siebel Web Client extensively. And, each one of us run over a hundred queries daily. However, when querying for some data, for eg. a Business Service Name in Tools, Siebel generally demands we enter the correct case. To streamline the process and improve productivity, I continuously keep making minor modifications in my environment settings.
12
Aug
2009
Siebel – Left, Right and from the Middle
Extracting a sub string from a lengthy string in Siebel. What is the best solution you can think up for this typical problem? I know, I know, you and you colleagues have done this thousands of times before. But, have you ever successfully done it without using a single line of scripting?!!
Now, it becomes interesting! 
21
May
2009
Siebel 7.x – Party Model Changes
After introduction of party model, the table structure (as far as EIM is concerned) have changed tremendously. The largest data model change involves the Party model, which I think is basis of post siebel 7 releases. Accounts, Organizations, Internal Divisions, Contacts, Employees, Positions, and Households are all party entities and are the logical extension table of S_PARTY and they all have the corresponding entry in S_PARTY base table and the data is brought into the business components through an implicit join (PLEASE NOTE THEY ARE NOT EXPLICIT JOINS).
10
May
2009
Siebel – InvokeServiceMethod() on Calculated Fields
InvokeServiceMethod() is used to invoke Business Services and take values from it in case of Calculated Fields.
I actually wanted to post on something else, but, I guess this has to be a precursor to it.
All of us know of Calculated Fields in Siebel Business Components. I am sure they must have solved some very big problems for you at times, as they have for me. However, not all of us know that we can actually invoke Business Service scripts from within the Calculated Fields, rather than just calling some in built functions or playing around with the other fields in the BC. This functionality enhances the already huge functionality of the Calculated Fields in Siebel.
1
May
2009
Siebel – ActivateField() split wide open
In Siebel, we generally tend to use the fields on the BC level in a number of ways, one of them being their use in Siebel scripts. The most common functions for operating on BC fields are GetFieldValue() and SetFieldValue() used for getting a value, or setting a value of the corresponding field in the BC. However, Siebel requires using ActivateField() before operating on any field of the BC.
Fields that are not active at runtime should not be used in script. Runtime errors, flawed logic and lost data may be the result of such a practice.
