Posts

Multivalue links and links are one of the basic configuration items in Siebel alongside joins . Although they form one of the foundational blocks for Siebel data model, it surprises me how misunderstood they are.

Siebel log files are not complex to analyse. But, you will end up spending a lot of time going back and forth, and navigating through hundreds of pages to carry out basic analysis.

Debugging Siebel log files is not exactly an exciting affair. You open log files, search for specific statements that you think will drill down to the error, make note of the performance of various SQL statements, and in general navigate through MBs of logs in the hope of locating the issue quickly.

You will see a property called “Long List” against picklists. Although it is often flagged as TRUE for dynamic picklists, there are seldom used against static LOVs. Siebel recommends that any picklist having more than 500 values must have the Long List property set to TRUE.

Siebel is an application accessed by users through browser. There is no external controls to prevent different users from working on the same record. The record may also be updated in the local database on Siebel Remote Client/Mobile devices.

There are two ways to do things - the easy way, and the hard way. Though you would expect all developers to follow the easy way, that is always not the case.

Siebel provides two cursor modes that can be employed for different purposes - unidirectional and bidirectional queries. The mode does not denote how Siebel queries for the record, but more on how the application traverses through the result set.

Requirements for calculating difference between two dates, getting a target date by adding number of days/hours, or working day calculations are quite common. Julian functions rescue us in most of those scenarios.

Siebel is what it is because of the multiple ways in which you can achieve a given task. As I never fail to mention, this can be a boon or a bane depending on the developer carrying out the configuration.

Siebel Bookshelf is invaluable. You get all product documentation from bookshelf. That includes but is not limited to- How do Siebel applications function? User/business scenarios for various Siebel applications Oracle recommended practices for design and development Explanation of Siebel Tools and Application capabilities The earlier way of accessing bookshelf was straightforward.